original text :Red Gate Series 4 SQL Data Compare 10.2.0.885 Edition Data comparison synchronization tool Complete crack + Use the tutorial

Red Gate Series 4 SQL Data Compare 10.2.0.885 Edition Data comparison synchronization tool Complete crack + Use the tutorial

Red Gate Series articles :

Red Gate One of series SQL Compare 10.2.0.1337 Edition Database comparison tool Complete crack + Use the tutorial

Red Gate The second series SQL Source Control 3.0.13.4214 Edition Database version controller Complete crack + Use the tutorial

Red Gate Series three SQL Server Development tool SQL Prompt 5.3.4.1 Edition T-SQL IntelliSense Analyzer Complete crack + Use the tutorial

Red Gate Series 4 SQL Data Compare 10.2.0.885 Edition Data comparison synchronization tool Complete crack + Use the tutorial

Red Gate Series five .NET Reflector 7.6.1.824 Edition .NET Program decompiler artifact ( Additional plug-in installation tutorial ) Complete crack + Use the tutorial

Red Gate Series six SQL Test 1.0.12.3 Edition SQL Testing tools Complete crack + Use the tutorial

Red Gate Series seven SQL Search 1.1.6.1 Edition SQL Query analysis tool tutorial

Red Gate Series eight SQL Connect 1.1.1.19 Edition Database connection and operation tools Complete crack + Use the tutorial

Usability testing and research show that , Keeping the database consistent and controllable is a headache . Why not try to use SQL Data Compare(SQL Data comparison tools ) To relieve the headache ?

This tool is made up of Red Gate Company produce , Familiar to us .NET Reflector It's this company that launched , its SQLToolbet It's also very famous ,SQL Data Compare yes SQLToolbet One of a series of tools .Red Gate It's from the company Data Compare The tools are stable , To use . It also has a very useful feature yes , You can compare the data in the backup set . That is, after we backup the customer data , Copy it back , You can compare it directly here , Instead of reverting to SQL Server in . in addition , As shown in the figure above , It has one Synchronization Wizard, According to the difference between the two databases being compared , Generate synchronized scripts , Put the script in another database and run it , The two databases are as like as two peas . This feature , I often use it for analysis Kingdee,Microsoft Dynamic AX Business operations of . Illustrate with examples , I want to know that Kingdee ERP What tools did you use to post your purchase order , Apart from opening SQL Server Profiler Tracking its SQL outside , Open this tool again , Compare the differences between the data in the database before and after the purchase order is posted , You can know what data operations it does , According to the meaning of its table name ( The meaning and use of the table are public ), And then infer to its program implementation . According to this tool , to update ERP Business system .

You can download from Red Gate Provided SQL Data comparison tools :

http://www.red-gate.com/products/sql-development/sql-data-compare/http://www.red-gate.com/MessageBoard/viewforum.php?f=96

Red Gate SQL Data Compare Have created , Compare and synchronize , The ability to generate scripts .

I don't recommend directly generating scripts for the entire database , But if your app , Including static data ( Lookup table , Reference data , Configuration data, etc ), You need to use version control for your database , It makes sense to store your schema and static data together as a single structure . Once your database is under source control , It's easy to migrate changes and compare versions , Backup file .

In this article , I'll tell you how easy it is to save your database scripts , Until source control .

One 、 Use the tutorial

First , stay SQL Compare New project in

More careful people may notice ,Red Gate It has brought a lot of interface changes and enhancements .

I'm going to create a set of differential scripts from my database , therefore , I've set up the source ( left ) Server and target server details . And then click Compare Now Button for data comparison

Now? , We've seen the differences in the data , We can also see which data are the same . I've drawn two circles above, and the connected part represents the difference in the number of data records .

We only care about where the data is different , Let's go to tables and views “ On the tab , Select the appropriate table . I chose greentech_Industry_Category surface . Then, at the bottom of the interface, you will see the data difference between the two tables , How many differences , And its detailed data .

You may not be used to this view , I'm not used to it , ha-ha

Let's choose another vertical display .

In the drop-down box Show In Chinese, it means Pivot View Ticked on ,

