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