March 24, 2003 at 10:10 am
Scenario:
I am using Transactional Replication to complete push subscriptions to SQL 2000 databases from a SQL 6.5 publishing server and distribution server. I currently have this setup and working in production. My delima is occasionally I need to refresh our Model Office environment with my replicated data after I have restored my production database into model office.
I would take down replication and repoint it to my Model Office database, but I have hundreds of tables to deal with.
Question:
What is the optimal way to accomplish pushing my subscriptions to my Model Office Environment?
Note: We have an EMC SAN which restores my Model Office Environment completely (bit-by-bit). Therefore, all of my system tables have data from production."
March 24, 2003 at 10:49 am
Haven't worked with v6.5 replication in some time. Can you script out the replication from EM? If so, then you might be able to set a script to drop the publications, and then repoint them to the new location.
Steve Jones
March 24, 2003 at 2:16 pm
We had a script at one time, but unfortunately that server went away... Is there an easy way to reverse engineer the replication script via EM?
March 24, 2003 at 3:15 pm
Ahh, it's been too long. If I get my copy of VMWare, I might try to reinstall NT4 / SQL 65 just for these questions.
In the new EM, there is a place to script out replication. Might not be in 65. You could try and see if Embarkadero's DBArtisan will do this. Perhaps an eval would let you script replication? Maybe check if SQLCompare (Red-Gate) works with 65. Sorry, but I've been away from this too long. Not sure how to do this or what works.
Steve Jones
March 25, 2003 at 8:03 am
What do you think of this:
How about upgrading a copy of my 65 server to SQL 2000, then setting sp_dbcmptlevel back to 65. At that point, I should be able to generate the replication scripts. Are the replication system tables so different that this would not be worth while?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply