Download the mssqldump Tool
Http://www.parallels.com.cn/downloads/Prima/Tools/MsSqlDump.zip
Download the tool to the local C-drive root directory, click Start> Run, Enter cmd, and press enter to enter the command prompt line.
EnterProgramPath cd c :\.
Run the following command:
Mssqldump.exe-s localhost-U sa-P changeme-d abc-O dB. SQL-createtable-insertdata
-S localhost indicates to connect to the Local Machine
-U sa indicates connecting with the SA user
-P changeme indicates that the SA user's password is changeme.
-D abc indicates operations on the database named ABC
-O dB. SQL indicates output to DB. SQL
-Createtable indicates that the SQL script contains database structures such as creating tables.
-Insertdata indicates that data is inserted in SQL.
You can obtain the DB. SQL file after running. The db. SQL file also contains the database table structure and data in the table.
Http://www.parallels.com.cn/support.php? X = & mod_id = 2 & root = 64 & id = 162
Test and export the three remote databases. Only one exported script can be used. Other databases may encounter errors. Disappointed ......