Database Comparison for SS2K5

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Database Comparison for SS2K5

Database Comparison for SS2K5

Rate Topic

Display Mode

Topic Options

Author

Message

Rofty

Posted Tuesday, September 15, 2009 3:15 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 25, 2012 10:24 PM
Points: 192, Visits: 229

Hey all

I'm working in an SQLServer 2005 environment where we have a production and development database.

Till recently we have been using a trail version of SQL Delta 4 to do Database Comparison between Production and Development databases. The company has decided not to purchase a license for SQL Delta till end of the year.

So ... now I'm kinda stuck.

It seems funny that Microsoft did not include a Database Comparison tool in SQLServer 2005.

Does anybody know of a cheap(free if possible) yet efficient method of comparing databases.

The basic comparison I mostly use is New and Changed Tables, Relationships, Stored Procedures, Views and Functions.

Smile

Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. BigGrin

Post #788006

Silverfox

Posted Tuesday, September 15, 2009 3:23 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 6:50 AM
Points: 2,719, Visits: 1,065

Redgate do a similar tool, not sure about the price though, in comparison.

this link might help

http://weblogs.sqlteam.com/mladenp/archive/2007/11/20/Free-SQL-Server-tools-that-might-make-your-life-a.aspx

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw

Post #788015

spaghettidba

Posted Tuesday, September 15, 2009 3:24 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 3:43 AM
Points: 4,804, Visits: 8,091

I can point you to these free tools:

http://www.codeplex.com/OpenDBiff
http://www.sqleffects.com/Articles/Product/sqlAccordInfo/aboutSqlAccordCommunityEd.html
http://www.sqldbtools.com/
http://weblogs.sqlteam.com/mladenp/archive/2007/08/10/60279.aspx

but I have tried none of them.

Good luck!

Get your two-cent-answer quickly
The Spaghetti DBA

Post #788017

Grant Fritchey

Posted Tuesday, September 15, 2009 8:28 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:06 AM
Points: 13,437, Visits: 25,282

Inexpensive, Red Gate's SQL Compare. Fantastic tool.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #788194

Rofty

Posted Tuesday, September 15, 2009 8:42 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 25, 2012 10:24 PM
Points: 192, Visits: 229

Thanks guys

OpenDBiff will do for know till the managers decide we can purchase SQL Delta.

OpenDBiff ain't the best I've seen but its free and at least I can see what objects needs to be moved/altered in the Production DB.

Smile

Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. BigGrin

Post #788213

Steve Jones - SSC Editor

Posted Tuesday, September 15, 2009 8:51 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:09 AM
Points: 31,526, Visits: 13,864

Microsoft included tablediff in the product, however this isn't necessarily a trivial task. It takes some time and effort to get it working right.

I work for Red Gate, but I'd suggest that if it's a big deal, Apex, Red Gate, any of the vendors are worth the investment to save yourself some time. Or let things slow down and have management realize that they aren't saving $$ by not investing in tools.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #788227

« Prev Topic | Next Topic »

Permissions