Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Comparing multiple SQL databases Expand / Collapse
Author
Message
Posted Wednesday, April 15, 2009 7:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 20, 2009 8:03 AM
Points: 3, Visits: 9
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
Post #697525
Posted Wednesday, April 15, 2009 7:51 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, March 15, 2014 4:31 AM
Points: 2,808, Visits: 7,173
I use redgate sql compare for this and it works really well..
Post #697530
Posted Wednesday, April 15, 2009 1:53 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 11:17 AM
Points: 4,379, Visits: 9,470
I use redgate SQL Compare and SQL Data Compare for this. The tools are well worth the investment.

Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #697880
Posted Thursday, April 16, 2009 4:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 20, 2009 8:03 AM
Points: 3, Visits: 9
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
Post #698278
Posted Thursday, April 16, 2009 9:29 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 11:17 AM
Points: 4,379, Visits: 9,470
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
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #698589
Posted Thursday, April 16, 2009 10:08 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:31 PM
Points: 32,780, Visits: 14,941
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #698625
Posted Thursday, April 16, 2009 10:38 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 11:17 AM
Points: 4,379, Visits: 9,470
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
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #698677
Posted Thursday, April 16, 2009 2:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 20, 2009 8:03 AM
Points: 3, Visits: 9
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
Post #698922
Posted Friday, April 17, 2009 5:51 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, September 22, 2010 3:05 AM
Points: 83, Visits: 172
If you have Visual Studio, here you have a manual with MS Source Safe http://www.dbazine.com/sql/sql-articles/cook11
Post #699299
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse