Click here to Skip to main content
15,892,927 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello coders!

I am developing a C# desktop application which uses sqlce server. I need to auto-create new databases automatically whenever the current one gets full.

This application will be used extensively and so will get full sooner.

I am planning to pack a blank database with complete tables structure and then, whenever a db gets full, I want to just make a copy of this blank db and rename it with db1...db2...db3... names. The serial no.(id) will be incremented and continued from the previous db. And then retrieve data from all these dbs simultaneously whenever the application is used.

What I have tried:

I have googled too much for this but all in vain.

Please guide and help me....
Posted
Updated 13-May-18 10:35am

1 solution

Quote:
How to auto create a SQLCE database when one gets FULL

Short answer: You don't.
If you plan to have a database larger than the 4Gb limit, choosing another SQL server without the limit would be a wise choice.
Even if possible, the queries would be extremely complicated and inefficient.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900