How to copy a table from another database?

Question

User2097951763 posted

table 1in a.sdf

how can I copy table1 to b.sdf

Answer 1

User-386954757 posted

Hello,

You could use my scripting library, which can script entire schema to a file, and run the script using the ExecuteSql method against the other sdf file. http://exportsqlce.codeplex.com

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/4b2ec5ac-6e28-49b3-ac38-5b622cd50bb3/copy-table-from-sdf-to-sdf-database

Answer 2

User-821857111 posted

var a = Database.Open("a");
var data  = a.Query("SELECT * FROM Table1");
var b = DatabaseOpen("b");
//if the table already exists
foreach(var row in data){
    b.Execute("INSERT INTO Table1 (col1,col2,col3,...) VALUES (@0, @1, @2...)", row.col1, row.col2,row.col3,...); 
} 

If the table doesn't exist, you need to create it. You can use CREATE TABLE for that:

var ddl = "CREATE TABLE Table1 (Col1 IDENTITY NOT NULL PRIMARY KEY, Col2 NVARCHAR(50), Col3 DATETIME etc)";
b.Execute(ddl);