Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have a vendor application that creates a new database monthly for only few tables. Vendor doesn't have solution. Is there any other way besides partitioning as partitioning require enterprise version? Any recommendation?

share|improve this question

closed as unclear what you're asking by Max Vernon, dezso, bluefeet, RolandoMySQLDBA, Kin Sep 27 '13 at 17:14

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

Why are separate tables or databases needed? How much data is generated in a month? – Aaron Bertrand Feb 8 '12 at 23:35
I have supported instance that had this. It was some financial forecasting software. Usually after the quarter financials were processed those dbs were dropped. – Shawn Melton Feb 9 '12 at 0:39
I do not fully understand your question : do you mean a new database is created each month ? What is the data load ? Why would you need partitioning ? – nopol Feb 9 '12 at 8:58