• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 753
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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