On Sun, Sep 30, 2001 at 01:00:07PM -0400, Will French wrote:
> I'm not sure what you mean by "stand-alone". If you mean not connected to a
> network then I don't see how since ms-sql-server only runs on Windows and
> you have specified that your mysql server is linux.
>
> Unless you have a huge schema (lots of tables and/or lots of columns) I
> would suggest using the "generate sql script" command in sql-server
> enterprise manager and then editing the file as necessary for compatibility
> with mysql (e.g. changing bit fields to tinyint, etc). Once you have the
> database created in mysql, I would use a combination of the bcp utility
> (with the "/t" option which creates tab-delimited output) and the "load data
> infile" command to load it into mysql.
>
> It is possible that someone has created a more automated way of doing this
> and if so that would be worth checking out.
>
> Will French
>
> > -----Original Message-----
> > From: --- [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, September 30, 2001 12:53 PM
> > To: [EMAIL PROTECTED]
> > Subject: ms SQL server 7.0 -- > mysql?
> >
> >
> >
> > how can i transfer a database from sql server to mysql (linux) on a
> > stand-alone ws?
> > --
> > "When you have eliminated the impossible,
> > whatever remains, however improbable,
> > must be the truth."
> > --Sherlock Holmes _The Sign of Four_
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ms sql server is in our school and since i want to learn mysql, i want
to copy the sammple databases from the school to my house. how do i do
that? from ms sql --> txt --> mysql?
--
"When you have eliminated the impossible,
whatever remains, however improbable,
must be the truth."
--Sherlock Holmes _The Sign of Four_
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php