Tamamlanmış

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.

Beceriler: SQL, Microsoft SQL Server, Veri Tabanı Yönetimi, MySQL, Veritabanı Programlama

Müşteri Hakkında:
( 4 değerlendirme ) Denver, United States

Proje NO: #34025146

Seçilen:

(20 Değerlendirme)
5.4

Bu iş için 12 freelancer ortalamada $135 teklif veriyor

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?

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(126 Değerlendirme)
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 Daha Fazla

$250 USD in 7 gün içinde
(5 Değerlendirme)
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 Daha Fazla

$250 USD in 9 gün içinde
(5 Değerlendirme)
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 in 7 gün içinde
(20 Değerlendirme)
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 Daha Fazla

$100 USD in 7 gün içinde
(4 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 Daha Fazla

$150 USD in 2 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$100 USD in 2 gün içinde
(0 Değerlendirme)
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 in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$140 USD in 7 gün içinde
(0 Değerlendirme)
0.0