Database compare tool ???
-
Hi, Our system is up and running with the client , but we often need to make many changes in Database structure (Add/Modify views,tables,SPs etc). Now every time we make an update here, we need to keep our database definitions consistent with client's version of DB. Can you please suggest some useful tool which can compare Database definitions and points out all differences. P.S. We used Database Comparator before. But its not very efficient. We added & re-ordered coloumns in a View and it couldnt track that change. Any help is appreciated. Thanks "Learn from the mistakes of others... you can't live long enough to make them all yourselves!!"
-
Hi, Our system is up and running with the client , but we often need to make many changes in Database structure (Add/Modify views,tables,SPs etc). Now every time we make an update here, we need to keep our database definitions consistent with client's version of DB. Can you please suggest some useful tool which can compare Database definitions and points out all differences. P.S. We used Database Comparator before. But its not very efficient. We added & re-ordered coloumns in a View and it couldnt track that change. Any help is appreciated. Thanks "Learn from the mistakes of others... you can't live long enough to make them all yourselves!!"
I have one doubt After client using your database, is it a good practice to do changes in database definition frequently ?
string Cheers = "Navaneeth!!" www.w3hearts.com
-
I have one doubt After client using your database, is it a good practice to do changes in database definition frequently ?
string Cheers = "Navaneeth!!" www.w3hearts.com
-
I have one doubt After client using your database, is it a good practice to do changes in database definition frequently ?
string Cheers = "Navaneeth!!" www.w3hearts.com
-
Hi, Our system is up and running with the client , but we often need to make many changes in Database structure (Add/Modify views,tables,SPs etc). Now every time we make an update here, we need to keep our database definitions consistent with client's version of DB. Can you please suggest some useful tool which can compare Database definitions and points out all differences. P.S. We used Database Comparator before. But its not very efficient. We added & re-ordered coloumns in a View and it couldnt track that change. Any help is appreciated. Thanks "Learn from the mistakes of others... you can't live long enough to make them all yourselves!!"
Red-Gate softwares SQL Compare[^] Works great. Not free, but worth the money.