Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-18 Thread Merlin Moncure
On 8/18/06, Magnus Hagander <[EMAIL PROTECTED]> wrote: > the .net 'way' of database application development is to keep all > the logic in the .net middleware. please note that I am completely > opposed to this because it obfuscates good data management > practices. > however based on the op's co

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-18 Thread Magnus Hagander
> > > well, since he wrote his app in vb.net he is probably using > > > postgresql as a dumb data store, it might not be all that > difficult. > > > still, not a very smart move. > > > > so if you have functions on server side or triggers or rules... > then > > you need some rewrite on the app... o

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-14 Thread Jeff Davis
On Sat, 2006-08-12 at 08:08 -0700, RPK wrote: > How can I migrate a PostgreSQL database to MySQL or MS Access? Are there any > tools available? Although migrating away from PostgreSQL is not a popular idea on this list, it can be done. If you're using any PostgreSQL-specific features, plan how yo

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-14 Thread macgillivary
for an excellent book on keeping things where they should be go buy: "The ART of SQL" by Stephane Faroult. Sample chapter online. http://www.oreilly.com/catalog/artofsql/ It's an excellent read, and provides ample arguments for keeping constraint management with the database and not in each of th

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-14 Thread Philippe Lang
[EMAIL PROTECTED] wrote: > How can I migrate a PostgreSQL database to MySQL or MS > Access? Are there any tools available? Hi, Can we know maybe why you want to do this? --- Philippe Lang Attik System smime.p7s Description: S/MIME cryptographic signature

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-13 Thread Ashley Moran
On Aug 13, 2006, at 2:16 pm, Thomas Kellerer wrote: I do agree that this might be a problem of universty education which focuses too much on theory and not on real-world problems. From what I've seen, a bigger problem is universities that focus on neither!!! Ashley -

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-13 Thread Bill Bartlett
> On 8/12/2006 Merlin Moncure <[EMAIL PROTECTED]> wrote: > the .net 'way' of database application development is to keep > all the logic in the .net middleware. please note that I am > completely opposed to this because it obfuscates good data > management practices. however based on the op's

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-13 Thread Thomas Kellerer
Ashley Moran wrote on 13.08.2006 13:46: I can't understand how developers employed to created database-backed applications think they can get anywhere with so little understanding of what they are doing. Well spoken!! I have actually written a 10-page introduction to relational theory, based

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-13 Thread Ashley Moran
On Aug 13, 2006, at 11:34 am, Dave Page wrote: I see a similar issue in my line of work. Many of the programmers (even those working for the larger software houses in the social housing sector) have started out their careers as housing offices or maintenance surveyors or whatever and have d

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-13 Thread Dave Page
On 13/8/06 09:57, "Thomas Kellerer" <[EMAIL PROTECTED]> wrote: > Harald Armin Massa wrote on 13.08.2006 10:46: >> Do you know for what benefit that happens? I have seen similiar stupidity >> with EJB, having RI within that layer. Why are people doing this? Do they >> know something I miss, or d

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-13 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thomas Kellerer wrote: > Harald Armin Massa wrote on 13.08.2006 10:46: >> Do you know for what benefit that happens? I have seen similiar stupidity >> with EJB, having RI within that layer. Why are people doing this? Do they >> know something I miss, o

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-13 Thread Thomas Kellerer
Harald Armin Massa wrote on 13.08.2006 10:46: Do you know for what benefit that happens? I have seen similiar stupidity with EJB, having RI within that layer. Why are people doing this? Do they know something I miss, or did they just not vivist Databases 101 ? I think this happens because of th

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-13 Thread Harald Armin Massa
Merlin,the .net 'way' of database application development is to keep all the logic in the .net middleware.  please note that I am completelyopposed to this because it obfuscates good data management practices.are you serious and well informed about this? There is really again somebody throwing away

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-12 Thread Merlin Moncure
On 8/12/06, Jaime Casanova <[EMAIL PROTECTED]> wrote: > well, since he wrote his app in vb.net he is probably using postgresql > as a dumb data store, it might not be all that difficult. still, not a > very smart move. so if you have functions on server side or triggers or rules... then you need

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-12 Thread Jaime Casanova
well, since he wrote his app in vb.net he is probably using postgresql as a dumb data store, it might not be all that difficult. still, not a very smart move. so if you have functions on server side or triggers or rules... then you need some rewrite on the app... otherwise just to adapt the sql

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-12 Thread Merlin Moncure
On 8/12/06, Bill Moran <[EMAIL PROTECTED]> wrote: RPK <[EMAIL PROTECTED]> wrote: > > How can I migrate a PostgreSQL database to MySQL or MS Access? in your case i would suggest ms dts or vb script in conjunction with the odbc driver for both databases. You can't. Neither MySQL nor Access su

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-12 Thread Bill Moran
RPK <[EMAIL PROTECTED]> wrote: > > How can I migrate a PostgreSQL database to MySQL or MS Access? You can't. Neither MySQL nor Access support the advanced features in PostgreSQL. You'll probably have to rewrite the app. -- Bill Moran Microsoft: Where do you want to go today? Linux: Where do

[GENERAL] Migrating PostgreSQL database to MySQL/MS Access

2006-08-12 Thread RPK
How can I migrate a PostgreSQL database to MySQL or MS Access? Are there any tools available? -- View this message in context: http://www.nabble.com/Migrating-PostgreSQL-database-to-MySQL-MS-Access-tf2095559.html#a5776442 Sent from the PostgreSQL - general forum at Nabble.com.