Re: SQL Server metadata compare

From: Lee Grissom (Lee.Grissom_at_REMOVETHISquest.com)
Date: 09/28/04 

Date: Tue, 28 Sep 2004 11:49:19 -0700

Daniel Alvarez wrote:
> Anyone knows a VCL component to compare between two SQL Server
> databases (or one script and a database), and generate an update
> script to get them syncronized?

Well, this may or may not be helpful, but RedGate has a toolkit for .NET
that does exactly what you want. I've not used it personally, but my
team-mate spent a couple months evaluating this technology and gave it his
highest rating. It's not VCL, but C# code.
http://www.red-gate.com/
SQL Comparison and Synchronization Toolkit 

--
Lee

Relevant Pages

  • Re: How do you create a databse?
    ... Wayne Snyder, MCDBA, SQL Server MVP ... I support the Professional Association of SQL Server and it's ... > I think that it may be time to use a script to create databases. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL state (error) is 37000
    ... What is being changed is new footage data. ... SQL Server would always be able to finish the job before the next job needed ... >>It is a way to transport data between databases. ... >>the script below? ...
    (microsoft.public.sqlserver.connect)
  • Re: changing collations
    ... > We have around 150 databases as case sensitive, ... If you want to use ALTER TABLE, I think you still need to script all ... ALTER TABLE ALTER COLUMN command. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: SQL state (error) is 37000
    ... Really all that this script does is send some information to SQL server in ... It is a way to transport data between databases. ...
    (microsoft.public.sqlserver.connect)
  • Re: finding out when last time column was updated
    ... SQL Server keeps no record of when columns are altered. ... The only idea I have is that you could find a backup from two years ago and ... compare the two databases... ...
    (microsoft.public.sqlserver.server)