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
