I have a client with the same query as Oscar Delatorre has posted above.
My client wishes to replicate 3 SQL servers to 1 SQL server using Replistor . I Dont believe that this is possible can anyone please enlighten me as to whether this is possible.
When replicating SQL, we also replicate the master DB. The master DB contains configuration information about the location and paths of all the other DB's that are used for the Default or named instance.
It is possible to replicate SQL in a many to 1 relationship. However, if you try to start SQL on the Target machine, the other instance that is being replicated may bring up the DB's in Suspect mode b/c it cannot 'find' them when the master DB is read for thier paths.
One work-around for this would to have only SQL instances installed (or only 1 Default and the other names instances). This would have to hold true for both the Sources and Target. Therefore, different paths can be defined for all the DB's. As well, it is possible to install several named instances on the Target. I recommend named instances b/c you cannot have more than 1 Default instance. You would have to install SQL 3 times on the Target for the different instances.
I've done 8 to 1 before. The only way it can be done with Replistor is for all source servers to have different instances that go to different paths.
The client that I was working with took a down time to swap from the default instance to a new one for all 8 servers. Then we were able to replicate all 8 to the one server. The target server simply had 8 instances installed that matched up with the 8 source servers.
When testing failover, we were able to just test one instance at a time. For the failover piece, however, I was using Autostart so it simplified that piece of it.
Revilo-o3td-
12 Posts
0
July 11th, 2007 06:00
I have a client with the same query as Oscar Delatorre has posted above.
My client wishes to replicate 3 SQL servers to 1 SQL server using Replistor . I Dont believe that this is possible can anyone please enlighten me as to whether this is possible.
Some guidelines would be greatly appreciated
Regards
Revilo
dramjass
151 Posts
0
July 12th, 2007 07:00
It is possible to replicate SQL in a many to 1 relationship. However, if you try to start SQL on the Target machine, the other instance that is being replicated may bring up the DB's in Suspect mode b/c it cannot 'find' them when the master DB is read for thier paths.
One work-around for this would to have only SQL instances installed (or only 1 Default and the other names instances). This would have to hold true for both the Sources and Target. Therefore, different paths can be defined for all the DB's. As well, it is possible to install several named instances on the Target. I recommend named instances b/c you cannot have more than 1 Default instance. You would have to install SQL 3 times on the Target for the different instances.
Another way of putting what I am talking about:
Source1
MSSQL
Source2
MSSQL$Instance1
Source3
MSSQL$Instance2
Target
MSSQL
MSSQL$Instance1
MSSQL$Instance2
I have not had an opportunity to test this, but I do not see why it would not work.
Give it a try and let me know what happens.
Ryan9
45 Posts
0
July 30th, 2007 14:00
The client that I was working with took a down time to swap from the default instance to a new one for all 8 servers. Then we were able to replicate all 8 to the one server. The target server simply had 8 instances installed that matched up with the 8 source servers.
When testing failover, we were able to just test one instance at a time. For the failover piece, however, I was using Autostart so it simplified that piece of it.