Search
Home
Articles
Backup
Books
Certification
FAQ
Products
Replication
Scripts
Seminars
Training
TSQL

MSDN Fourms
Fort Worth SSUG
Oklahoma City SSDG

Resume

Champion Valley Pens

Schema Manager 1.0 1 2 3 4 5 6 7

If you select an object and click the Diff button, you will see a visual compare of the objects.  From here you can synch the differences.  This version had a bug that has been fixed in the next version when dealing with primary keys.  It would always indicate a primary key as being different in the comparison when in fact there was no difference at all.

schema10-07.gif (16676 bytes)

If you select the synch option, you will get a preview of the script that is going to be executed.  You can execute the script, save it to a file, or e-mail it.

schema10-08.gif (8354 bytes)

Selecting a report will generate an object report similar to the one here.  If you choose not to select a single object, you can synchronize all of the differences in one operation.  When you do this, a dialog similar to the figure below will appear.

schema10-09.gif (7850 bytes)

Schema Manager 1.0 1 2 3 4 5 6 7

Michael R. Hotek

All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.