Red Gate Series articles ：
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 ：
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
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
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 .
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
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. .
At this time, it will help you create scripts and open the database manager you specified
2、 Help you execute scripts, synchronize data and output scripts to your physical files *.sql
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
Two 、 Crack tutorial
The cracking method, interface and steps are the same
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
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
- 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 ...
- Red Gate Series eight SQL Connect 188.8.131.52 Edition Database connection and operation tools Complete crack + Use the tutorial
original text :Red Gate Series eight SQL Connect 184.108.40.206 Edition Database connection and operation tools Complete crack + Use the tutorial Red Gate Series eight SQL Connect 220.127.116.11 ...
- Red Gate Series seven SQL Search 18.104.22.168 Edition SQL Query analysis tool tutorial
original text :Red Gate Series seven SQL Search 22.214.171.124 Edition SQL Query analysis tool tutorial Red Gate Series seven SQL Search 126.96.36.199 Edition SQL ...
- Red Gate Series six SQL Test 188.8.131.52 Edition SQL Testing tools Complete crack + Use the tutorial
original text :Red Gate Series six SQL Test 184.108.40.206 Edition SQL Testing tools Complete crack + Use the tutorial Red Gate Series six SQL Test 220.127.116.11 Edition S ...
- Red Gate Series three SQL Server Development tool SQL Prompt 18.104.22.168 Edition T-SQL IntelliSense Analyzer Complete crack + Use the tutorial
original text :Red Gate Series three SQL Server Development tool SQL Prompt 22.214.171.124 Edition T-SQL IntelliSense Analyzer Complete crack + Use the tutorial Red Gate Series three SQL S ...
- Red Gate The second series SQL Source Control 126.96.36.19914 Edition Database version controller Complete crack + Use the tutorial
original text :Red Gate The second series SQL Source Control 188.8.131.5214 Edition Database version controller Complete crack + Use the tutorial Red Gate The second series SQL Source Co ...
- 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 ...
- Red Gate Series five .NET Reflector 184.108.40.2064 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 220.127.116.114 Edition .NET Program decompiler artifact ( Add plug-in installation tutorial 2012-10-13 to update ) Complete crack + Use the tutorial Red Gate ...
- 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 , ...
- 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 , ...
- 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 ...
- net MVC Redirect summary
[HttpPost] public ActionResult StudentList(string StudName, string studName, DateTime BirthDay, Form ...
- css3 Clocks and watches
<!doctype html> <html> <head> <meta charset="utf-8"> <title> ...
- 【 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 ...
- [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
- 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 ...
- 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 ...
- 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 ...
- 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 ...