From owner-freebsd-isp Fri Feb 23 3:53:23 2001 Delivered-To: freebsd-isp@freebsd.org Received: from orion.psknet.com (mail.psknet.com [63.171.251.4]) by hub.freebsd.org (Postfix) with SMTP id E3E7437B491 for ; Fri, 23 Feb 2001 03:53:20 -0800 (PST) (envelope-from troy@psknet.com) Received: (qmail 88998 invoked from network); 23 Feb 2001 11:53:19 -0000 Received: from abyss.dashit.net (HELO ABYSS) (209.100.22.250) by mail.psknet.com with SMTP; 23 Feb 2001 11:53:19 -0000 From: "Troy Settle" To: "FreeBSD Mailing List" Subject: RE: MS SQL replicated to MySQL Date: Fri, 23 Feb 2001 06:53:18 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Importance: Normal In-Reply-To: X-AntiVirus: scanned for viruses by Pulaski Networks (http://www.psknet.com) using AMaViS (http://www.amavis.org) Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org 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