CODEWITHSUNDEEP
sqlsql-server-2005t-sqlcomparedatabase-schema
larryr
larryr

Reputation: 1588

SQL schema Table compare

I'm looking for an app that will compare the layout of 2 SQL tables. When developing in a DEV environment, I need a tool that will make the production tables exactly like the DEV tables (the layout).

Upvotes: 0

Views: 379

Answers (4)

Mikhail
Mikhail

Reputation: 9285

You can try to use the SQL Examiner tool from the SQL Accessories.

Upvotes: 0

Jamie LaMorgese
Jamie LaMorgese

Reputation: 44

BeyondCompare can do this for you I believe.

Upvotes: 1

Dariusz Dziewialtowski-Gintowt
Dariusz Dziewialtowski-Gintowt

Reputation: 11

I wrote a program called "SQL Server Comparison Tool" (SCT for short). You can try it for free for 30 days; I can extend that period to 90 days.

You can download SCT from www.sql-server-tool.com

SCT can compare both structure and data. You can "record" comparisons so that you can "re-play" them later without need for entering parameters again.

Upvotes: 1

Conrad Frix
Conrad Frix

Reputation: 52645

SQL Compare from Red Gate and ERWin are two tools that work. Neither are free

Upvotes: 1

Related Questions