0

I need to achieve:

  1. similar demands in this question: How to export data from SQL Server 2005 to MySQL

  2. change table structure and column names, for example:

Source(sql server):

Table A

id studentName
--------------    
1  John    
2  Jim

Table B

id teacherName
--------------
1  Kate
2  Mat

Destinations(mysql):

Table C // Table A、B are combined

id name    // here the column name changed
-------
1  John
2  Jim
3  Kate
4  Mat
Improve this question
3
  • @sashkello UNION? Sorry, I am a rookie for this, could you give some more details? Thanks. Commented Jun 8, 2013 at 9:43
  • 2
    If you change structure and data it can hardly be called "conversion"... Commented Jun 13, 2013 at 15:12
  • What about your ids? You can't merge these as in your example, they will be duplicated. You can regenerate these but then any related tables with a foreign key will be pointing to the wrong record. Commented Dec 28, 2015 at 23:23
Related questions
0
SQL Server to mySQL converter
4
Migrate Data and Schema from MySQL to SQL Server
4
converting mysql database to sql server
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.