How to prepare schema sync scripts?
Posted on 2013-06-03
I have 2 db schema (source and destination). I would like to convert the source schema to destination schema by providing sync script. What are the steps I need to perform such as Remove the constraints, perform datatype change, Delete all indexes, Delete FKs, Delete PKs and so on and in which order? I know some tools are there in market. But my customers don't accept it. How to perform in T-SQL? Please assist.
It would be great if the sql scripts are run in order using SSIS package. Could you please suggest how to achieve this?
I know the question is big and hard one. Please bear with me and provide your solution.