Professional Web Applications Themes

MS SQL .BAK file to mySQL - MySQL

I have a MS SQL .BAK file which I would like to convert directly to mySQL, however, I do not have access to a MS SQL server. How can I accomplish this task? Thanks for any help....

  1. #1

    Default MS SQL .BAK file to mySQL


    I have a MS SQL .BAK file which I would like to convert directly to
    mySQL, however, I do not have access to a MS SQL server.

    How can I accomplish this task?

    Thanks for any help.

    brian Guest

  2. #2

    Default Re: MS SQL .BAK file to mySQL

    On May 20, 6:51 pm, brian <com> wrote: 

    http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

    Scroll down to MSSQL2MYSQL

    Nino

    nino9stars@yahoo.com Guest

  3. #3

    Default Re: MS SQL .BAK file to mySQL


    On May 21, 1:34 pm, "com" <com>
    wrote: 


    >
    > http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft...
    >
    > Scroll down to MSSQL2MYSQL
    >
    > Nino[/ref]

    Yes, I read this article, and have the MSSQL2MYSQL software, however
    this software requires access to an existing MSSQL installation, of
    which I do not have.

    How do I take the .BAK file and migrate it directly to mySQL without a
    MSSQL server installation?




    brian Guest

  4. #4

    Default Re: MS SQL .BAK file to mySQL

    On May 21, 2:14 pm, brian <com> wrote: 
    > [/ref]
    > [/ref]
    > [/ref]



    >
    > Yes, I read this article, and have the MSSQL2MYSQL software, however
    > this software requires access to an existing MSSQL installation, of
    > which I do not have.
    >
    > How do I take the .BAK file and migrate it directly to mySQL without a
    > MSSQL server installation?[/ref]

    Hmmm... Have you opened the .BAK file in a text editor? Is there an
    easy way to rewrite it (copy paste) so MySQL can access it? Or perhaps
    importing some of the data into Excel, formating it and dumping it as
    a text file? Can't say I've ever seen the content of a .BAK file, so
    I'm not sure how to help beyond just general advice... I would guess
    the SQL commands are pretty similar in creating and inputting the
    data, but the format might be slightly different. Nothing a search and
    replace couldn't fix?

    Nino

    nino9stars@yahoo.com Guest

Similar Threads

  1. Trace file in MySQL
    By teddysnips@hotmail.com in forum MySQL
    Replies: 0
    Last Post: September 20th, 09:36 AM
  2. Missing mysql.so file for my php!
    By Skaarak in forum MySQL
    Replies: 0
    Last Post: January 16th, 06:39 PM
  3. file or mysql
    By chris in forum PHP Development
    Replies: 5
    Last Post: November 8th, 12:51 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139