lundi 5 janvier 2015

Find difference between two database and output them in a script sql


I had a SQL Server 2008 R2 database. I have dump it and made some mods in a copy.


So, I have two databases:


1) the older version 2) the new version


I need a script SQL to update the number 1) to the number 2) (an update).


Does it exist some tools or similar to make this? Or have I to write the script on myself?


EXAMPLE:


Two simply databases, with only one table.


DBOLD.TABLE1: ID, NAME


DBNEW.TABLE1: ID, IDFK, DESCRIPTION


In this case, I'd need a script to add IDFK and DESCRIPTION and drop NAME.


I hope my goal is clear to you.





Aucun commentaire:

Enregistrer un commentaire