CODEWITHSUNDEEP
c#asp.netsql-server-ce
Victor Athoti.
Victor Athoti.

Reputation: 831

how can I copy the tables schema from database to another database using SqlserverCe in asp.net?

I want to copy the sqlserverCe database(.sdf) tables into another sqlserverCe database(.sdf) in the same application in ASP.NET.

Is it possible? If possible, please help me how can I do this?

Upvotes: 1

Views: 1609

Answers (1)

ErikEJ
ErikEJ

Reputation: 41749

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

Upvotes: 1

Related Questions