Page 1 of 1

from Coldfusion to mysql

Posted: Fri Nov 05, 2004 1:05 pm
by ratamaster
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

Posted: Sat Nov 06, 2004 1:45 pm
by Weirdan
From what I know Coldfusion is a server side scripting language/platform, not a db server.

Posted: Sat Nov 06, 2004 11:48 pm
by m3mn0n
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.

Posted: Mon Nov 08, 2004 6:04 am
by ratamaster
Hi
They use Microsoft SQL Server 2000 as db software
What you mean custumer's script written? I mean, they use SQL but I don“t know wich language they use to desplay the data on their web.
I hope this is enogh information.

Alvaro

Posted: Mon Nov 08, 2004 11:27 am
by m3mn0n
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.

Posted: Mon Nov 08, 2004 11:49 am
by ratamaster
OK, I work with php and mysql, and I know the functions, but I never take a db bilt in Microsoft SQL Server 2000, and move the structure and data to mysql db
Have you any idea how can I achieve this.

thanks
Alvaro

Posted: Mon Nov 08, 2004 12:12 pm
by m3mn0n
Yeah.
Sami wrote:extract the MSSQL data using PHP's MSSQL functions ( http://www.php.net/mssql )
:wink:

(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. ) :)

Posted: Mon Nov 08, 2004 12:14 pm
by ratamaster
thanks!!!