Завершен

SQL Database Partitioning

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.

Навыки: SQL, SQL-сервер Microsoft, Управление базами данных, MySQL, Программирование баз данных

О клиенте:
( 4 отзыв(-а, -ов) ) Denver, United States

ID проекта: #34025146

Поручен:

(20 отзывов(-а))
5.4

12 фрилансеров(-а) готовы выполнить эту работу в среднем за $135

WebInfoSolutions

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?

$60 USD за 1 день
(126 отзывов(-а))
7.1
ayesha0124

Hello, How r u doing? I have gone through the project and i believe that i can handle it well having experience related to Database Programming, MySQL, SQL, Microsoft SQL Server and Database Administration. Please have Больше

$250 USD за 7 дней(-я)
(5 отзывов(-а))
4.9
umairkaramat24

Hi! How are you doing? I have read the project description and really interested in this job, I have 4 years’ experience doing similar jobs regarding to these skills MySQL, Microsoft SQL Server, SQL, Database Programmi Больше

$250 USD за 9 дней(-я)
(5 отзывов(-а))
3.9
phoneapps

Hi I can move the data according to you requirement I have more than 5 years of experience in SQL, Oracle and MySQL Thanks

$100 USD за 7 дней(-я)
(20 отзывов(-а))
4.0
vladyslavbutsei8

Hi, I am a web developer experienced in SQL Database for 5+ years. After reading over your post, I think this project is perfect fit for my skill sets. I assure that I can implement this project as intended with high Больше

$100 USD за 7 дней(-я)
(4 отзывов(-а))
2.7
serhiiraksha

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.

$160 USD за 1 день
(3 отзывов(-а))
2.3
Wonab

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 Больше

$140 USD за 1 день
(0 отзывов(-а))
0.0
rosoriano84

Hello, Maximusdfw! ⭐SQL Database Expert!⭐ I'm a Web Developer and have more than 7+years of experience. I'll provide you quality work according to your instructions. Please award me the project so that we can discuss Больше

$150 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
kveber

Hello. I have read your description very carefully and I can complete it perfectly in short time. I am confident in my skills and always value for client's trust. So I have rich experience in these fields. I can use th Больше

$100 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
mehmetdemir58fr

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!

$140 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
datasclancer

I not only offer support, but a whole range of services to help you create, manage and build powerful web and mobile apps platforms' presence. Avail Splendid and Futuristic Solutions that help to expand your business Больше

$140 USD за 7 дней(-я)
(0 отзывов(-а))
0.0