MSDE - Adding Tables and Data
I want to distribute an application that accesses a MSDE SQL DB. After I install MSDE on the new PC, how do I populate the tables with the data. Example: I have 500 records of a product line that do not change. Without writing every record into code and then inserting each record into the table, how can I update the new table with my products? If it were an access db, I could simply copy the DB to the users pc. With MSDE is there a similar way of populating the data??
But Lets say I am selling this application
Lets say I sell this application over the internet. I can't go there and install Enterprise manager. Nor do I want to install from access. There should be a way to script it into the installation routine???
Thanks for any help.
You have 29 posts same as me.