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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 recplication from sql2000 to sql2005

Author  Topic 

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2008-12-02 : 10:03:01
how can i make a replication between 2 database
which the source is on sql2000 and the destination is on sql2005
assumimng all table stucture is the same

thanks in advance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-02 : 10:18:52
Which Replication? See booksonline for Replication.
Go to Top of Page

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2008-12-02 : 10:22:15
belive me i know how to do from 2000 to 2000

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)
Go to Top of Page

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2008-12-02 : 10:22:37
i know from 2000 to 2000 but no
from 2000 to 2005

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-02 : 10:32:33
Open up your SQL 2000 with SQL 2005 Management studio (SSMS)(client tool) and start Replication .
Go to Top of Page

jholovacs
Posting Yak Master

163 Posts

Posted - 2008-12-03 : 12:28:59
I think it's dependent on what type of replication you're doing. Some types simply will not work across major versions like that.

___________________________
Geek At Large
Go to Top of Page

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2008-12-04 : 11:28:21
sodeep i tried
when i try to add the sql2005 to the sql2000 managgment studio if fails!


Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-04 : 11:30:46
Which replication is it?
Go to Top of Page
   

- Advertisement -