should i Make new database after Financial year
-
Hi Friends.. I want to know should i Make new database after Financial year or just create new session in the current database . Please tell me with reasons.
-
Hi Friends.. I want to know should i Make new database after Financial year or just create new session in the current database . Please tell me with reasons.
How on earth can anyone answer this question without knowing anything about your business?
-
Hi Friends.. I want to know should i Make new database after Financial year or just create new session in the current database . Please tell me with reasons.
The idea to start a "new" database comes from an accountant, not a technician; a new year means a new book, a new page, a clean slate to them. In a database, that's just silly. Include a date on the record, and you can select/manipulate the data is if you were working in a database with only data from that particular year (thanks to the
WHEREclause) Advantages include;- Easy maintenance (one database, as opposed to 20 clients with 4 years worth of databases)
- Easy backups (since all is in one database)
- Easier cross-querying (summing the data over multiple years)
- Easier to understand (KISS applies to almost everything, everywhere)
The only disadvantage is that the accountant won't understand why you put the data in the "same books". That's the reason why they're not involved when creating a technical storage-facility, only when describing the data - they may explain what they need, but can hardly explain how it should be stored.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
-
Hi Friends.. I want to know should i Make new database after Financial year or just create new session in the current database . Please tell me with reasons.
No, but you could have tables where you summarize various periods for future comparisons and such.