How to maintain Big database During END of the Year????Example:My DataBase is Store and it has 40 tables..so after new year i want new transcation in new database.but Whats happen with my pandding data which is in old year ???this is My query

Pinakin
Profile Answers by Pinakin Questions by Pinakin
Mar 11th, 2006
1
1604

Showing Answers 1 - 1 of 1 Answers

Chiranjeevi Manne

Mar 30th, 2007

Infact your question is not straight forward,
but anyhow if you are routing the transactions to the newly created database on another server then you can export the pending data and import into new database. Or else use COPY command table by table approach using the DATABASE LINKS. But the later approach very slow as it is based on network.