Red Gate Series 4 SQL data compare 10.2.0.885 edition data comparison and synchronization Tool complete cracking + tutorial

Red Gate Series 4 SQL data compare 10.2.0.885 edition data comparison and synchronization Tool complete cracking + tutorial

Red Gate SeriesArticle:

SQL compare 10.2.0.1337 edition, one of the red gate series, database comparison tool, complete cracking + tutorial

Red Gate Series ii SQL source control 3.0.13.4214 edition database version controller full cracking + tutorial

Red Gate Series iii SQL Server development tool SQL prompt 5.3.4.1 edition T-SQL smart sensing analyzer complete cracking + use tutorial

Red Gate Series 4 SQL data compare 10.2.0.885 edition data comparison and synchronization Tool complete cracking + tutorial

Red Gate Series 5. Net reflector 7.6.1.824 edition. Net Program decompilation artifact (with plug-in installation tutorial) Complete cracking + use tutorial

Red Gate Series 6 SQL test 1.0.12.3 edition SQL test tool full cracking + tutorial

Tutorial on using the SQL search 1.1.6.1 edition SQL query and analysis tool in red gate Series

8. Red Gate series SQL connect 1.1.1.19 edition database connection and operation tool cracking + usage tutorial

Availability tests and research show that maintaining Database Consistency and data controllability is a headache. Why not trySQL data compare (SQL data comparison tool)To relieve headaches?

This tool was developed by red gate. We are familiar with. Net reflector, which is launched by this company. Its sqltoolbet is also very famous, and SQL data compare is one of the sqltoolbet tools. The data compare tool produced by red gate is stable and easy to use. It also has a very useful feature, which can compare the data in the backup set. That is, after we back up the customer data, we can copy it back and compare it directly here, instead of restoring it to SQL Server. In addition, as shown in, it has a Synchronization Wizard, which can generate a synchronization script based on the differences between the two databases being compared, and put the script in another database to run it, the two databases are exactly the same. This feature is often used to analyze the business operations of Kingdee and Microsoft dynamic ax. For example, I want to know the tools used to post the purchase order of Kingdee ERP. In addition to opening SQL Server Profiler to track its SQL, I want to open this tool again, compare the data difference between the pre-posting and post-posting databases of a purchase order to know what data operations it has performed, according to the meaning of its table name (the meaning and purpose of the table are public), we can infer itsProgram. Follow this tool to update the ERP business system.

You can download the SQL data comparison tool from Red Gate:

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 has the ability to create, compare, synchronize, and generate scripts.

I do not recommend that you directly generate scripts for the entire database, but if your applications, including static data (query tables, reference data, configuration data, etc ), you need to use version control to control your database. It makes sense to store your schema and static data together as a single structure. Once your database is inSource codeControl, it is easy to migrate changes and compare versions, backup files.

In this article, I will tell you how easy it is to save your database script until the sourceCodeControl.

1. Tutorial

First, create a new project in SQL compare.

More careful people may notice that red gate has brought a lot of interface changes and enhancements.
I want to create a set of differential scripts from my database, so I have set detailed information for the source (left) server and target server. Click Compare now to compare the data.

Now we have seen the data difference. We can also see which data is the same. I drew two links to indicate the difference in the number of data records.
We only care about which part of the data is different. On the tables and Views tab, select the corresponding table. I selected the greentech_industry_category table. Then, at the bottom of the interface, there will be data differences between the two tables, how many differences are there, and detailed data.
You may not get used to this view, and I am not used to it either.
Let's select another vertical display method.

Check the lateral view in the show drop-down box,
The view changes immediately. The Blue column on the left is the column, and the yellow column on the right is the comparison between the left (source server) data and the right (target server) data.

After selecting the table, you can click deployment Wizard to deploy the table.

You can select either of the following methods after enabling
1. Create a script in the specified database manager, but it will not help you synchronize data. You need to manually execute the script.
Here, you can select a Database Manager version. I chose SQL Server 2008. If you have installed another version on your machine, you can also choose 2005 or another version.

Click Next.

Click Open script in editor.
This will help you create scripts and open the database manager you specified.

Then you can manually execute the task or modify other parts, and then execute the task.
2. Help you execute the script to synchronize data and output the script to your physical file *. SQL

You can select three items on the right.
1. Back up the target data before deployment
2. Re-compare after deployment
3. Save a copy deployment script file.
You can change the file output path and file name. Click Next.

During this period, several interfaces are flashed until the deployment is complete. Click OK to complete the deployment.

If you do not cancel the save file option, you can open your folder to view the script.

You can also refer to the following articles ):

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

Ii. Cracking tutorial

SeeHttp://www.cnblogs.com/VAllen/archive/2012/09/26/SQLCompare.html

The cracking method is the same as the interface and steps.

I extracted the red gate SQL data compare MSI installation package, only support thunder 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 = small
Red Gate SQL data compare 10.2.0.885 edition official download: http://www.red-gate.com/products/sql-development/sql-data-compare/
Red Gate SQL data compare 10.2.0.885 edition keygen registration machine (in 7z format) download: Http://download.csdn.net/detail/caizz520/4600858 (Some people do not have their computers installed or are not the latest version of the decompression software, so they cannot decompress the compressed file in the 7z format. I have compressed it into the RAR format and uploaded it, all download without points and logon. Please feel free to download it !) Red Gate SQL data compare 10.2.0.885 edition keygen registration Machine(RAR format) download: Http://download.csdn.net/download/caizz520/4609788

The red gate series are not complete and will be resumed.

Do not delete the following lines. Thank you !!!

Source from vallen cnblogs link: http://www.cnblogs.com/VAllen/archive/2012/09/27/SQLDataCompare.html