September 11, 2003 at 4:57 am
Hi,
I need to build a test platform for some apps we are developing and have been tasked to make sure 2 sets of databases are exactly the same at all times ...
Replication seems to be the way to go but is it the best solution ...
My boss wants me to script all the databases but this would be a nightmare to keep all the database scripts current ...
The databases will be sat on 2 different servers.
Thanks in advance
Steve
September 11, 2003 at 6:15 am
I would suggest log shipping, but I take it both of your databases will be subjected to updates - will they?
Cheers,
- Mark
Cheers,
- Mark
September 11, 2003 at 6:33 am
no, what we're gonna use the second server for is development and as a backup. this is all because we moved the main server, which we also use for dev work, and when we brought it back up the drive with the operating system on it blew up. the sql and backups were on the other drive so we were ok to restore from the backups BUT we had to recreate the users and reset permissions on table and stored procs.
naturally we want to avoid this in the future so i was thinking of replicating the dev server to the main box and then structural changes to all databases will be copied automatically, without the need for scripting.
would this be the way to go ?
September 12, 2003 at 12:29 am
I would think you can achieve this efficiently by simplifying the process.
Log Shipping is more easier and less complicated than Replication.
Again sync-up of scripts can easily be done with some 3rd party product like Embarcadero's Change Manager.
.
September 12, 2003 at 2:16 am
Thanks,
Unfortunately my boss won't buy anything we could write and so we're going down the SQL-DMO route ...
Nice to do some programming again though 🙂
Steve
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply