Copy Schema for MS SQL Server tool 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	Database Schema Size, objects	Performance, objects/sec
Windows XP SP3	2000	local	150	92.31
Windows XP SP3	2000	local	13045	298.49
Windows XP SP3	2000	local	7801	291.86
Windows XP SP3	2005	1000	150	81.34
Windows XP SP3	2005	1000	13045	248.33
Windows XP SP3	2005	1000	7801	253.47

The copy schema performance depends on:

Database complexity (number of relationships, comments, indexes, etc).
Database server(s) loading.
LAN/WAN speed and loading.

• MS SQL Server

• DB2

• DBF