Brian's Blog

items I see across my tribes

SQL Server - script out database schema and data

October 06
by briancarter 6. October 2008 14:13

If you need to script out a database (schema & data), I found a great tool on CodePlex: Database Publishing Wizard.  After installation, make sure to create a shortcut to the GUI tool: "C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\SqlPubWiz.exe".

The Database Publishing Wizard enables the deployment of SQL Server 2005 databases (both schema and data) into a shared hosting environment on either a SQL Server 2000 or 2005 server.

http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard&referringTitle=Home

 

DatabasePublishingWizard.msi (2.14 mb)

Categories: Development

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading




 Questions or Feedback, my contact information is located on my About page.


The opinions, thoughts, and comments made in these blog posts are solely my own (unless otherwise stated). They do not reflect the opinions, thoughts or practices of my employer, my universities, my family, or anyone else. Also, I retain the right to change my mind about anything I publish here without having to go back and edit posts that occurred in the past. 

These are my opinions, or just as likely, someone else's opinions that I leveraged for my own.