Simple question on maintaining sql server's table datastructure
-
I am in a scenario where my table's datastructure keeps on changing. For eg. sometimes the primary key changes, sometimes the field name changes and so forth. Is there any tool in the internet which helps in monitoring such kind of changes by comparing the previous database and the changed database? If you have any idea of such tools, could you please post it here? Because it is giving me a very hard time.
-
I am in a scenario where my table's datastructure keeps on changing. For eg. sometimes the primary key changes, sometimes the field name changes and so forth. Is there any tool in the internet which helps in monitoring such kind of changes by comparing the previous database and the changed database? If you have any idea of such tools, could you please post it here? Because it is giving me a very hard time.
We use Red-Gate comparer to compare databases. you can check it in Red-gate.com. It also alows tou to create scripts depending on a db schema. meanwhile the question is..What is the scenirio there your db schema keeps on changing. If the promary key keeps on changing then it is no more a promary key itself.
Thanks Laddie Kindly rate if the answer was helpful