If your app is .net get the .net provider for mysql and give it to your dba/programmer with the docs, he/she will figure it out. No different than talking to ms sql with .net except you reference a different data provider.
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:asterisk-users- > [EMAIL PROTECTED] On Behalf Of Irakli Natsvlishvili > Sent: Tuesday, June 14, 2005 12:43 AM > To: 'Asterisk Users Mailing List - Non-Commercial Discussion' > Subject: RE: [Asterisk-Users] Keeping users, extensions,voicemail and so > on in DB > > Thanks for info . How do you integrate * specific data in mysql with data > from MSSQL? App is running on .NET, in this case it will need to have > assess to both DBs and update them simultaneously. Sorry, I'm not a DB > admin. > > > I.N. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Damon Estep > Sent: Monday, June 13, 2005 11:21 PM > To: Asterisk Users Mailing List - Non-Commercial Discussion > Subject: RE: [Asterisk-Users] Keeping users, extensions,voicemail and so > on > in DB > > Forget about MS SQL, odbc drivers that run on linux to talk to MS SQL > stink Odbc in general stinks. > > You might be able to get MS SQL DTS (data transformation services) to > link to the mysql database and present the data as it were in your ms > sql database. > > There is a pretty good odbc 3.51 mysql driver for windows, as well as a > .net provider. Both at www.mysql.org. > > Mysql is free, * will talk to is using the native TDS > > You can run the windows version of mysql on a windows box if you wish, > but why? Faster if it is on the same box as asterisk unless * is heavily > loaded. > > I tried the * > realtime > odbc > mssql thing, gave up after having poor > results getting the various ms sql drivers for linux to work right. > > our main app uses data in ms sql and mysql and there is a common key in > the data to link accounting data with the * user data for views where > they are both required. > > We also use mysql for cdr for billing purposes. > > I was much more comfortable with .net ms sql, but the transition and > integration with mysql was easy. Just store the asterisk specific data > in mysql, everthing else in ms sql if you must. > > > > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:asterisk-users- > > [EMAIL PROTECTED] On Behalf Of Irakli Natsvlishvili > > Sent: Tuesday, June 14, 2005 12:04 AM > > To: 'Shamsul Arefin'; 'Asterisk Users Mailing List - Non-Commercial > > Discussion' > > Subject: RE: [Asterisk-Users] Keeping users, extensions,voicemail and > so > > on in DB > > > > Could you go with some details? What was better performance, > stability? > > All our user info is in MS SQL and we have billing based on it, so it > > won't > > be easy to move to mysql. > > > > I.N. > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Shamsul > > Arefin > > Sent: Monday, June 13, 2005 10:36 PM > > To: Asterisk Users Mailing List - Non-Commercial Discussion > > Subject: Re: [Asterisk-Users] Keeping users, extensions,voicemail and > so > > on > > in DB > > > > Yes it is now possible to store configuration files in database, via > > Mysql support or via ODBC. But we have find that Mysql is works much > > better. > > > > regards > > shams > > > > On 6/14/05, Irakli Natsvlishvili <[EMAIL PROTECTED]> wrote: > > > Hello, > > > > > > I have one question regarding *. Default configuration for asterisk > is > > to > > > keep configuration(s) in ordinary text based config files. > > > > > > My question is simple: is it possible to keep those config info (at > > least, > > > to start from - sip.conf, extensions.conf and voicemail.conf) on a > > database, > > > which asterisk access via ODBC. If it is possible, I'd appreciate if > > someone > > > points me where I can read more about it and shows me some examples. > > Also > > > I'd like to know, how asterisk behaves (in terms of stability and > > > performance) in this environment. > > > > > > > > > I.N. > > > > > > _______________________________________________ > > > Asterisk-Users mailing list > > > [email protected] > > > http://lists.digium.com/mailman/listinfo/asterisk-users > > > To UNSUBSCRIBE or update options visit: > > > http://lists.digium.com/mailman/listinfo/asterisk-users > > > > > > > > > -- > > Best Regards > > Shamsul Arefin > > Saktek Technologies > > _______________________________________________ > > Asterisk-Users mailing list > > [email protected] > > http://lists.digium.com/mailman/listinfo/asterisk-users > > To UNSUBSCRIBE or update options visit: > > http://lists.digium.com/mailman/listinfo/asterisk-users > > > > _______________________________________________ > > Asterisk-Users mailing list > > [email protected] > > http://lists.digium.com/mailman/listinfo/asterisk-users > > To UNSUBSCRIBE or update options visit: > > http://lists.digium.com/mailman/listinfo/asterisk-users > _______________________________________________ > Asterisk-Users mailing list > [email protected] > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > > _______________________________________________ > Asterisk-Users mailing list > [email protected] > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
