Anything is possible, this will depend on your situation. If you just want to replicate the data once, you can dump it all in text format (say, tab-separated fields, CRLF-separated records) onto a few CDs, and import them into MySQL using mysqlimport.
If you have the two machines networked, it's that much easier, but you will still export to text and import to mysql. If you want the replication to run continuously, so that the mysql version is usually up-to-date, you can still use the same method but it will require a bit of scripting and will be clumsy, use a lot of disk, etc. But it's all possible. -steve > We have a SQL2000 database (about 15GB) and we want to develop some > webapplications to present the content. We dont want to use the current > DB-server but insted make a replica to run the application on, i.e. a new > server. Would it be possible to replicate the SQL2000 to a mySQL server? > (One of the reasons for this is that we have a rather large Sun-server > which we are not using for anything) -- Steve Rapaport World Citizen --------------------------------------------------------------------- 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
