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