What would you do if you want to generate script that contains data and schema too. To generate script with schema is pretty simple but what about data. Microsoft Database Publishing Wizard is the tool that work with SQL server 2005 to generate that kind of script. Below are the steps to get started.
Step 1
Step 2
Step 3
Step 4
Step 5
Step 6
Step 7
Step 8
this is the example of database publishing wizard 1.1. I have not used the versions after 1.1 because this version served all my purpose.
Download Microsoft SQL Server Database Publishing Wizard 1.1
if you are sql server 2008 user then you can not use this :) because good news is that sql server 2008 has this wizard by default.
Please follow http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx link for sql server 2008 database publishing.
Share your thought with me !! :))
No comments:
Post a Comment