Copying Database Data

[Jonathan Wood]

I've been developing a Web site on my local computer and would like to
publish it to my Web host (currently, GoDaddy.com).

According to GoDaddy.com, I should be able to create a script that will
recreate my database on the server.

Can anyone tell me how to generate this script? I'm using SQL Express
(Microsoft SQL Server on the Web server).

Hopefully, I'll be able to copy all data, schemas, procedures, etc.

Thanks!

 

[Plamen Ratchev]

Hi Jonathan,

Take a look at the Database Publishing Wizard. It is designed for deployment
of local databases to remote hosting environments. The tool has both
graphical and command line interfaces, and there is a way that you can
update your database via a Web page. Here are more details:

Database Publishing Wizard:
http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database Publishing Wizard

Scott Guthrie guides:
http://weblogs.asp.net/scottgu/arch...e-to-a-remote-hosting-environment-part-1.aspx
http://weblogs.asp.net/scottgu/arch...-and-execute-it-to-deploy-a-sql-database.aspx

Regards,

Plamen Ratchev
http://www.SQLStudio.com

 

[Jonathan Wood]

Thanks, I'll check it out.