Închis

Solve sql database issue

Job Description:

Hi,

We need someone to solve this issue:

we can not complete the transfer as the wpr4_braapf_term_taxonomy_hierarchical table is too large to be imported on our shared servers. We already have consulted on the case with our system administrators and with our Supervisors for the problem and the only solution is for you or your developer to optimise the database and decrease the table significantly. The SQL query, which imports the table, has 44 350 586 characters:

and the import operation times out due to the significant length of the query. We can not increase the limitations on the shared server for the import to be completed as such actions might affect the other clients' websites on the server, which we can not allow. Also, any operation on the database afterwards might timeout as well and would prompt the limitations on the server to be increased permanently, which for the above reasons is not possible.

We need to solve this and also looking for a expert that we could work with long term. Someone that could work fast and simpel. You will have 2 days to solve this.

Aptitudini: SQL, MySQL, Administrare baze de date, Server Microsoft SQL, Programare baze de date

Despre client:
( 15 recenzii ) Copenhagen, Denmark

ID Proiect: #35842290

46 freelanceri licitează în medie 169$ pentru acest proiect

seefattechnologi

Hello Yes I will fix this issue . I am expert SQL/Full stack developer having great expereince with similar task. lets connect on chat to discuss more. Thanks

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(58 recenzii)
7.6
schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 4 zile
(73 recenzii)
6.9
shihan033010

Hi I have understand the requirement. I have the solution for this. I can split the table data into multiple small table and from there I can import the data into your new table. Please let me know. I am will wait for Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(242 recenzii)
6.7
hawkscodes

Hi, I can start right now. I will fix the sql issue as per your guidance, I will optimise the database and decrease the table significantly. Please share the credentials to start. I have +8 years of experience in L Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(61 recenzii)
6.3
abugosia

Hello, I'm Abu Gosia. I'm interesting in your project very well. I'm good in C#, .Net Core, MVC, ASP.NET, Angular.js, Yii2, PHP, Laravel, Codeigneter, Wordpress, Open Cart. I m quite well experienced in these jobs. Let Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(134 recenzii)
6.5
sumonst21

Hi there, I'll solve it in few hours from now, I'm highly experianced in solving wp & mysql related issues.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(27 recenzii)
5.5
jayantavkumar

Proposal - Give me a chance to solve your problem. You can expect any kind of work on SQL Server/SSIS/SSRS/PowerBI include Azure logic app with cosmos. Let me know if you want to discuss further. I am a database / Bu Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 4 zile
(32 recenzii)
5.0
kundansql

Hello sir/mam! I would like to check the SQL Script that times out. We can do a 15-minute free call to discuss the exact requirement(s). I know "500-level things" about Microsoft SQL Server. I have 7+ years of excep Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(30 recenzii)
4.9
eduardoherreral4

Hi I have read your description carefully. I have rich experiences in ⭐ SQL, database, MySQL, SQL server.... ⭐ I worked on many similar projects. I can guarantee the quality of the job. Please kindly message me. Thank Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(15 recenzii)
5.0
AliKhanXZT

Solve sql database issue Hello David S., I would like to grab this opportunity and will be dedicated to your work till you get 100% satisfied with the tasks. I have 10+ years of experience on SQL, MySQL, Database Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(2 recenzii)
4.4
bizmanas

Hi I have 15 years of experience in Sql server database development, mysql database development, postgresql database development. Expert in data analysis. Reporting using power Bi. Programming using C#and sql server. Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(14 recenzii)
4.6
yevhenrosovskii

Hi there, I've read your job description and found the skills recommended for me. As I'm a professional web developer with over 10 years of experience, It is good for me. I've rich experience in HTML, CSS, JavaScript, Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(7 recenzii)
4.6
dmytrosyrbyl

Hi there, I believe my eight years of experience in Database Management and strong knowledge of MongoDB, MySQL, and PhpMyAdmin make me an ideal candidate for the job. I have a proven track record of resolving table pr Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(4 recenzii)
4.3
vincentgrerry

Hi there.. I'm personal freelancer and interesting help you to solve sql database issue for migrating data wpr4_braapf_term_taxonomy_hierarchical to another database server with too large data.. and currently I'm re Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(23 recenzii)
4.4
nhdangit

Hi I am very good for MySQL, MongoDB and PostgreSQL, and Database management System Specially, I am rich experiences for Entry system for database with Admin dashboard So I can work with your project perfectly Please Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(11 recenzii)
4.4
Shakerfawzy

Hi, I have done this before a lot of times convert , migrate and import from many sources like TXT,CSV, Excel ,dB, SQLite ,DAT ,DBF ,Access ,MDB, XML, JSON, MySQL, PostgreSQL, SQL Server, etc. to other sources and vis Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(17 recenzii)
4.4
castillajoselui3

Hello! I’m Joseluis, I deliver high quality/low price and you get amazing satisfaction! No Stress! Thanks, Joseluis

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(13 recenzii)
4.1
AlikAgaian

⭐⭐⭐It's me you're looking for.⭐⭐⭐ Hi, there. I am a specialist with 6 years proven experience in Full Stack & Database development using Node.js,React.js& MySQL,MongoDB. I have checked your project description thoroug Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(2 recenzii)
3.8
Bhatti1987

I have more than 12 years of experience in Oracle/ SQL/ MySQL/ PostGre Server database modelling, design, development, and Administration. I have worked for database designing and modelling of complex business an effic Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(12 recenzii)
3.1
veselidevelop

Hey Mate David S., Good evening! As you can see in my profile I am professional web computer programmer not just a normal developer with skills including Database Programming, Microsoft SQL Server, MySQL, SQL and Data Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(3 recenzii)
3.1