Copy Schema for SQL Server

Designed for Microsoft SQL Server and featuring Unicode support, Copy Schema for SQL Server is a simple application capable of replicating all objects from a database to move them to another database or server.

This includes tables, views, procedures, indexes, triggers, primary and foreign keys, along with schemas and database names. It caters to database developers and administrators.

Needless to say, you must have an ODBC driver for Microsoft SQL Server installed before working with this tool. The interface consists of a wizard with clearly defined options, where you can begin by specifying the source database, whether it's a direct connection to the server or database (e.g. MS SQL Express Server) or a predefined data source (e.g. trusted connection).

In the following step, you can enter additional connection properties pertaining to the database name, schema or owner, schemas to exclude, and transaction size, which represents the number of rows to process on each transaction (0 means auto-commit).

Next, Copy Schema for SQL Server lists all identified tables in the source and gives you the possibility to select the one you want to clone, after examining the names, schemas/owners and comments of all tables. Table contents can be previewed.

It's possible to enter query text or import it from file, indicate the target table, copy data rows with identity values, table indexes and primary keys, as well as handpick the columns to clone.

The project can be saved to file and later resumed. As far as program settings are concerned, you can ask the tool to load the most recent project at startup and show views in the table lists, modify the default date and time format, enable full log mode, exclude schema names from SQL statements, as well as drop empty result files, among others.

It worked smoothly in our tests, without causing the OS to hang, crash or prompt error messages. It had minimal impact on computer performance, using low CPU and RAM.

To sum it up, Copy Schema for SQL Server features approachable options to help you duplicate database contents.