Go Back   Forum Care Forums > Development Reference Area > MySQL Discussion

Reply
 
LinkBack Thread Tools Display Modes
MS SQL .BAK file to mySQL
Old
  (#1)
brian
Guest
 
Posts: n/a
Default MS SQL .BAK file to mySQL - 06-04-2007, 06:58 AM


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.

   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Re: MS SQL .BAK file to mySQL
Old
  (#2)
Guest
Guest
 
Posts: n/a
Default Re: MS SQL .BAK file to mySQL - 06-04-2007, 06:58 AM

On May 20, 6:51 pm, brian <bdoreste_n...@yahoo.com> wrote:
> 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.


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

Scroll down to MSSQL2MYSQL

Nino

   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Re: MS SQL .BAK file to mySQL
Old
  (#3)
brian
Guest
 
Posts: n/a
Default Re: MS SQL .BAK file to mySQL - 06-04-2007, 06:58 AM


On May 21, 1:34 pm, "nino9st...@yahoo.com" <nino9st...@yahoo.com>
wrote:
> On May 20, 6:51 pm, brian <bdoreste_n...@yahoo.com> wrote:
>
> > 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.

>
> http://dev.mysql.com/tech-resources/...from-microsoft...
>
> Scroll down to MSSQL2MYSQL
>
> Nino


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?




   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Re: MS SQL .BAK file to mySQL
Old
  (#4)
Guest
Guest
 
Posts: n/a
Default Re: MS SQL .BAK file to mySQL - 06-04-2007, 06:58 AM

On May 21, 2:14 pm, brian <bdoreste_n...@yahoo.com> wrote:
> On May 21, 1:34 pm, "nino9st...@yahoo.com" <nino9st...@yahoo.com>
> wrote:
>
> > On May 20, 6:51 pm, brian <bdoreste_n...@yahoo.com> wrote:

>
> > > 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.

>
> >http://dev.mysql.com/tech-resources/...from-microsoft...

>
> > Scroll down to MSSQL2MYSQL

>
> > Nino

>
> 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?


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

   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Contact Us - Forum Care Forums - Archive - Top