I need advise with regards to archiving old data from our prod database
since db size has increased
All tables in the database do not have a date column but they do relate to the tables
which have date columns
Users might require to access this old database for reporting or data analysis
once in a while, so it needs to exist on a remote server for them to access
Currently this prod database is getting replicated to a reporting server.
So now once the data is archived we still would require to replicate both the archived and
the current prod data to the reporting server on a single db
Please suggest how this can be achieved??