May 29, 2005 at 6:46 am
Hi All
I have situation.. where I have to do
- Validate Data from target Database against source Database Structure before upgrade target database from source database.
I would like advise on it that which would be the ideal method to do this process??
Thanx in advance
SqlIndia
May 30, 2005 at 2:48 pm
Hi,
If you want to compare and synchronise schema (structure/metadata) and/or data then I recommend usign DB Ghost (http://www.dbghost.com). Not only can it give you a delta script of the differences between two databases it can also build your database from drop/create scripts held in a source control system. This database can then be used as the source for the compare/upgrade. What this means is that the drop/create scripts in source control effectively become your 'source' database allowing you to perform regular baselines/builds which means you can have as many snapshots of your schema/static data as you wish.
The DB Ghost Process, which is what the software tool DB Ghost enables, is a truly new and unique way to manage your SQL Server changes that is so obvious you'll wonder why no one has done it before.
Better than that, once you've used it you'll never want to go back to the old ways of managing SQL code again.
Regs,
Malc
Malcolm
DB Ghost - Build, compare and synchronize from source control = Database Change Management for SQL Server
www.dbghost.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply