SQL Script Dependencies and Contraints -> OUT to pull into modified db
Posted on 2008-06-24
I have 2 databases... One original and one modified (they are UGLY) :)
My issue is that after the modification to the 'modified' one, alot of the contraints/dependencies seem to have been exluded or rearranged....
150+ tables datatype change from int to varchar(30) was the modification (dont ask, as I inherited this with much resistance... :))
What I would like to be able to do:
1. script the contraints and foriegn key stuff (I am not a sql dba at all) from the original
2. change the script if needed to reflect the varch(30)
3. run the cript on the modified db....
Any suggestions/solutions/tools / ???????
Thanks for your time....