[ravva]

File.Copy("file-a.txt", "file-b.txt", true);
File.Copy(@"" + Application.StartupPath + "\\ms.mdb" , @"" + Application.StartupPath + "\\data\\temporary.mdb",true);
im using this for copy one database content to tempory database, but i have another database name "td2012.mdb" that want to copy to tempory.mdb (after copying ms.mdb tables and td2012 tables need to contain in temp.mdb)
please help to to it,thank you......

[Skydiver]

What's wrong with:

open destination database
open source database
foreach table in source database to be copied
{
    clone schema of table into destination
    clone indexes of table into destination
    clone permissions of table into destination

    foreach row in table
    {
        copy row into destination table
    }
}

This post has been edited by Skydiver: 31 December 2012 - 07:09 AM
Reason for edit:: Added need to clone indexes and permissions