Define 2 db instances. Use one for autentication and the other for accounting.
Joao Frade -----Original Message----- From: Ali Gunduz [mailto:[EMAIL PROTECTED] Sent: quinta-feira, 17 de Julho de 2003 14:59 To: [EMAIL PROTECTED] Subject: RE: Simultaneous use of two DBs Well, I'm sure there are some migration utilities but I can't stop using DB2 (management's decision).. I can't use DB2 for start/stop packet logging (that's another issue that can't be solved) So I have to use DB2 for authentication purposes and I have to use postgresql (or any other lightweight DB) for logging purposes.. Any more suggestions? :) Thanks Ali > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Tim McCracken > Sent: Thursday, July 17, 2003 16:51 > To: [EMAIL PROTECTED] > Subject: RE: Simultaneous use of two DBs > > > > I don't know for sure about DB2 and Postgres but databases I > am familiar > with (Oracle, SqlServer, MySql) have the ability to export and import > tables via csv files. That would let you move the data. There are > also some commercial utilities to let you do it, and there are ODBC > drivers available for most databases as well. > > Depending on the referential integrity that is implemented and the > features of your particular database, the order that you import them > may be important. > > Tim > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf > Of Ali Gunduz > > Sent: Thursday, July 17, 2003 8:25 AM > > To: [EMAIL PROTECTED] > > Subject: Simultaneous use of two DBs > > > > > > Hi, > > > > I want to log start/stop packets in postgresql and use DB2 for > > authentication information. All my user information resides in DB2.. > > I cannot migrate it to postgresql. > > > > I couldn't figure out how I could do this in sql.conf.. > > > > Anyone has any suggestions or documents about this? > > > > Thanks > > > > Ali Gunduz > > > > > > - > > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
