[MS SQL 2008] Merging the difference of two SQL database (tables, procedures, etc) ???
Posted on 2011-02-25
I have two databases similar to each other, Base A and Base B.
Base A is clean, no data inside.
Base B however, is highly populated, but has more procedures, triggers and views than Base A.
What I need to do is to import Base B structural differences into Base A, the thing is, I can't migrate the data inside Base B, only the structural content (tables, new columns inside existing tables, procedures, triggers, etc).
Again, I just need to get the structural differences from Base B and insert them on Base A.
How can I do this?
Thanks in advance.