On Fri, Feb 25, 2005 at 01:26:38PM +1100, Chad wrote: > I am still progressing down the path of finding an alternate host > (remember from way back?). I have found one that looks wonderful, CF 7 > and everything... but no SQL 2K. What is the pain in downgrading (?) > from SQL2K to MYSQL as a datasource? > > Please, make assumptions... I are not rocket scientust... or > consultant... I can take it...
You might want to check to see if they offer PostgreSQL (called Postgres) as an alternative. For sites that are read-lots, insert-rarely then MySQL's fine. But if you're doing a lot of transactional work then Postgres is much better. Regardless of which DB you end up with you'll have some problems. The major pain in moving databases is all the non-standard queries that creep into your code if you're not careful. Also stored procedures, and sometimes differences in data types. Another one is incrementing numbers/serials/counters (different DBs call them different names). There are GUI programs available for both MySQL and Postgres that allow you to manage the database. Quite a few of them will allow data migration. The general idea is that the tool opens an ODBC connection to (in this case) SQL2k and a JDBC connection to MySQL/Postgres. Then the tool just queryies all the records and INSERTs them. Cheers Paul Haddon Technical Services Manager Formstar Print Technologies --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
