Date: Fri, 23 Feb 2001 06:53:18 -0500 From: "Troy Settle" <troy@psknet.com> To: "FreeBSD Mailing List" <freebsd-isp@FreeBSD.ORG> Subject: RE: MS SQL replicated to MySQL Message-ID: <GIEHKBHPBGKJPNMBCOHFKEHNCAAA.troy@psknet.com> In-Reply-To: <NEBBJFIIGKGLPEBIJACLIECEDCAA.davew@sai.co.za>
next in thread | previous in thread | raw e-mail | index | archive | help
David, FYI, this question would be much better suited for an NT or MSSQL mailing list. You can indeed replicate from MSSQL to an MySQL. Check the books online for information regarding replication. I've played with this a little, and it seems to work fairly well. A better solution would be to patch exim and qpopper to query your MSSQL database directly. See /usr/ports/databases/freetds and http://www.freetds.org for details. -- Troy Settle Pulaski Networks 540.994.4254 They told me to think out of the box, but I tripped over it, now I own my own company. > -----Original Message----- > From: owner-freebsd-isp@FreeBSD.ORG [mailto:owner-freebsd-isp@FreeBSD.ORG] > Sent: Thursday, February 22, 2001 1:26 PM > To: FreeBSD Mailing List > Cc: Sendmail-Questions > Subject: MS SQL replicated to MySQL > > Hi guys, > > I'm running qpopper+mysql+exim patch which allows pop3 logins etc. via a MySQL database. > All my user are on MS SQL, thus I have to manually import data to MySQL > It works brilliantly, the only problem is that I need to now continuosly import the users from MS SQL to MySQL > Is there anyway to replicate MS SQL data to MySQL. > Or maybe I should switch to some type of sendmail arrangement that supports ODBC ? > > Thanks > Any guidance would be appreciated. > > Kindest regards > David Wilson > The S.A Internet > > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?GIEHKBHPBGKJPNMBCOHFKEHNCAAA.troy>