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