moving ASP board to PHP
- Started
- Last post
- 12 Responses
- spl33nidoru0
sorry i'm taking forever to answer, been glued to the phone all day.
yep it perfectly makes sense, the PHP solution isn't already set up though and I don't know how to migrate databases o_O
would you want to take care of it ?
- jpea0
hah. funny. we had a project that originally started with a guy building it in PHP, thinking that we could just "convert" it to C# later on when it gets handed off to the client. asp != php. It could be somewhat simple if they share a similar database structure, but generally that's not the case.
- detritus0
My advice would be to move to another ASP server.
- ondo0
id move to another asp server too, or if thats not possible find a PHP programmer who works with MS SQL (assuming its MS SQL)
- flavorful0
Well ... this is a little more complicated than just moving from ASP to PHP. They are two different programming languages, usually dealing with two different databases (ASP = MSSQL; PHP = MySQL).
Now actually migrating data from MSSQL to MySQL is not terribly difficult if you are familiar with databases as they are quite similar. (They may have different logic in the Stored Procedures, and how your webs connect to the databases to pull information.)
ASP and PHP can get you the same end result, but the way they go about everything is pretty different.
This would not necessarily be a fun project to undertake in my eyes. The benefits to PHP/MySQL is that most hosting companies provide it, as it's cheap compared to ASP/MSSQL (as Microsoft charges servers by processesors, haha) - but in terms of how much it may cost to do this transition, it may not be worth it.
It's a simple idea in theory, when you are looking at it from an end-user perspective who does not deal in code, or databases - but it's quite a task for sure.
- detritus0
Has anyone asked 'why?' yet?
- flavorful0
I assumed he/she has no idea, and the actual person making the call has even less of an idea.
- spl33nidoru0
thanks for the answers.
why : the board was originally ASP and when the website was redesigned a first time (website for a band so redesigns are linked to album releases) the record company had also changed its hosting solutions.
the new website followed the new hosting and they kept the board where it was because nobody wanted to deal with the ASP ( and it was not supported by their current system).Now the band has left the label and don't want the website hosted with the label anymore, new redesign coming, and overall will to stop dragging the ASP board and go for an open source solution.
if it was just me i'd trash the old board but you know them fans.. they love their ranks and amount of posts..
- spl33nidoru0
ok so basically start fresh or keep the ASP board.. thanks all and for the explanations flavorful!
- detritus0
Does your choice of board come in ASP & PHP flavours? If not, you're potentially looking at quite an expensive bit of re-coding.
If it were me, unless unless I was changing and improving the mechanics of the board, I'd just heavily re-skin the blighter and finding an ASP host somewhere else. They're not that much more expensive, are they?
It'd probably help if you said what software you're running though, so some of the more knowledgable people here could chime in.
- flavorful0
My services could be rendered. :D
Also my fees will be two and half times the budget you have to do this, and if that does not meet my hourly rate given the time it takes to complete I will charge the hours overage times Pi to accommodate.
- flavorful0
Then basically what you want to do, is find out how the Open Source Board houses the data, and then simply migrate the Database Data from one Database to the other.
It will not be a one to one relationship, there may be some fields one has that the other doesn't. But if you are using a PHP Solution that is already set up, you don't have to bother with ASP/PHP and only need to bother with the actual data itself (not the languages that present the data).
- Let me know if that made sense, haha. I typed it, then walked away for awhile came back and just hit Broadcast.flavorful