Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
multiplex77
Starting Member
24 Posts |
 Posted - 2007-04-02 : 23:00:33
|
| Hi everyone,I have two MSSQL 2000 databases (DEMO and LIVE) sitting on a remote, shared server. I want to migrate the schema and data of DEMO to the LIVE (overwriting LIVE's contents). But because this is all on shared hosting, I am not able to do a backup and restore (as I do not have access to the backed up files). I was hoping to use Database Publishing Wizard [url]http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard[/url] but when I run it on the DEMO server, I hit this error:- Gathering list of objects to script (Error)Messages• This method or property is accessible only while working against SQL Server 2005 or later. (Microsoft.SqlServer.Smo)I take it to mean that Database Publishing Wizard can only be used on MSSQL 2005.Is there any other workaround in this case?Thanks for the help. |
|
|
multiplex77
Starting Member
24 Posts |
Posted - 2007-04-04 : 00:50:51
|
| I managed to accomplish what I wanted by downloading the latest version of the Database Publishing Wizard 1.1, which is available here: http://www.codeplex.com/sqlhost/Release/ProjectReleases.aspx?ReleaseId=2859 |
 |
|
|
|
|
|
Migrate remote MSSQL DB to another remote MSSQL DB