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
精彩评论