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 databas开发者_运维知识库e(.sdf) in the same application in ASP.NET.

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

---

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