Hello All. I need a help scripting this.
I don't want to use Red gate or any other tool.
Say I have three databases.
Test 1 DB, Test 2 DB, Main DB.
Everything have same columns and tables but differ somewhere in constraint names.
I have to generate a script that compare two databases and gives me the list of constraints that are different so that I can change them. (automation of naming conventions would be really great)
so that it makes either Test 1 or Test 2 ideal. and so that I can check that with the main database and then update any changes.
Please help me with this.. Thanks