September 27, 2007 at 4:55 pm
I'd like to play around some with replication but don't have access to a multi-server environment. The other day it occurred to me that maybe I could just install multiple instances on my dev machine and set up replication between them.
Before I go through the pain of doing this (and it is a pain as I'm on Vista and consequently have to deal with the service pack headaches and such) only to find out I can't, I figured I'd ask you fine people.
So, can I do it or am I in for a world of hurt? (Note some pain is OK as I'll chalk it up to learning...)
September 27, 2007 at 5:21 pm
Yes, you can.
If it helps, you can replicate between two databases on the same SQL instance. You can make a publication of some tables from one database and subscribe to the publication from from another database - they don't have to be on different servers or different instances.
I have never tried, but I suppose you could replicate a table to the same database with a different name or schema if you really wanted to.
October 2, 2007 at 7:16 pm
Yes, we do this, and one instance is 2000 and the other is 2005
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply