I have a daily partitioned table 'TBL' and I hold data for 30 Day's. I archive data to TBLHistory table by Switch out minimum partion and switch in the partition to TBLHistory.
The Main Table 'TBL' and 'TBLHistory' resides on the same database. As a result size of database is increasing.
My manager ask me to Create a HistoryDB database and move 'TBLHistory' to the history database.
Can i move 'TBLHistory' to HistoryDB and still i can perform switch out and Switch in?
Note:Both DBs are residing on same instance of the server.
(MainDB) -->TBL-->SwithOut to --> Swith In to --> (HistoryDB)-->TBLHistory ?
Please guide me how can i best achive this.