Monday, March 12, 2012

Integrate changes into MSDE Database?

I have a module that requires modifcation to the database. How do I adopt the following instructuions for use with MSDE?

1. Create a MSSQL structure.
2. Open a query anylizer and copy the CreateDB.SQL file. Run it.

Thanks,
ScottYou should be able to use the osql.exe utility. To run the CreateDB.SQL file, you can go to the Windows command prompt, go to the directory containing the .SQL file, and issue a command such as:


osql -E -i CreateDB.SQL

Terri|||Thanks for responding Terri.

I have created a seperate MSDE for each on the Starter Kits I'm tinkering with. When I run CreateDB, do I need to specify which MSDE?

Scott

No comments:

Post a Comment