May 29, 2005 at 6:48 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 have advise on it that which would be the ideal method to do this process or how this can be achieve?
Thanx in advance
SqlIndia
May 29, 2005 at 11:08 am
Look into DTS packages - if both your source and destination databases are sql server it makes your job easier still - you could use queries for your validation before copying data!
You could try one sample table as test to begin with - the dts wizard will walk you through the steps!
**ASCII stupid question, get a stupid ANSI !!!**
May 30, 2005 at 1:50 am
Here's what I do.
Make a copy of the target database.
Perform comparison and synchronization and produce a delta script using the copy of the target database.
I know the delta script works as I've tested it using the above.
All this is made easy with the right tool - I use DB Ghost http://www.dbghost.com - still the only application that creates a SQL delta script that always works because of the way it created the SQL delta.
regards,
Mark Baekdal
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change management for SQL Server
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply