Solved

free or cheaper equivilents of RedGate SQL compare / Data compare

Posted on 2008-10-14
4
647 Views
Last Modified: 2011-10-03
Hi I'm looking for tool, that will help me view changes to a database. I've used RedGate SQL compare / Data compare which are both excellent products. I'm looking for a free product. I heard MS has a few app, but i couldn't find in on google. Any thoughts on what it could be called, or any suggestions?
0
Comment
Question by:frosty1
4 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 22713171
0
 
LVL 5

Expert Comment

by:Cvijo123
ID: 22713251

As far as i know there is no free comparer that i could relay on and said i can hit F5 without warries i wouldnt delete/change something wrong. If there is any free it has limitations how many tables or SP's u can compare/snyc.

RedGate and Apex have very good tools for compare schemas and data, what Microsoft have is implemented in Visual Studio Team Foundation Server (together with Visual Studio Team System Database Editon) and MS soulution is much much expensive than redgate and apex one.

Anyway if u find any equaly good as 2 mentioned i would like to know too :) but until then good luck searching :)
0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 22713878
Think the one chapmandew posted looks pretty good...

Ever heard of Toad ? Not sure if it is what you looking for - seems to be more of a SSMS replacement rather than comparison - there is a comercial version with lot more features (but then that costs). http://www.toadsoft.com/get2knowSS/index.html

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

0
 

Author Comment

by:frosty1
ID: 23083900
thanks guys, really like

http://www.xsqlsoftware.com/LiteEdition.aspx

very simple " saids what it does on the tin " app. There is a limit to the amount a tables you can compare on the lite version. Tho is really fair price.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Some sers suddenly getting error popup msg 28 89
coldfusion upload spreadsheet into the databse 2 44
script to send html report 3 32
Get the latest status 8 31
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question