from Coldfusion to mysql

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
ratamaster
Forum Newbie
Posts: 23
Joined: Fri Oct 15, 2004 6:36 am

from Coldfusion to mysql

Post 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
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post by Weirdan »

From what I know Coldfusion is a server side scripting language/platform, not a db server.
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post 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.
ratamaster
Forum Newbie
Posts: 23
Joined: Fri Oct 15, 2004 6:36 am

Post 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
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post 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.
ratamaster
Forum Newbie
Posts: 23
Joined: Fri Oct 15, 2004 6:36 am

Post 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
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post 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. ) :)
ratamaster
Forum Newbie
Posts: 23
Joined: Fri Oct 15, 2004 6:36 am

Post by ratamaster »

thanks!!!
Post Reply