This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » Coffee & Tea TalkZone » Project Dilema

Project Dilema
Andy None Member Since: 30 Apr 2009 Posts: 17	Posted 21 Oct 2009 12:34:21 My background - Classic ASP developer using DW 8 (can up upgrade to CS4), Access Database. Ok, i have the task of re-designing/developing our existing e-commerce website. The site is doing very well, but at some point it's going to need a revamp. It needs a new look (web 2.0 style) and a new, more robust database. My first thoughts were to use MySQL (cus it's free) and i have already migrated all the tables from Access to MySQL. I realsise i need to work out how the Access DB Queries migrate over to MySQL and that some data types vary a little, so there still some work to do. My dilema is, do i continue with MySQL and iron out all the issues along the way or do i go for MS SQL instead. I have no experience with either DB really and i'm wondering which is going to prove the least troublesome in the long run. Now for the programming languase. Do i stick with what i know? (Classic ASP) or do i get to grips with .net, php, Coldfusion? I don't have any issue with staying with classic ASP, so long as the migration and the end result is robust. Decisions, decisions...... I'd appreciate you're thoughts and your own experiences. Thanks in advance Andy My background - Classic ASP developer using DW 8 (can up upgrade to CS4), Access Database. Ok, i have the task of re-designing/developing our existing e-commerce website. The site is doing very well, but at some point it's going to need a revamp. It needs a new look (web 2.0 style) and a new, more robust database. My first thoughts were to use MySQL (cus it's free) and i have already migrated all the tables from Access to MySQL. I realsise i need to work out how the Access DB Queries migrate over to MySQL and that some data types vary a little, so there still some work to do. My dilema is, do i continue with MySQL and iron out all the issues along the way or do i go for MS SQL instead. I have no experience with either DB really and i'm wondering which is going to prove the least troublesome in the long run. Now for the programming languase. Do i stick with what i know? (Classic ASP) or do i get to grips with .net, php, Coldfusion? I don't have any issue with staying with classic ASP, so long as the migration and the end result is robust. Decisions, decisions...... I'd appreciate you're thoughts and your own experiences. Thanks in advance Andy

Project Dilema

Andy None
Member

Since: 30 Apr 2009
Posts: 17

Posted 21 Oct 2009 12:34:21

My background - Classic ASP developer using DW 8 (can up upgrade to CS4), Access Database.
Ok, i have the task of re-designing/developing our existing e-commerce website. The site is doing very well, but at some point it's going to need a revamp. It needs a new look (web 2.0 style) and a new, more robust database.
My first thoughts were to use MySQL (cus it's free) and i have already migrated all the tables from Access to MySQL. I realsise i need to work out how the Access DB Queries migrate over to MySQL and that some data types vary a little, so there still some work to do.
My dilema is, do i continue with MySQL and iron out all the issues along the way or do i go for MS SQL instead. I have no experience with either DB really and i'm wondering which is going to prove the least troublesome in the long run.
Now for the programming languase. Do i stick with what i know? (Classic ASP) or do i get to grips with .net, php, Coldfusion?
I don't have any issue with staying with classic ASP, so long as the migration and the end result is robust.
Decisions, decisions......
I'd appreciate you're thoughts and your own experiences.
Thanks in advance
Andy

My background - Classic ASP developer using DW 8 (can up upgrade to CS4), Access Database.
Ok, i have the task of re-designing/developing our existing e-commerce website. The site is doing very well, but at some point it's going to need a revamp. It needs a new look (web 2.0 style) and a new, more robust database.
My first thoughts were to use MySQL (cus it's free) and i have already migrated all the tables from Access to MySQL. I realsise i need to work out how the Access DB Queries migrate over to MySQL and that some data types vary a little, so there still some work to do.
My dilema is, do i continue with MySQL and iron out all the issues along the way or do i go for MS SQL instead. I have no experience with either DB really and i'm wondering which is going to prove the least troublesome in the long run.
Now for the programming languase. Do i stick with what i know? (Classic ASP) or do i get to grips with .net, php, Coldfusion?
I don't have any issue with staying with classic ASP, so long as the migration and the end result is robust.
Decisions, decisions......
I'd appreciate you're thoughts and your own experiences.
Thanks in advance
Andy

Patrick Julicher Official Representative Since: 04 Feb 2002 Posts: 1,208	Replied 21 Oct 2009 16:31:36 Hi Andy, I recently was going through the same! For the database part I decided to swith from MS Access to MS SQL, because it is very similar to Access, easy to maintain, especially with the SQL Server Management Studio. About the programming language. I think it is wise to learn another language besides Classic ASP. I tried ASP.NET but I found it hard to learn. PHP is easier to understand, coming from Classic ASP. CF is outdated so I would not advice that. I still think ASP.NET is something to learn! Kind regards, Patrick

Andy None Member Since: 30 Apr 2009 Posts: 17	Replied 26 Oct 2009 12:47:29 Thanks Patrick Yes i think you're right about .net I've dipped my toe in but didn't really get stuck in to it. Then Dreamweaver stopped supporting it which made me think that it may not be the way forward. However, it is a language that is being used more and more so maybe i should put more effort in. As you say, PHP may be the way forward as, again, it's becoming more common. I'm going to take a good look at both MySQl and MS SQL. I'm guessing you only find out which is most suitable when you get your hands dirty. Any other suggestions very welcome. Regards Andy

Patrick Julicher Official Representative Since: 04 Feb 2002 Posts: 1,208	Replied 26 Oct 2009 15:54:44 Hi Andy, Good luck on your decision which way to go. Kind regards, Patrick