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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-10 : 09:25:39
|
| Dayron writes "I have a database that I am running on SQL 7. We would like to replicate the DB to an affiliate company who is running SQL 2000. We have a VPN established and we have connectivity. However, when I try to register the remote SQL2k server to begin replication I get this error:You must upgrade your SQL Enterprise Manager and SQL-DMO (SQLOLE) to connect to this server. It then asks if I want to register it anyway.Is there a way I can set up replication without having to upgrade to SQL 2000? I am fairly new to SQL. THanks!" |
|
|
admin001
Posting Yak Master
166 Posts |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2002-10-16 : 08:48:13
|
| If you want to replicate data to another server, it's not necessary to register that server in Enterprise manager. It is necessary, however, that you have it as a linked or a remote server. You can then add this server as a subscriber and push a subscription to it. If you want to manage that server remotely I would suggest upgrading EM or using Terminal Services or a tool such as NetOp to remote to the box. SQL 7 cannot register a 2000 Server.JamesH. |
 |
|
|
|
|
|
replication between SQL 7 and SQL 2000