Export Table to Text tool for MS SQL Server Performance

OmBelt Database Tools
The only functions you need today

• Copy Database

• Copy Schema

• Clone Table

• Export Table

• Export Query

• Export Database

• Export Schema

• Publish Table

• Publish Query

• Import Data

Product profile

Order online

There are results of the test execution:

Operating System	SQL Server version	LAN, Mbit	Table Information	Performance, rows/sec
Windows XP SP3	2000	local	4 int columns 100K rows 2.4 Mb	14714.54
Windows XP SP3	2000	local	3 varchar columns 105K rows 9.1 Mb	16632.51
Windows XP SP3	2000	local	50 varchar columns 5000 rows 15.7 Mb	824.67

The export performance depends on:

Table complexity (number of columns and data types).
Database server loading.
LAN/WAN speed and loading.

• MS SQL Server

• DB2

• DBF