Walk in the clouds how to compare the number of pens on a table

Source: Internet
Author: User
Keywords Cloud datasheet

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.