April 15, 2009 at 7:45 am
Hi there,
I'm not sure if I posted this question in the correct forum, but here it is :
I have multiple database :
1) Development
2) Testing
3) Production
The changes are first made in development database, after that is is transferred to the test database, en later after all the tests passed, it is going live in the production database.
My question is :
What is the best way / best tool to compare the changes between the database / schema's.
What we want to compare is :
everything from a table, column, stored procedure etc etc...
Thank you all very much
Nathan Boor
April 15, 2009 at 7:51 am
I use redgate sql compare for this and it works really well..
April 15, 2009 at 1:53 pm
I use redgate SQL Compare and SQL Data Compare for this. The tools are well worth the investment.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 16, 2009 at 4:27 am
Hi all,
Thanks for the replies.
But is there nothing in SQL Server 2005/2008 that can do that ??
And what do you think about Visual Studio Team System Database Edition ?
What is the best tool ?
Thank's
Nathan
April 16, 2009 at 9:29 am
I am not aware of a native tool that can do the same things. You can build your own (sort of) using SMO with Powershell or other utilities.
I have no experience with Visual Studio Team Edition - so I couldn't comment. However, I do use the redgate tools and they are well worth the money.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 16, 2009 at 10:08 am
The VSTS tool is Red Gate's under license.
There are other compare tools, but there is no best one. Try one or two, pick the one that works for you.
April 16, 2009 at 10:38 am
Steve Jones - Editor (4/16/2009)
The VSTS tool is Red Gate's under license.There are other compare tools, but there is no best one. Try one or two, pick the one that works for you.
Now that is interesting information - did not know that.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 16, 2009 at 2:59 pm
Steve Jones - Editor (4/16/2009)
The VSTS tool is Red Gate's under license.There are other compare tools, but there is no best one. Try one or two, pick the one that works for you.
Hi Steve,
What exactly do you meen by VSTS tool is Red Gate's under license ?
Do you meen that the VSTS tool is the same as Red Gate's (under water ?) ?
Thanks
Nathan
April 17, 2009 at 5:51 am
If you have Visual Studio, here you have a manual with MS Source Safe http://www.dbazine.com/sql/sql-articles/cook11
March 13, 2016 at 6:20 pm
I agree with Steve Jones. There are many tools and they all provide the same basic functionality but with different UI and different features. You just choose the one that suits you best.
SQLC is a good tool and very cheap compared with most other DB Compare tools and has good UI and features.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply