Hi, today my boss told me he has a costumer wich uses a db made with Coldfusion(or he understood that way), and the costumer wanted to pass the db to mysql.
My question is: Coldfusion works with db, and if so, how can I pass the coldfusion db to mysql?
thanks
Alvaro
from Coldfusion to mysql
Moderator: General Moderators
Yeah you might need to clarify the following:
(a) What language the customer's script is written in
(b) What database system the customer's script uses to store information
But to answer your questions, CF does have db support, and I'm sure it works with most RDBMS (relational database management system) out there so MySQL is a also one of those so it shouldn't be too difficult to take the raw data from the old format to MySQL.
(a) What language the customer's script is written in
(b) What database system the customer's script uses to store information
But to answer your questions, CF does have db support, and I'm sure it works with most RDBMS (relational database management system) out there so MySQL is a also one of those so it shouldn't be too difficult to take the raw data from the old format to MySQL.
-
ratamaster
- Forum Newbie
- Posts: 23
- Joined: Fri Oct 15, 2004 6:36 am
Using PHP as a middleman here, you can extract the MSSQL data using PHP's MSSQL functions ( http://www.php.net/mssql ), and insert it into MySQL with PHP's MySQL capabilities ( http://www.php.net/mysql ).
( MSSQL ) -- data gathering --> ( PHP ) -- data inserting --> ( MySQL )
You'd need to mimmic the table structures and such within a MySQL database editing tool such as phpMyAdmin though.
( MSSQL ) -- data gathering --> ( PHP ) -- data inserting --> ( MySQL )
You'd need to mimmic the table structures and such within a MySQL database editing tool such as phpMyAdmin though.
-
ratamaster
- Forum Newbie
- Posts: 23
- Joined: Fri Oct 15, 2004 6:36 am
Yeah.
(I'm not very experienced with MSSQL but there is a lot of detail in the manual page and user comments within the function pages. )
Sami wrote:extract the MSSQL data using PHP's MSSQL functions ( http://www.php.net/mssql )
(I'm not very experienced with MSSQL but there is a lot of detail in the manual page and user comments within the function pages. )