setting up the customer database

rbuser

Dear all,
I think I am missing a big step in using the end-user tool so
apologies of this seems obvious.

I have installed the end user tool on my machine, and from the Delphi IDE
have played around with the user report example for SQL server.
I have used the datadictionary to build the table list and the field list. I
do not like the way it builds the join table so I have added those records
myself.
I now have a product database with the RBxxx tables populated for my
application.

I now want to deploy this to my customers. I can easily create the new table
structures for the RB tables, but how do I populate them with the same
records? I was expecting some sort of utility.

regards
--
John Evans
Technical Director
Clear Advantage Ltd

www.Clear-Advantage.co.uk

digitalmetaphors

One way to do it is to use the DTS Import/Export feature of the SQL Server
Enterprise Manager. You should be able to dump the table data to a comma
delimited text file and use that as a basis for which you can turn it into a
SQL script which has an Insert SQL statement in it.


Cheers,

Jim Bennett
Digital Metaphors