MSSQL -> MySQL Questions

This topic is empty.

Viewing 4 reply threads

Author

Posts
- October 9, 2004 at 11:30 pm #8600
  
  RedwoodTree
  Member
  
  I'm trying to move a MSSQL db to MySQL…and think the 'yog' may work…I am using the free trial. I did an ODBC import of “tables” (first sign of trouble) and created a SQL script instead of making the actual import, so I can see what 'would' happen :0
  
  It looks like the import completely ignores:
  
  1. Indexes
  
  2. Primary keys
  
  3. Default table values
  
  4. Identify/auto-increment field defs
  
  5. PK/FK relationships
  
  So…the general question, how do I move a MSSQL DB (WITH ALL STRUCTURAL ELEMENTS) into MySQL???
  
  Surely i did something wrong, because just creating tables and filling in some data is the easy part…I want to automatically rebuild the EXACT same db in MySQL.
- October 10, 2004 at 5:12 am #16362
  
  Ritesh
  Member
  
  Currently, SQLyog's ODBC Import Tool only supports importing of Table Structures and Data.
  
  We plan to add options for importing other objects like Indexes, PKs, FKs in the next version i.e. 4.1.
- October 20, 2010 at 3:30 pm #16363
  
  ajanamills
  Member
  
  I am trying out the import feature on the evaluation edition too. I have set up a ODBC connection with the MSSQL 2005 server, tested it with the password and it connects. Only when I go to connect using SQLyog it gives a “could not connect error”
  
  ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'bac'.
  
  ERROR: Import aborted…
  
  Any idea what could be wrong?
- October 20, 2010 at 3:30 pm #16364
  
  ajanamills
  Member
  
  I am trying out the import feature on the evaluation edition too. I have set up a ODBC connection with the MSSQL 2005 server, tested it with the password and it connects. Only when I go to connect using SQLyog it gives a “could not connect error”
  
  ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'bac'.
  
  ERROR: Import aborted…
  
  Any idea what could be wrong?
- October 20, 2010 at 5:01 pm #16365
  
  peterlaursen
  Participant
  
  hmmm .. no idea at the moment really.
  
  1)
  
  Could you try if you are able to import to Excel using same DSN settings?
  
  (Excel menu. .. Data .. Import external Data .. import Data .. select ODBC DSN in the dropdown in Excel 2003)
  
  2)
  
  Check if some firewall or similar type of program is the problem?
Author

Posts