Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Why can't I script my database?

Author  Topic 

napoleonxv
Starting Member

1 Post

Posted - 2007-09-06 : 02:33:39
I am wanting to create a script for my database structure. From Management Studio, I right-clicked on the database and did "Tasks->Generate Scripts". When I did so, I got a list of databases to select for scripting -- but the database I had clicked on wasn't in the list, only the predefined databases (master, model, etc.) This happened both when I logged in as a user that I created (mapped to privileged roles) and as 'sa'. Why would my database be missing from the list?

kishore_pen
Starting Member

49 Posts

Posted - 2007-09-06 : 03:49:06
I've developed one utility related to this, using this utility, you can generate entire database DDL script. It is developed in VS 2005 and SQL 2005. If you are interested, download the utility from <<http://www.ipdg3.com/sourcecoderesults.php?option=sourcecode&id=000594>>.
:)
Go to Top of Page
   

- Advertisement -