The view immediately changed , see : The blue part on the left is the column , The yellow part on the right is divided into the left ( The source server ) Data and right ( Target server ) Data comparison

After we have selected the table, we can click deployment wizard Button is deployed . 

There are two ways to open it

1、 Specify the database manager and create the script , But it won't help you synchronize data , You have to execute the script yourself .

ad locum , You can choose a version of the database manager , I chose SQL Server 2008, If you have other versions on your machine , You can also choose 2005 And so on. .

Click on Next Button next

Click on Open Script in Editor Button next

At this time, it will help you create scripts and open the database manager you specified

Then you can do it manually or you need to modify other parts , And then execute .

2、 Help you execute scripts, synchronize data and output scripts to your physical files *.sql

On the right there are 3 Item can be selected .

1、 Back up the target data before deployment

2、 Re compare after deployment

3、 Save a copied deployment script file

You can change the file output path and file name . And then click Next Button next

In the meantime, it will flash through several interfaces , All the way here , Show deployment complete . And then click OK Button to complete the deployment .

If you don't cancel the save file option , Then you can open your folder to see the script

You can also refer to the following article ( english ):

http://www.simple-talk.com/blogs/2009/05/01/sql-data-compare-8-early-access/

http://www.troyhunt.com/2011/08/automated-data-syncing-with-sql-data.html

Two 、 Crack tutorial

Please see the http://www.cnblogs.com/VAllen/archive/2012/09/26/SQLCompare.html

The cracking method, interface and steps are the same

I extracted Red Gate SQL Data Compare MSI Installation package , Only support thunderbolt download : http://dl.tel2.walkbox.vip.xunlei.com/download?scn=tel2&g=C9E134F229C20D4CC59E47E7570D1334802D9600&ui=124993643&ni=ddfe628a-1298-4488-bcc5-6ff87aaefe48&s=11254162&st=3&n=0C3691DEF1051E70614583FDBC311E76653AF1A2FF7351342E5DF8A78E3947325F17F2A3E4724B302E52BA92D1417F0400
Red Gate SQL Data Compare 10.2.0.885 Edition The official download : http://www.red-gate.com/products/sql-development/sql-data-compare/

