Database Migration and Conversion (updated)
$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 freelancers are bidding on average $152 for this job
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 More
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
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.
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 More
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, a More
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 a More
Hello, My name is walid, I worked on similar issues before and I think that I can help. have a nice day :)
Please let us know the size of the database that you want to import into My SQL from MS SQL Server Management Studio?
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.