/    Sign up×
Community /Pin to ProfileBookmark

cfm to php: clarification sought

Copy linkTweet thisAlerts:
May 04.2006

My company has been asked to redesign a website where the database is in coldfusion….however, the guy who does my backend (and is away on holiday at the moment) uses php. As one uses MS SQL and one uses MY SQL is it possible to convert one into the other, or should the new front end just be written using coldfusion??? The current database is about 110 MB.

Thanks in advance for any help.

J

to post a comment
PHP

9 Comments(s) ↴

Copy linkTweet thisAlerts:
@chazzyMay 04.2006 — convert what to what? cfm to php? needs to be done by hand.

ms sql to mysql? yes, there are numerous tools to do this. but you can connect php to mssql and to mysql, same w/ cfm.
Copy linkTweet thisAlerts:
@buggerlugsauthorMay 04.2006 — Thanks for the explanation - but being a bit of a thickit, I'm still not sure I understand....the website front and back ends are currently written in coldfusion - cfm....

My programmer uses php, and my understanding is that both use SQL; php uses My SQL and Coldfusion uses MSSQL - and then again maybe I just don't understand didly squat!!

We don't use coldfusion for front ends - but if it isn't easy to convert the info held in the database that is currently in cfm - it might be easier to do the front end in coldfusion! If that makes any sense....
Copy linkTweet thisAlerts:
@chazzyMay 04.2006 — Thanks for the explanation - but being a bit of a thickit, I'm still not sure I understand....the website front and back ends are currently written in coldfusion - cfm....[/quote]
ok fine

My programmer uses php, and my understanding is that both use SQL; php uses My SQL and Coldfusion uses MSSQL - and then again maybe I just don't understand didly squat!![/quote]
not true! cfm can connect to mysql and php can connect to mssql, there is no platform dependencies here.

We don't use coldfusion for front ends - but if it isn't easy to convert the info held in the database that is currently in cfm - it might be easier to do the front end in coldfusion! If that makes any sense....[/QUOTE]
it won't be, trust me. you can easily convert your database over. Mysql provides a [url="http://dev.mysql.com/downloads/migration-toolkit/1.0.html"]migration toolkit[/url] that does this kind of thing. you'll need to go through it and verify everything and made clean up some things, but all of your data can be brought over easily. i think you're a little confused though, the database has nothing to do with coldfusion, the database has nothing to do with php.
Copy linkTweet thisAlerts:
@buggerlugsauthorMay 04.2006 — Thanks Chazzy - you're a star...

It looks as though my programmer doesn't know what he's talking about as it was him who originally told me that php uses MySql etc. - maybe he means that he uses MySQL..a point I'll definitely need clarifying!

I will do some digging and have a look at the toolkit - might have to come back though and pick your brains some more.

Thanks again,

J
Copy linkTweet thisAlerts:
@NogDogMay 04.2006 — One question you may need to resolve is which languages and databases does the target web host support? If, perhaps, the objective is to move from a Windows host to a UNIX/Linux host that does not have ColdFusion installed, then you may in fact need to switch both the coding language and the database system. As Chazzy pointed out, there is no built-in restriction to either CF or PHP as to which database you use; but if you are changing web hosts, such limitations might be forced on you by what software is installed and available to you for use.
Copy linkTweet thisAlerts:
@chazzyMay 04.2006 — to be honest, if you have no requirement to leave mssql (other than the fact that your programmer doesn't know it) you might be better off keeping it. i've heard of a lot of places using cfm on windows environments, are you moving off of windows? if so then yes, ms sql won't work (it only runs on windows) but that doesn't mean you need to use mysql. for something small like what you have, why not use oracle express?
Copy linkTweet thisAlerts:
@buggerlugsauthorMay 05.2006 — Thanks guys - its definitely a whole new ball game when you start talking about the back ends of websites - as a design agency we normally only do small 5 -10 page sites in GoLive, and they are more about a web presence than e-commerce etc etc.. I thought 100mb was large!! See - told you I was a thickit!!

No decision has been made yet about whether to stay with the current server, or go for a Linux based one - anyone want to proffer an opinion about which is better - or is that a whole new thread ;0)

J
Copy linkTweet thisAlerts:
@chazzyMay 05.2006 — windows server 2003 was designed for the web. linux has its advantages (cheaper) but support can be a pain. both can handle java. both can handle php and CFM. all that we've been running at work has been windows 2003 w/ .net 1.1 but we might start deploying some windows/bea weblogic java servers, who knows; that's what my last company did too, and one of our sister divisions currently is using weblogic.

you might want to look into gartner research, they do all sorts of IT based research, and it's all 3rd party/objective information.
Copy linkTweet thisAlerts:
@buggerlugsauthorMay 05.2006 — Thanks Chazzy - I just might do that...in the morning...and then all I'll need is a programmer who can do what I want!!. Anyway its 1.49 am here and I'm off to my pit...

Night - and thanks again.

J
×

Success!

Help @buggerlugs spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.5,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,

tipper: @Samric24,
tipped: article
amount: 1000 SATS,
)...