Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

setting up the customer database

edited March 2003 in End User
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

Comments

  • edited March 2003
    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


This discussion has been closed.