Find Jobs
Hire Freelancers

Want to fetch data from MSSQL and stored it into MySQL with all fields and all the tables

$30-250 USD

Closed
Posted about 6 years ago

$30-250 USD

Paid on delivery
I think these are best words to explain the job - I have two server, one is Window server, where "MSSQL" Installed Second server is Linux server, where “MySQL” Installed what I want - I want to fetch data from MSSQL and stored it into MySQL with all fields and all tables. Note: - We can not make any change in First Server (MSSQL) and can not install any .EXE file or other software on the server. if you have any solution please let me know. Thanks
Project ID: 16581124

About the project

22 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
22 freelancers are bidding on average $176 USD for this job
User Avatar
1. Copy the MsSQL database with it's all fields and all tables; 2. And Stored them into MySQL database; This two tasks I need to complete. But before make any commitment or start working, I will prefer if I get a chance to check both the databases; If you have any issue to share the database, can share your screen with me. so that I can check the databases once. Regarding data insert from MS SQL to MySQL, It will be better if I Create a linked server that will allow to write and Query data from MsSQl using stored procedures in MsSQL; LinkedServer and OPENQUERY could be good, if you are moving not too much records per cycle. The INSERT is a bit tricky with OPENQUERY: INSERT INTO OPENQUERY (MSSQL, 'SELECT * FROM MSSQL_Table') SELECT * FROM dbo.SQLServer_Table OR INSERT INTO OPENQUERY (MSSQL, 'SELECT * FROM MSSQL_Table') VALUES ('Value1', 'Value2', ...) In case of move lots of data (like thousands or millions of rows)- Integration Services Package is a good solution; I can schedule them with SQL Server Agent. Now your decision is most important for me; Please let me know which time be convenient for you to have a discussion with me. I will make my planning accordingly. Hoping to have a prompt and affirmative response by your end.
$263 USD in 7 days
5.0 (284 reviews)
9.3
9.3
User Avatar
Hi, I have developed similar data/web automation projects in past. Please let me know if you are interested and I am available to start right away.
$155 USD in 3 days
4.8 (287 reviews)
8.2
8.2
User Avatar
Hello! I'm an experienced software developer (8+ years). I already have experience with both database so I believe that I can help you migrate your information. Best regards
$188 USD in 2 days
5.0 (59 reviews)
7.2
7.2
User Avatar
Hello, Hope you are doing well. I have 5 years of experience on MssQL and MySQL. We can export database from MSSQL and Import into MySQL Regards, Vishnu
$100 USD in 1 day
5.0 (425 reviews)
7.2
7.2
User Avatar
Hi, We can create system to access tyhe database using php. And then we will query MSSQL to get all data tablewise and will save into MySQL database. Looking forward for your response. Thanks.
$155 USD in 3 days
5.0 (163 reviews)
6.8
6.8
User Avatar
Hi, Dear Employer! How are you? I am really interested in your project. I have enough experience on DataBase, C/C++, C#, java programming. I am 100% sure i can satisfy your requirements perfectly. User-Friendly Interface And Clear Algorithm Will Encourage Your Project. I want a long term relationship with you. Thank you and best regards!
$222 USD in 3 days
4.7 (60 reviews)
7.0
7.0
User Avatar
Hello. How big is your database? how many tables does it contains? I think about a writing a script and doing it for single day.
$111 USD in 1 day
4.9 (20 reviews)
5.6
5.6
User Avatar
Hello, I have more than 10 years of experience in .NET Development with hands on experience in all .NET related technologies. I have completed more than 400 projects for various clients. Check Portfolio and reviews for some of the past work done. Relevant Skills and Experience .NET Framework: 9 years ASP.NET: 10 years AngularJS: 7 years C#: 10 years HTML: 10 years CSS: 10 years Javascript: 10 years MVC: 10 years WPF: 9 years MSSQL: 10 years Website Design: 10 years Can we connect to discuss further about the Project?
$166 USD in 7 days
4.8 (22 reviews)
5.9
5.9
User Avatar
Hi, I am a Full stack developer in Microsoft technologies. My area of expertise is web application development, web services (SOAP & RESTFul), Sql Server as back end (through stored procedures). I have 6 plus years of experience as a full time software developer. As per your description, I understand that you cannot install any exe or software on the first server (with MSSQL). The solution I propose is, if you give me db credentials (db server address, user name, password) for the MSSQL. We can come up with a application which reads from MSSQL and writes to MySQL. Kindly contact me, lets discuss the solution further.
$111 USD in 3 days
4.9 (28 reviews)
5.3
5.3
User Avatar
A proposal has not yet been provided
$111 USD in 3 days
4.9 (23 reviews)
4.6
4.6
User Avatar
Dear sir, I'm very interested for this database project project, I have 4+ Year of experience in this Field & I can surely do this project, I work with Team who always looking for such type of project, so please try to give me one chance. Please let me know more about your Project details. Please message me on PM for further discussion. We are always ready to serve you our Best economical Services. Thanks & Regards Roshni
$155 USD in 3 days
4.5 (6 reviews)
3.7
3.7
User Avatar
Hi. My name is Oleg and I am senior C#/.NET software developer from Ukraine. Please contact to discuss details regarding the project. Hope you have at least connection strings to both servers.
$200 USD in 3 days
5.0 (2 reviews)
3.4
3.4
User Avatar
Hi, Hope you are doing well? We can achieve this with various method. Out ofwhich MSSQL provides ETL way to do it. Could we please have a discussion? Thanks, Pratik Gedia
$111 USD in 3 days
4.6 (3 reviews)
3.3
3.3
User Avatar
We can extract data from MSSQL to txt files and insert into MySQL with some scripts. Share your MSSQL database (backup file) and I can make some scripts to show you
$155 USD in 10 days
5.0 (2 reviews)
2.0
2.0
User Avatar
Hi Recruiter I was looking at your requirement and found I am the perfect candidate for your job because I can do this job in your budget through Dataware housing technique. I am new on freelancer but I have good knowledge of web app development, please have a look and give me a chance to show my knowledge, I will not let you down. Thanks & Regards Ankit Gupta Sr. Associate MS Group
$184 USD in 3 days
5.0 (2 reviews)
1.4
1.4
User Avatar
I have maintaining servers and databases (MySQL) in my current working company. During installation of products, I also worked with MSSQL database. so I have both experiences. By writing queries I can take backups and extract that data. I have a question about your database schemas (structure) are they (in MSSQL and in MySQL) same or they different? If both are same then that might be easy to store data but if they are different then might be difficult. But I assure you I will complete that.
$172 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$555 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have extensive experience on MS SQL and MYSQL databases. Developed applications on both the platforms.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Indore, India
4.9
67
Payment method verified
Member since Sep 8, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.