Re: how to find differences between production and test databases
- From: "Mark McGinty" <mmcginty@xxxxxxxxxxxxxxx>
- Date: Sun, 12 Nov 2006 20:18:36 -0800
"Florence" <Florence@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7C5CF617-A44E-4BDF-8A87-8CD03A1B0B9F@xxxxxxxxxxxxxxxx
We have two SQLServer databases on different machines. One is our
production
database and the other our test/development database.
At the moment both databases have exactly the same metadata i.e. tables
and
columns.
The production database differs in a handful of rows. Some rows have been
inserted, deleted and a few modified.
How can we with a few SQL statements can I find out what rows have been
added and what rows have been modified between our test and production
databases?
If there are more than a few tables, I'm not sure how it could be done with
minimal SQL.
There is a great suite of tools available called SQL Compare (that includes
SQL Data Compare) from Redgate (http://www.red-gate.com/index.htm) I bought
the suite a couple of years ago; it has since paid for itself many, many
times over.
-Mark
--
.
- Prev by Date: ADO Recordset to SQLite
- Next by Date: Re: ADO Recordset to SQLite
- Previous by thread: ADO Recordset to SQLite
- Next by thread: Re: how to find differences between production and test databases
- Index(es):
Relevant Pages
|
|
