SQL Server/MSDE Development

[drluggo]

I am doing development for a project and we are using a SQL server database. I do some off-site development on a computer not connected to the target SQL server. On the developmetn machine, I have loaded MSDE and I am able to connect with and administer the sample SQL server databases through Access. Can anybody tell me how I can transfer the target database onto the development machine so that I can work with the table structures, etc? I do not need all of the data on the devleopment machine, just the table structures, stored procedures, security settings, etc. so that I can do my ASP.NET development.

Any help would be appreciated.

Thanks,
Chris

 

[petermeachem]

http://www.msde.biz

has a couple of tools that make this a breeze. The backup software will dump your data so you can restore it to the main database. His query tool is useful too.

http://www.therockalltimes.co.uk

http://www.robotwisdom.com/

 

[tlbroadbent]

You can use SQL-DMO to script your databases. I do this from Access. See the script in faq183-1637 - "How can I script my SQL Server databases from Visual Basic?"


If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm