Find Jobs
Hire Freelancers

Database Migration and Conversion (updated)

$30-250 USD

Closed
Posted over 9 years ago

$30-250 USD

Paid on delivery
This is a second project to be reissued to the previous project freelancer. Looking for someone that can export a Microsoft SQL Server database to be imported into MySQL, preferably providing us with a mysql dump to be imported directly into our mysql server. We've attempted several different export types from Microsoft SQL Server Management Studio and all have failed on export or failed on import into mysql. Attempted: - MS Excel - MS Access - Flat File In our latest attempt we used MySQL Workbench to try migrating the SQL database to MySQL. This process fails on the "Reverse engineer selected schemata" with the error below. It seems that the data in some of our tables may be incompatible with the export tools and/or corrupt. When we do successfully export the data using excel we get errors on import into mysql. We would like to have you isolate the errors so that they can be fixed. We will need to process this once to get all of the tables and then have the ability to download and import the database once the new website is live in order to pull all of the most recent information.
Project ID: 6631179

About the project

29 proposals
Remote project
Active 9 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
29 freelancers are bidding on average $152 USD for this job
User Avatar
Please provide me the error details and sample SQL server database. I have made my custom software in c# that takes the data from one database (E.g. SQL server) and export it to other database (E.g. MYSQL). Looking forwarad for db so that i could suggest something
$111 USD in 3 days
4.9 (168 reviews)
6.8
6.8
User Avatar
A proposal has not yet been provided
$142 USD in 3 days
4.8 (136 reviews)
6.9
6.9
User Avatar
Hi Sir, I can do it right now and after send the mysql script file for you so you can import to your db. Please supply me the source sql server file. Thanks
$122 USD in 3 days
4.8 (71 reviews)
6.3
6.3
User Avatar
Hi, This is my bid to redo the work as discussed. I will download the database and start working on it. Please put me in touch with your developer and we should be good to proceed.
$55 USD in 3 days
5.0 (62 reviews)
6.0
6.0
User Avatar
Hi, I am an expert software engineer having great experience in database development , migration. I am interested in your project . I have worked on different projects where i was needed to migrate database. I have done migration from mysql to sqlite in one of my projects here on freelancer dot com. Looking for a positive response from your side. Thanks
$100 USD in 3 days
5.0 (9 reviews)
5.7
5.7
User Avatar
A proposal has not yet been provided
$277 USD in 3 days
4.9 (3 reviews)
4.9
4.9
User Avatar
Hi, I have gone through your requirements ,I am a DBA at CMMI-5 Level company since August 2004.I am working on MySql,MSSQL Server,Oracle database, I can do your job confidently. I have lot of experience to migrating Database.(MSSQL to MySQL,MSSQL to Oracle,MySQL to MSSQL ) I am very much Interested to do your work,Please revert me if you have any concern .I am ready to start now
$222 USD in 3 days
4.1 (39 reviews)
5.7
5.7
User Avatar
I have expertise in MS SQL Server(2000 - 2012) and mySQL database. I also have good skills in DBA. I can do this project. Please provide me data file of MS SQL Server then I will convert them into mySQL database for you. I can start to work on this project right now.
$105 USD in 5 days
5.0 (10 reviews)
4.5
4.5
User Avatar
Hi, I can help transfer data from MSSQL to MySQL as I have done this number of times and large volume of data (of the order of GBs as well involving multi-byte characters) in my current project. I have 13+ years of experience in SQL development in DB platforms such as MSSQL, MySQL, Adaptive server. Overall I have 20+ years experience in IT services. the quote shared is with the following assumptions: -- number of tables upto 15 -- total size of data to be transferred upto 3GB -- only tables and contents of the table needs to be transferred -- MSSQL db dump will be the input -- MySQL database backup file to be the output please clarify the following queries: - what is the MSSQL version? - what is the MySQL version? - does the data involve muti-byte characters like Russian,chinese,japanese etc - does the data involve text or image columns? - what should be engine type for the tables to be created in MySQL? - does it involve any datatype that cannot be mapped directly with MySQL datatype? hope to hear from you regards Babu
$222 USD in 3 days
5.0 (2 reviews)
3.6
3.6
User Avatar
A proposal has not yet been provided
$100 USD in 3 days
5.0 (7 reviews)
3.3
3.3
User Avatar
The data migration is possible through programming. We have to create a MySQL database with the same structure as in MS SQL and the make a program which connects to both MS SQL and MySQL databases at the same time and then copy the data. Thanks
$100 USD in 3 days
4.9 (11 reviews)
3.5
3.5
User Avatar
I have 10+ years experience of software development using Foxpro2.6(dos), Visual Foxpro 6 & 9, SQL Server 2000,2005,2008, C#, ASP.Net, MVC, Crystal Reports,MySql, HTML, CSS, JavaScript, jQuery, jQuery UI, Bootstrap, Foundation etc. I have developed lot of client/server database softwares like Accounting, Inventory, Taxation, Payroll, Production, ERP Implementation and more. I am proficient in MS Sql writing complex queries, stored procedures, functions, triggers, query optimization and performance tuning. Please provide you MS Sql database backup. I will convert it programmatically.
$200 USD in 10 days
4.8 (9 reviews)
3.3
3.3
User Avatar
Hi, I’m software and database developer with more than 30 years experience. In the past 20 years I have worked (in-situ) for two international organizations (Inter-American Tropical Tuna Commission, in San Diego, CA, and the Food and Agriculture Organizations of the United Nations, in Victoria, Seychelles). I'm sure I can help you with your problem. The fact is, I have done a fair amount of porting from MS-SQL to MySQL (as well as other databases). There are several issues that will come out with these portings, particularly if you are not using standard SQL data types. Most of-the-box porting tools do a decent job, but can fail partially on a specific column data type, which at the end, amounts to nothing. I have extensive knowledge on both DBMS, so I can write the necessary code to ensure a successful porting of data and schema to your MySQL database. Please note that I'm bidding somehow blindly, because I need to see your database schema in order to give you a more realistic estimate of the time and cost of the porting. If you think you may be interested in my services, please drop me a chat, so we can discuss further your project. regards, Marco García
$277 USD in 5 days
5.0 (2 reviews)
3.0
3.0
User Avatar
Hi, Please mention your sql server version number and mysql version number. This error mostly happen due to data type mismatching and version numbers. Sure this can be rectified either using manual table creation and bulk data upload. If version of both database match then it can be automated too. As i have done migration previously these task are familiar to me. I can ensure to deliver correct database schema and data in it.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, My name is walid, I worked on similar issues before and I think that I can help. have a nice day :)
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Please let us know the size of the database that you want to import into My SQL from MS SQL Server Management Studio?
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am working as DBA . I can do your task.
$222 USD in 15 days
0.0 (0 reviews)
0.6
0.6
User Avatar
Ainda não foi fornecida uma proposta
$111 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Without really looking at the errors you get i can't tell you how i'll fix it, or how easy or not it will be for me. But i'm willing to research all i need to figure out and fix the issue.
$45 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I've done such migration/conversions in the past. I will be able to convert this MSSQL database successfully. Please provide the database and I'll start doing it for you. I have following questions 1) What is the total size? 2) Does this contain functions, stored procedures, triggers, indexes etc? 3) Does this have multiple languages data? 4) Does this have objects stored as CLOB/BLOB? 5) Does this have timezone related data? I have handled such situations earlier. You can trust me with your data since I'll surely keep this confidential and will be deleted once the work is over. Once you can provide the database, I'll probably would have finished converting this fully by the end of bidding period Best wishes, Sridevi
$134 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Charlotte, United States
5.0
31
Payment method verified
Member since Nov 6, 2006

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.