I have inherited a database application. The app has 70 procedures, which run quarterly. The client would like the 4 quarters run so that the output is sent to a separate database for each quarter. The procs are updated every quarter with client requests.
Currenlty I have 4 databases where the code is identical and the data differs.
Is there a way where I can have only 1 set of the procs and some how output the data to 4 different databases ?
re-writing the app is not an option and there are NO dates in any of the tables.
Currenlty I have 4 databases where the code is identical and the data differs.
Is there a way where I can have only 1 set of the procs and some how output the data to 4 different databases ?
re-writing the app is not an option and there are NO dates in any of the tables.