CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 5 of 5
  1. July 29th, 2010, 01:40 PM #1
    troshnee
    troshnee is offline Junior Member
    Join Date
    Jul 2010
    Posts
    1

    Import data from MySQL to SQL Server

    Hi,
    I have an application where i need to provide an interface for the user to automatically import data from MySQL to SQL Server 2000. The table structures are same. The application is in VB 6.0.
    Can anybody suggest how i may proceed?

    Thanks
    Reply With Quote Reply With Quote
  2. July 29th, 2010, 02:25 PM #2
    DataMiser
    DataMiser is offline Elite Member Power Poster
    Join Date
    Jul 2008
    Location
    WV
    Posts
    5,362

    Re: Import data from MySQL to SQL Server

    One way of course would be to open a recordset. loop through that recordset creating insert statements for the other db.
    Always use [code][/code] tags when posting code.
    Reply With Quote Reply With Quote
  3. July 29th, 2010, 04:30 PM #3
    dglienna's Avatar
    dglienna
    dglienna is offline ex MVP - Visual Basic Power Poster
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: Import data from MySQL to SQL Server

    A lot of work, if the field types are as different as I suspect...
    David

    CodeGuru Article: Bound Controls are Evil-VB6
     2013 Samples: MS CODE Samples
    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!
    Reply With Quote Reply With Quote
  4. July 29th, 2010, 04:33 PM #4
    DataMiser
    DataMiser is offline Elite Member Power Poster
    Join Date
    Jul 2008
    Location
    WV
    Posts
    5,362

    Re: Import data from MySQL to SQL Server

    If the structures are the same it should be fairly simple actually.
    Always use [code][/code] tags when posting code.
    Reply With Quote Reply With Quote
  5. July 29th, 2010, 06:28 PM #5
    dglienna's Avatar
    dglienna
    dglienna is offline ex MVP - Visual Basic Power Poster
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: Import data from MySQL to SQL Server

    Here are a few differences:

    http://www.postgresonline.com/journa...ostgreSQL.html
    David

    CodeGuru Article: Bound Controls are Evil-VB6
     2013 Samples: MS CODE Samples
    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured