Hi,
In most books on ADO.NET programming, a sample database is given as a series of sql instructions (create database, create table, insert into table values (..), etc ), thereby creating the complete mdf/database file. The question arises: how does one create such a SQL script file from an existing .mdf using SSMSEE/SQL Server 2005 Express?
Cheers,
Daniel
Take a look at this thread
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=320987&SiteID=1
|||
Or just use “generate scripts wizard”:
Right-click on the database,
choose “TASKS-> Generate Scripts” and simply follow the wizard steps.
Regards,
Alfred.
