DotNetFirebird: Using Firebird SQL in .NET: FBCopy: Command-line Tool for Copying Data between Tables and Databases

Features:

Automatically loads all tables in both databases and compares their fields
Uses Foreign Keys to determine the correct order of tables
It can create ALTER TABLE and CREATE TABLE scripts needed to update the destination database if desired
It generates a simple textual definition file with list of tables, which you can edit to select only the tables you really need
You can manually edit definition file if you wish to copy from views or stored procedures
For each table, you can add WHERE clause
You can do it all as single atomic transaction or one transaction per table
Works on Windows and Linux

Posted by Dan : 4:33 PM

Comments:

Blog comments are closed.