Posts Tagged ‘advice’


The purpose of Merge is where you have two tables – maybe a transaction table and a staging table which could have records to be inserted and/or replaced in the transaction table.  Or maybe you have two tables of people (staff or patients) – one table (the master) with last years data and one table from this year, and you want to bring the master up to date with additions, updates or removals. Under SQL 2005 you would have had to


Top 10 things to watch out for in a data migration project

When undergoing a data migration, from one system to another, or from one database format to another, there are a number of common issues which crop up.  Any of these can cause the migration to fail.   These issues can be mitigated by careful planning before starting the migration project, and by comprehensive testing before the migration is signed off as complete. The top 10 data migration issues most likely to cause