[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 752
  • Last Modified:

MS sql 2003 to MS sql 2005 database replication

I have an existing MS sql 2003 std server with a single database on it
I have a new fresh MS sql 2005 std server built...

I would like to duplicate the databse that is on the 2003 server on to the 2005 server and set up replication so that i can slowly migrate the users applications from the sql 2003 to the sql 2005 so that both can be accessed and written to while i do the change ove is this possible to do ?
0
MVDRUM
Asked:
MVDRUM
1 Solution
 
chapmandewCommented:
>>I have an existing MS sql 2003 std server with a single database on it
No you don't...no such thing as SQL 2003.  you can have a server 2003 OS w/ some flavor of SQL on it though.

you can backup your database on the one server, copy the backup file over, and restore it on the other 2005 server.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I agree that there is no SQL 2003...
you probably have a Small Business Server 2003 (which includes sql 2000).

that said, you will probably want to set up a (multi-master) merge replication between the 2 databases
0
 
MVDRUMAuthor Commented:
oh oh...sorry guys...thats a bad typo to make...should be SQL 2000...
0
 
TAB8Commented:
To do this you will have to setup Merge Replication ....

The SQL 2005 server will have to be setup as the publisher ...  and the SQL 2000 as the subscriber ...

The publication will have to be created in SQL 2000 comapability mode ...

Also you need to be aware that by settign up merge replication that this will create a rowguid column on every table that you want replicate.  Just make sure your app can handle this

Here is a good link to get you started ..
http://www.codeproject.com/KB/database/sql2005-replication.aspx 


0
 
MVDRUMAuthor Commented:
Exactly what im after...ty sir
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now