<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> .Avery Blog [mailto:no
address] <BR><B>Posted At:</B> Wednesday, April 16, 2003 3:06 PM<BR><B>Posted
To:</B> News Gator<BR><B>Subject:</B> Very Useful SQL Tool<BR><BR></FONT></DIV>
<P><A
href="http://dotnetweblogs.com/JAvery/posts/5738.aspx">http://dotnetweblogs.com/JAvery/posts/5738.aspx</A></P>
<P><FONT face=Arial>With the project I am working I have to maintain a
development SQL database, production SQL database, and the scripts to build the
database. Of course whenever a change is made to the development server the
change has to be made to the scripts and the production server.</FONT></P>
<P><FONT face=Arial>I was testing the application today on the production server
and noticed some inconsistencies in the database that were causing problems with
the production application, and I started looking for a way to do some sort of
compare between the two servers. The alternative would have been even more
testing or manually digging through both databases looking for
changes.</FONT></P>
<P><FONT face=Arial>A friend of mine pointed me to a utility called </FONT><A
href="http://www.adeptsql.com/sql_compare_tool_overview.htm"><FONT
face=Arial>AdeptSQL Diff</FONT></A><FONT face=Arial>. I downloaded the demo
version and gave it a shot. After entering both of the
databases it showed me the differences between the two, including
table differences, stored procedures, and more. It then gave me the option to
script the changes from one database to another one item at a time, how cool is
that?</FONT></P>
<P><FONT face=Arial>Needless to say it helped me find and fix
the lingering inconsistencies quickly and easily. If you have to
maintain multiple databases then this tool is a must.</FONT></P>
<P><FONT face=Arial>- James </FONT></P></BODY></HTML>