When the database is transferred to a different server, do you want to be different than the 6184.html "> datasheet" number
If the data value or the number of pens is different, the representative will still have the application in the transfer process to manipulate the database, resulting in inconsistent data.
Denotes 1:
Using the http://www.aliyun.com/zixun/aggregation/13385.html >visual Studio 2010 Data Comparison tool, you can compare to each data value.
Denotes 2:
Use TSQL + Excel to do
--This syntax is compatible with SQL 2000
--drop TABLE temp_table
--truncate TABLE temp_table
CREATE TABLE temp_table
(
No_of_rows INTEGER,
TABLE_NAME VARCHAR (30),
)
EXEC sp_msforeachtable ' INSERT into temp_table SELECT COUNT (*) as nr_of_rows, '? ' As table_name from? '
SELECT * from Temp_table
--drop TABLE temp_table
--truncate TABLE temp_table
Execute the Script above on two servers
When I paste the value into Excel, I write a formula in the C field: =if (ISERROR (a4,d4,0), A4, "")
If the data on either side is different, it will appear in the C field.