Hi All,
We have 1 database of 100 GB and its increasing very fast. We have transaction data and reporting data.
We would like to split the data into 2 parts where in one part will have all transactional database and the other will be reporting database.
Another thing that needs to be done is to keep looking at transaction data and move data to reporting database, if it become eligible for reporting.
Please advice on the various ways to achieve this part & which would be the best. Thanks for all your kind help.
Thanks
Sudhir