DbNetCopy provides a quick and easy way to copy information between different types of databases. DbNetCopy includes a GUI application that is ideal for one off transfer of data and also an API .Net assembly that allows custom solutions to be created.

Supports the following databases: SQL Server, SQL Server Compact, Oracle, Excel, Access, MySql, DB2, Visual FoxPro, dBASE, Paradox, Pervasive, Firebird, SQLite, VistaDB and Postgresql. Simple to use. Just create a connection string for your 2 data sources and copy data in either direction. .Net control with documented API allows you to embed DbNetCopy capabilities into your own application. Support for native .Net data providers Selectively copy individual columns Add missing rows in target table Update existing rows in target table Convert encodings as part of the transfer process Full summary report of all changes

Sample API code.

        ...  
        // Source MS Access connection string
        string SourceStr = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\uploadedfiles\transactions.mdb;"
        // Target MS Sql Server connection string
        string TargetStr = @"Server=DbServer;database=Sales;Trusted_Connection=true;"

        // Create source connection
        DbNetData SourceConn = new DbNetData(SourceStr);  
        // Create target connection
        DbNetData TargetConn = new DbNetData(TargetStr);  
  
        using (DbNetCopy DNC = new DbNetCopy(SourceConn, TargetConn))  
        {  
            // Copy schema and data
            DNC.CopyOption = CopyOptions.SchemaAndData;  
            // Use default schema in target database
            DNC.SchemaOption = SchemaOptions.Drop;  
            // Drop the table first in the target database
            DNC.DropTargetTable = true;  
            // Copy the entire database
            DNC.CopyDatabase();  
        }  
        ...