|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Copying Database DataI'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! 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%20Publishing%20Wizard Scott Guthrie guides: http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx http://weblogs.asp.net/scottgu/archive/2007/01/11/tip-trick-how-to-upload-a-sql-file-to-a-hoster-and-execute-it-to-deploy-a-sql-database.aspx Regards, Plamen Ratchev http://www.SQLStudio.com Thanks, I'll check it out.
Show quote "Plamen Ratchev" <Pla***@SQLStudio.com> wrote in message news:%23rUXxSZSHHA.996@TK2MSFTNGP02.phx.gbl... > 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%20Publishing%20Wizard > > Scott Guthrie guides: > http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx > http://weblogs.asp.net/scottgu/archive/2007/01/11/tip-trick-how-to-upload-a-sql-file-to-a-hoster-and-execute-it-to-deploy-a-sql-database.aspx > > Regards, > > Plamen Ratchev > http://www.SQLStudio.com > >  |
|||||||||||||||||||||||
Other interesting topics