public void Copy(string provider1, string server1, string catalog1, string login1, string cred1, string provider2, string server2, string catalog2, string login2, string cred2, string table_cue_after, string single_table, bool no_utc)
        {
            string bintablename = new doc02Binary().TableName.ToLower();
            /* 0. define exclusions */
            var exclusions = new List <string>()
            {
                new sys02Installation().TableName,
                new doc02FT().TableName, /* [dlatikay 20110920] now the table name will resolve properly, was before: "doc02FT"; -!- until better solution, currently not included in schema! */
                new doc02Binary().TableName,
                new doc02BinaryL().TableName,
                new log02OrgSync().TableName,
                new log02OrgSyncItem().TableName,
                new msg02EventA().TableName,
                new nav02PickupStorage().TableName, /* it fails with a strange error in the RAW field (SessionID). we just omit it as it is transient and therefore not needed in systemcopy anyway */
                new nav02Menu().TableName,          /* [dlatikay 20101012] added */
                new nav02MenuL().TableName,         /* [dlatikay 20101012] added */
                new nav02MenuLocation().TableName,  /* [dlatikay 20151002] added */
                new nav02MenuLocationL().TableName, /* [dlatikay 20151002] added */
                new per02TaskA().TableName,
                new rpt02Link().TableName,
                new rpt02LinkL().TableName,
                new rpt02Destination().TableName, /* [dlatikay 20101012] added */
                new sys02Computer().TableName,
                new sys02GroupAccount().TableName,
                new sys02JobA().TableName,
                new sys02Useraccount().TableName,
                new tpi02CredentialStore().TableName,
                new tpi02FunclocImp().TableName,
                new tpi02HRImpAcceptor().TableName
            };

            /* except the single table from the exception */
            if (!String.IsNullOrWhiteSpace(single_table))
            {
                string exex = exclusions.Find((x) => { return(x.ToLower().Equals(single_table.ToLower())); }); /* [dlatikay 20090824] for genuine case insensitivity */
                if (!String.IsNullOrWhiteSpace(exex))
                {
                    exclusions.Remove(exex);
                }
            }
            /* 1. open both connections */
            ddl db1 = new ddlfactory((DbProvider)Enum.Parse(typeof(DbProvider), provider1)).Generate;
            ddl db2 = new ddlfactory((DbProvider)Enum.Parse(typeof(DbProvider), provider2)).Generate;

            try
            {
                db1.Connect(server1, catalog1, login1, cred1, null, no_utc);
                db2.Connect(server2, catalog2, login2, cred2, null, no_utc);
                /* 2. enumerate the tables in source and target */
                List <string> tables1 = db1.ListAllTables();
                List <string> tables2 = db2.ListAllTables();

                /* 3. for each table in the source, attempt to truncate
                 * the table in the destination and re-fill it using bulk insert
                 * approach */
                /* 3a. for each table */
                bool     keep_skipping           = (table_cue_after != null && table_cue_after.Length > 0) || (single_table != null && single_table.Length > 0);
                bool     stop_after_single_table = false;
                Assembly assy = Assembly.GetExecutingAssembly();
                foreach (string table in tables1)
                {
                    string tablename = table.ToLower();
                    if (single_table == null || single_table.Length <= 0)
                    {
                        log(864, tablename); /* Transferring table \"{0}\"... */
                    }
                    if (keep_skipping)
                    {
                        if (table_cue_after != null && table_cue_after.Length > 0)
                        {
                            log(1173, table_cue_after); /* --> skipped, precedes continuation point "{0}" */
                            keep_skipping = tablename != table_cue_after.ToLower();
                        }
                        else if (single_table != null && single_table.Length > 0)
                        {
                            keep_skipping = (!single_table.ToLower().Equals(tablename));
                            if (!keep_skipping)
                            {
                                log(864, tablename); /* Transferring table \"{0}\"... */
                                stop_after_single_table = true;
                            }
                        }
                    }
                    /* take this one? */
                    if (!keep_skipping)
                    {
                        /* must not be in the exclusion list. if the single table is in the exclusion list, we excluded it from the exclusion list already :) */
                        if (!exclusions.Exists(delegate(string x) { return(x.ToLower().Equals(tablename)); }))
                        {
                            /* must exist in source and target (otherwise installations do not match in schema version probably) */
                            if (tables2.Exists(delegate(string x) { return(x.ToLower().Equals(tablename)); }))
                            {
                                //if (tablename.StartsWith(bintablename))
                                //    /* the "doc02Binary" table gets special treatment because it contains huge binary chunks. so does the doc02BinaryL. */
                                //    CopyBinRowwise(db1, db2, tablename);
                                //else
                                //{
                                /* got the singular, need the plural */
                                TableDef   element = (TableDef)assy.CreateInstance("dal.schema." + tablename, true);
                                string     plural  = db1.ObtainPlural(assy, tablename);
                                ITableList list    = (ITableList)assy.CreateInstance("dal.schema." + plural, true);
                                /* generic-dynamically invoke the dbselectall statement on the source */
                                GenericInvoker invoker = clsDynamicGenerics.GenericMethodInvokerMethod(
                                    element.GetType(),
                                    "DbSelectAll",
                                    new Type[] { list.GetType(), element.GetType() },
                                    new Type[] { typeof(ddl) }
                                    );
                                list = invoker(element, db1) as ITableList;
                                /* truncate the target */
                                element.DbTruncate(db2);
                                if (list.Rowcount > 0)
                                {
                                    log(1157, list.Rowcount.ToString()); /* --> number of records to be transferred: {0} */
                                    /* now for the dbinsertall statement on the target - who's able to fully understand this, must be drugged */
                                    try
                                    {
                                        element.InsertAllGeneric(db2, list);
                                    }
                                    catch (Exception ex)
                                    {
                                        throw new DALException(String.Format("Failed to copy table \"{0}\".", element.TableName), ex);
                                    }
                                    log(870, list.Rowcount.ToString()); /* --> number of records transferred: {0} */
                                }
                                else
                                {
                                    log(869); /* --> deletion only, no data in source table */
                                }
                            }
                            else
                            {
                                /* table does not exist in destination */
                                log(866); /* --> skipped because not existing in target database. */
                            }
                        }
                        else
                        {
                            /* table skipped because of exclusion rule */
                            log(865); /* --> skipped because in exclusion list. */
                        }
                    }
                    /* if we wanted only a single table we might now abort */
                    if (stop_after_single_table)
                    {
                        break;
                    }
                }
                /* succeeded */
            }
            finally
            {
                /* cleanup */
                if (db2 != null)
                {
                    db2.Disconnect();
                }
                if (db1 != null)
                {
                    db1.Disconnect();
                }
            }
        }