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
Community
  • 1
  • 1
Jack Hu
  • 1,315
  • 2
  • 13
  • 27
  • @sashkello UNION? Sorry, I am a rookie for this, could you give some more details? Thanks. – Jack Hu Jun 08 '13 at 09:43
  • 2
    If you change structure and data it can hardly be called "conversion"... – Álvaro González Jun 13 '13 at 15:12
  • What about your `id`s? 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. – Lock Dec 28 '15 at 23:23

0 Answers0