Examination system Maintenance--different versions of SQL data import and Export

Test system maintenance process, in order to ensure that the test smoothly need to set up a test system on multiple servers (backup), this time need to move the database back and forth, before our usual method of database backup restore is really simple and convenient, but encountered different server installed SQL version of the rest of the dish, Although at that time for easy operation later, we have to use the database version of the server is unified, but in the examination system maintenance teacher let me feel the deepest point-----"All things think a little more!" "Multi-thinking must be applied to the actual, so I came back and carefully studied several different versions of SQL data import and export methods, with everyone to improve communication."

One: Using SQL Server Import and Export Tool

Right-click on the source database à task à export data

Select the source and target databases separately

Then follow the default steps to complete

II: Using the Build script

Right-click on the source database à task à generate script

Select the corresponding database version and data options (to True), and there are other options to see if you actually want to choose

Then follow the default steps to generate a script file to execute on the target database

Three: Import and export using bcp

BCP is SQL dedicated to database table-level data backup tools, the powerful parameters of the function of the more slowly to learn, the following is a simple bcp data import and export

bcp command execution in the console and SQL Server can be, and can customize the format of the data export, and the data import and export speed is much higher than the above method (big data is more obvious), about BCP is more one-sided, I hope you have a lot of advice

Encounter problems when we are missing is to think of a step, and then to think a little bit, many times we all feel that they do not have any difference, since they think they are also thinking diligent thinking of the people, but, again and again lazy thinking, we have self-restraint, you always feel good, and sometimes it is too naïve.

Say less nonsense, more want to do more!

Different versions of SQL data import and export methods There are many more, please continue to follow my blog there will be more ways to summarize to communicate with you.

Examination system Maintenance--different versions of SQL data import and Export