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.
Bu iş için 12 freelancer ortalamada $135 teklif veriyor
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! I can start working right away and will provide you with good results. I have good experience in database programming. What about sharing the tables with me here? I am looking forward to hearing from you soon. T Daha Fazla
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!