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

Question

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?

Hi thank you for giving response i want copy the schema only. — Victor Athoti.
– Victor Athoti., Commented Jun 8, 2011 at 10:43

ErikEJ · Accepted Answer · 2011-06-08 10:58:10Z

1

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

answered Jun 8, 2011 at 10:58

ErikEJ

42.1k5 gold badges81 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Victor Athoti. Over a year ago

Hi,actually i have create a one template database(template.sdf "it has table of schema only no data") it has the tables,when a user login then create one new database and add the tables from template.sdf to user.sdf database.

Renatas M. Over a year ago

Then cant you just copy template.sdf and rename it to user.sdf?

Victor Athoti. Over a year ago

because it is default database for every user not only for one user.

Renatas M. Over a year ago

so create COPY for every user. For example for user1 copy template.sdf to user1.sdf...for user2 copy template.sdf to user2.sdf. Code: File.Copy("template.sdf", "user1.sdf") you will have template.sdf and user1.sdf after this.

Victor Athoti. Over a year ago

after copying file how can i store that user.sdf file in serverpath App_data

Collectives™ on Stack Overflow

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

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related