Red Gate SQL Data Compare 10.2.0.885 Edition Keygen Register machine (7z Format ) download : http://download.csdn.net/detail/caizz520/4600858
( Some people's computers don't install or are not the latest version of decompression software, so they can't decompress 7z Format of compressed files , I recompressed into rar The format has been uploaded , Are free points free login download , Please feel free to download !)
Red Gate SQL Data Compare 10.2.0.885 Edition Keygen Register machine (rar Format ) download : http://download.csdn.net/download/caizz520/4609788

Red Gate The series is not finished , To be continued .

Reprinted friends , Please do not delete the following lines , Regarding this , Thank you !!!

From the original VAllen cnblogs link :http://www.cnblogs.com/VAllen/archive/2012/09/27/SQLDataCompare.html

Red Gate Series 4 SQL Data Compare 10.2.0.885 Edition Data comparison synchronization tool Complete crack + More articles on using the tutorial

  1. Red Gate One of series SQL Compare 10.4.8.87 Edition Database comparison tool Complete crack + Use the tutorial

    original text :Red Gate One of series SQL Compare 10.4.8.87 Edition Database comparison tool Complete crack + Use the tutorial Red Gate One of series SQL Compare 10.4.8.87 E ...

  2. Red Gate Series eight SQL Connect 1.1.1.19 Edition Database connection and operation tools Complete crack + Use the tutorial

    original text :Red Gate Series eight SQL Connect 1.1.1.19 Edition Database connection and operation tools Complete crack + Use the tutorial Red Gate Series eight SQL Connect 1.1.1.19 ...

  3. Red Gate Series seven SQL Search 1.1.6.1 Edition SQL Query analysis tool tutorial

    original text :Red Gate Series seven SQL Search 1.1.6.1 Edition SQL Query analysis tool tutorial Red Gate Series seven SQL Search 1.1.6.1 Edition SQL ...

  4. Red Gate Series six SQL Test 1.0.12.3 Edition SQL Testing tools Complete crack + Use the tutorial

    original text :Red Gate Series six SQL Test 1.0.12.3 Edition SQL Testing tools Complete crack + Use the tutorial Red Gate Series six SQL Test 1.0.12.3 Edition S ...

  5. Red Gate Series three SQL Server Development tool SQL Prompt 5.3.4.1 Edition T-SQL IntelliSense Analyzer Complete crack + Use the tutorial

    original text :Red Gate Series three SQL Server Development tool SQL Prompt 5.3.4.1 Edition T-SQL IntelliSense Analyzer Complete crack + Use the tutorial Red Gate Series three SQL S ...

  6. Red Gate The second series SQL Source Control 3.0.13.4214 Edition Database version controller Complete crack + Use the tutorial

    original text :Red Gate The second series SQL Source Control 3.0.13.4214 Edition Database version controller Complete crack + Use the tutorial Red Gate The second series SQL Source Co ...

  7. Red Gate series - SQL Various tools

    Red Gate series - SQL Various tools Red Gate Series articles : Red Gate One of series SQL Compare 10.4.8.87 Edition Database comparison tool Complete crack + Use the tutorial Red ...

  8. Red Gate Series five .NET Reflector 7.6.1.824 Edition .NET Program decompiler artifact ( Add plug-in installation tutorial 2012-10-13 to update ) Complete crack + Use the tutorial

    original text :Red Gate Series five .NET Reflector 7.6.1.824 Edition .NET Program decompiler artifact ( Add plug-in installation tutorial 2012-10-13 to update ) Complete crack + Use the tutorial Red Gate ...

  9. Red Gate - SQL Source Control Realize to SQL SERVER Source code control for

    Original address :http://bbs.csdn.net/topics/350165431 SQL Server  There hasn't been a good source controller , I tried to write one myself before , Will all   Script   Automatically generated to a directory , ...

Random recommendation

  1. 6.Configure Domain Classes( Configure domain classes )【EF Code-First series 】

    In the previous section , We learned Code-First Default Convention ,Code-First Use the default Convention , According to your domain class , And then generate the conceptual model . Code-First Pattern , Launched a programming pattern : Convention over configuration . That means , ...

  2. Asp.Net Core Subapplication will be caused by repeatedly adding modules in the configuration IIS error 500.19

    ASP.NET Core Has gone from IIS Medium decoupling , Can be run as a self hosting program , No longer dependent on IIS. But we still need strong IIS As a front-end server ,IIS utilize httpPlatformHandler Module to some of the background web ...

  3. net MVC Redirect summary

    [HttpPost] public ActionResult StudentList(string StudName, string studName, DateTime BirthDay, Form ...

  4. css3 Clocks and watches

    <!doctype html> <html> <head> <meta charset="utf-8"> <title> ...

  5. 【 turn 】ubuntu code UTF-8 GBK GB18030

    Add coding support sudo locale-gen zh_CN.GBK sudo locale-gen zh_CN.GB2312 sudo locale-gen zh_CN.GB18030 2. Update lo ...

  6. [zz] install Ubuntu 15.10 What we need to do in the future

    It is useful to , Collection http://blog.csdn.net/skykingf/article/details/45267517

  7. ADO.NET The new features SqlBulkCopy( Batch insert a lot of data )

    from :http://blog.csdn.net/huaer1011/article/details/2312361 stay .Net1.1 Whether it is for batch insertion of the entire DataTable All the data in the database , also ...

  8. After the program is sent to the background , towards iOS Excuse me , Finish the long-term task - To prepare

    12.2.2. programme Use UIApplication Of beginBackgroundTaskWithExpirationHandler:  Example method . After you finish your mission , call UIApplication Of en ...

  9. Objective-C Programming debugging skills

    by Objective-C Programming debugging skills ( translate ) http://www.cocoawithlove.com/2008/10/debugging-tips-for-objective-c.html This article is ...

  10. Upload file block client Realization

    First, all files are blocked by content ( Block size constraints ), And then for each chunk Construct a separate one UDP Datagram transmission , At the beginning of the application layer is the self-defined package header , There's a block number , Block length , Block fingerprints and other metadata information , This information is convenient for the receiver to be correct in order ...