SQL Database Partitioning
Budget: $30 – $250 USD
Need work with SQL database partitioning for two tables.
Main table has needs to have data partitioned off for 7 years where active partition needs to have data in it for 6 months. All the older data (6 months and older) needs to be partitioned off.
Need a stored procedure to run first of every month
create a new partition (for the year)
move data older than 6 months to archive partition.
Delete data older than 6 months
This needs to happen for two tables that are linked together by fk's
This is urgent and I need it done right away.
Main table has needs to have data partitioned off for 7 years where active partition needs to have data in it for 6 months. All the older data (6 months and older) needs to be partitioned off.
Need a stored procedure to run first of every month
create a new partition (for the year)
move data older than 6 months to archive partition.
Delete data older than 6 months
This needs to happen for two tables that are linked together by fk's
This is urgent and I need it done right away.