Click here to Skip to main content
14,207,783 members
Rate this:
Please Sign up or sign in to vote.
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....
Updated 13-May-18 10:35am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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.

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

Advertise | Privacy | Cookies | Terms of Service
Web05 | 2.8.190612.1 | Last Updated 13 May 2018
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100