How do I Publish my Microsoft SQL server database
Posted by Jonathan Hughes on 14 April 2009 12:58 PM
In order to publish your database to your hosting package, you need to use the SQL database publishing wizard.
Download from the url above, and install on your local machine.
Run this from the start menu and go through the options to select your local database using Windows Authentication.
Follow the options from here to Script your database to file and save the file to your local machine.
Once you have this, open SQL management studio,
Enter your new Database details
Your db user name
your db password.
Once connected, find your database in the list and right click, then select New Query.
Then find your scripted .sql file and open this using notepad. Select All the contents and Copy. Then paste this into the Query window In SQL management studio.
Then click Execute from the icons at the top of the screen.
This will then populate your remote database with the content of your local database.
Once complete, change your connection string to reflect the following:
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;