473,321 Members | 1,667 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

SQL Server Database Comparison

I am currently in the process of making changes to an application using
a SQL Server database and have made changes to a development copy of the
live database which includes changing and adding columns to tables and
updating stored procedures.

I was wondering if anyone knew of any free software that could produce
at least a list of the changes between the databases and possibly a
script to allow for easy updating of the live database.
*** Sent via Developersdex http://www.developersdex.com ***
Jul 23 '05 #1
5 1707
Don't get me started on free software. There is of course no such thing.

Red-Gate SQL Compare is one product that does what you want. It's free to
download on trial.
http://www.red-gate.com/SQL_Compare.htm

--
David Portas
SQL Server MVP
--
Jul 23 '05 #2

Pity that a free product does not exist :(

Is this the best one to use or are better products available?

Stuart
*** Sent via Developersdex http://www.developersdex.com ***
Jul 23 '05 #3
> I am currently in the process of making changes to an application using
a SQL Server database and have made changes to a development copy of the
live database which includes changing and adding columns to tables and
updating stored procedures.

I was wondering if anyone knew of any free software that could produce
at least a list of the changes between the databases and possibly a
script to allow for easy updating of the live database.


It's not free, but our tool, Database Workbench, includes a Schema
Compare tool as well: www.upscene.com/products/dbw/
--
With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Jul 23 '05 #4
Hi Stuart,

What is better depends on your needs/goals and, as far as comparing and
upgrading databases goes, a matter of testing products for yourself.
My company has a tool called DB Ghost (www.dbghost.com) that can not
only compare and synchronise databases (which it does very well) but
can build them from a full set of drop/create scripts (that describe
every object) held in your source control system.

What this means is that you can use check out/check in to modify, say,
a table create script. If you wanted to add a column you simply
include it in the create statement. This, in turn, means that your
'source' database becomes the set of drop/create scripts which allows
you to baseline and release your code directly from source control.
This is an amazingly powerful concept that, currently, no one else
provides.

DB Ghost builds a brand new database from the drop/create scripts and
then uses that as the source for a compare and upgrade of your real
target database. This gives you a target database that EXACTLY matches
a set of audited and baselined scripts in your source control system.

As a developer you simply use the source control system for database
code changes in the same manner that you would for any other
application code change. A simple process is one that is more likely
to be followed and the DB Ghost Process is simple, powerful and
guaranteed to give you a full audit trail of your changes, who, when,
why and what.

Regs,

Malc

Jul 23 '05 #5
Stu
It's not really free, but if you have access to Visual SourceSafe, you
can script your databases out to a project (using the SQL-DMO object
model) and do diff files that way. We do this at our office, since we
don't have a large budget for SQL development/administration.

Other solutions are probably better, but this works.

Stu

Jul 23 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: kim | last post by:
Hi All, I had two Window NT 4.0 Server, say A and B... We recently upgraded from MS SQL Server 6.5 to MS SQL Server 2000 on Computer A, and for Computer B, I installed SQL Server 2000 from...
6
by: Martin Meyer im Hagen | last post by:
Hello, I've got installed Win 2003 SBS Premium with the SQL Server 2000 on a server machine. It works almost fine, except the application which uses the SQL Server. The main part of the...
5
by: John | last post by:
I need to upsize my Access 2002 "database" to a larger database. I would like to use Access projects to manage the database. With this preference, it would seem MS SQL Server 2000 is the ideal way...
1
by: Darryl Kerkeslager | last post by:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp SQL Server Express was developed with two distinct uses in mind. The first is as a server product,...
8
by: pmud | last post by:
Hi, I am using a compare validator in asp.net application(c# code). This Custom validator is used for comparing a value enterd by the user against the primary key in the SQL database. IF the...
4
by: z | last post by:
To reconfigure oracle9i from server to client operation, two files need to be modified: listener.ora (for the server IP address), and tnsnames.ora (for user permissions). What are the...
5
by: B1ackwater | last post by:
We've fooled around with Access a bit, but only using the single-user store-bought version. It seems to be a good database - versatile and infinitely programmable - and can apparently be used as a...
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
2
by: rhaazy | last post by:
I need to know how I can format a string in C# to get the current date/ time, so that I can do a comparison against a date time column in MS SQL Server 2005. The date/time column in the database...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.