The idea was to have an exact replica which is always up to date. They will
be networked, but is this really the only solution? I had pictured
something like a trigger in the MSSQL that could push-replicate to the
mySQL. The mySQL would then only update the changed data in the MSSQL.
Med venlig hilsen/Best regards
Steffen Tang
Steve
Rapaport To: [EMAIL PROTECTED]
<steve@petabi cc: [EMAIL PROTECTED]
t.com> Subject: Re: Replication between MSSQL
and mySQL
03-01-2002
17:50
Please
respond to
steve
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
---------------------------------------------------------------------
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
