Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

DataBase Migration

Posted on 2013-06-24
2
168 Views
Last Modified: 2013-07-12
I want to migrate MS-sql (2008 onwards) database to MySQL .The data base contains 6-10 tables and main table contains 10 Cr rows
0
Comment
Question by:helpme2013
2 Comments
 
LVL 6

Expert Comment

by:Vijay Pratap Singh
ID: 39273770
http://dbconvert.com/convert-mssql-to-mysql-pro.php is able to do data mapping between MSSQL and MySQL. Just choose data types you need for the target fields or the most appropriate data types for the source type and our program will automatically transform types from one specific format to another.

http://dbconvert.com/convert-mssql-to-mysql-pro.php is able to do data mapping between MSSQL and MySQL. Just choose data types you need for the target fields or the most appropriate data types for the source type and our program will automatically transform types from one specific format to another.
0
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 500 total points
ID: 39274445
Check oracle site. I will find the tool for migration to Mysql from other DB.


https://blogs.oracle.com/MySQL/entry/meet_the_mysql_experts_podcast5
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
tempdb log contention 16 50
sql help 8 58
SQL Server - executing an agent job from a stored proc 2 25
average of calculation (TSQL) 4 26
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question