> 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?
The method I outlined is exactly that mssql->txt->mysql. Obviously, since the two machines do not seem to be networkable, I am assuming that you have some means (cd-burner, etc.) of moving data from your windows machine to your linux machine at home. Both the "generate sql scripts" function and bcp create text files which can be copied to the medium of your choice. Will French > -----Original Message----- > From: --- [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 30, 2001 1:14 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: ms SQL server 7.0 -- > mysql? > > > 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
