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.
12 фрилансеров(-а) готовы выполнить эту работу в среднем за $135
Sure, It will be done right away, can you share existing table schema? Are you looking to create an archive table where older data is to be kept?
Hi @Maximusdfw I read your requirements carefully and I can say I can start right now. I have strong skills in DBMS. I hope to discuss more details. Thank you.
Hello, Client. I am experienced in partitioning SQL database. I know the stuff of SQL DB ins and outs. let's have chat right away to get it started I will finish in no time Best!