Atitit.sql server2008 Export Import Database large table file ... Oracle MySQL

Atitit.sql server2008 Export Import Database Large table file ...

1. Files exceeding 80M are not executed in Query Analyzer 1

2. Oracle, MySQL large file import 1

2.1. Using SQL file 1

2.2. Using dmp binaries (Oracle only) 1

2.3. Other export txt,excel in import ( not recommended ), often cannot import 1

3. Native Import 1

4. Remote Import 2

5. Syaolon MSG 2

6. Reference 3

1. Files over 80M cannot be executed in Query Analyzer

IMEX txt bad use , often can not im ...

Best practice or use SQL to communicate ...

Import problems with more than 80M *.sql files are frequently used recently.

Search the Internet, found that more than 80M of files can not be executed in the Query Analyzer.

2. Oracle, MySQLLarge File Import2.1. UseSQLfile2.2. UseDMPBinary Files(Oracle only)2.3. OtherExportTxt,excelin the import( Not recommended),often cannot import

Author :: old Wow's paw attilax Ayron, email:[email protected]

Reprint please indicate source: Http://blog.csdn.net/attilax

3. Native Import

C:\>sqlcmd-i test.sql-d databasename-s 127.0.0.1

4. Remote Import

sqlcmd - D gialenweixin  -S 192.168.1.33 -U focustar -P Focustar -i c:\expUser.sql

(1 rows affected)

Processed 12700 Total Records

(1 rows affected)

Processed 12800 Total Records

(1 rows affected)

Processed 12900 Total Records

(1 rows affected)

Processed 13000 Total records

(1 rows affected)

Processed 13100 Total Records

Every 100 lines of processing a hang ....

Verify ... Select COUNT (*)  from T_mb_weixinuser

5. Syaolon msg

Ql-d Weixin-id:\sql\beko69.sql
Twins 05:49:36
SELECT @ @SERVERNAME
Sqlcmd-e-sl7jmp9oiu7jrv4e\s
Twins 05:49:36
Ql-d Weixin-id:\sql\beko69.sql
Twins 05:49:36
SELECT @ @SERVERNAME
Sqlcmd-e-sl7jmp9oiu7jrv4e\s
2014-07-01

6. Reference

Introduction to SQLCMD _ red Maple Leaf _ Sina blog . htm

SQL Server uses sqlcmd to execute . HelloJimmy520 columns - Blog channel -CSDN.NET.htm

About isql,osql,sqlcmd The difference _forevervw_ Sina blog . htm

Atitit.sql server2008 Export Import Database large table file ... Oracle MySQL