?
Solved

PHP/MYSQL software port to??? VB.NET? Visual Basic? C#?

Posted on 2007-03-20
3
Medium Priority
?
374 Views
Last Modified: 2013-11-07
Hello,

Basically I am looking for some basic advice as I am about to undertake a project and need a little guidance.

I am looking to create a back office system thats suitable for my company (a group of mortgage brokers). At the moment I have implemented a full sales process and compliance system on a PHP/MYSQL platform and whilst this works well I feel I have a really good product which is very marketable to other companies that are similar.  Therefire I have decided to port my web based system to a client/server model on the Visual Basic? VB.NET? platform.

I am really looking for some advice on what is the best language to do this project on?
What database system should I use? SQL Server? Can I directly move my MYSQL database to SQL server?

Also what software will I need to develop this software? For VB and VB.NET etc i presume most people would recommend Visual Studio 2005? But do i need Standard or Professional? What are the differences between the two?

And what does a SQL server development license enable you to do? Presumably I will want to include any database software I use within an installation package that I will deploy to many companies? How much do i have to pay for database licensing in this case?

Finally, what PC should I be developing this on? Vista? XP? And also what harware will I need to run the development software effortlessly?

Many thanks,
AR
0
Comment
Question by:drews1f
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 18

Accepted Solution

by:
DarrenD earned 2000 total points
ID: 18770162
Hi,

Your asking quite a lot of questions here and the answers are not straight forward as you might think.

As far as porting all you code to .NET and the database to SQL Server. There are a few different ways you can go about this.

1: You could look at your PHP components and create web services for them using PHP. As far as I am aware this way you can connect to the web services from .NET and not have to redevelop them. This basically means that you can create a front end in PHP, ASP.NET, VB.NET, C# or any other language. You could also keep the MySQL database on the backend and not have to worry about porting it.

2: Port all of you code to the .NET platform and create the database on SQL Server.

Q: I am really looking for some advice on what is the best language to do this project on?
A: You should probably use C# for the simple fact that it's very similar to PHP which  is similar in Syntax to C.

Q: What database system should I use? SQL Server? Can I directly move my MYSQL database to SQL server?
A: I'd keep the MySQL database but if your clients don't want to use more than one database then this can be ported to SQL Server. You'd either have to create the scripts for the database schema or import it somehow. I'm not 100% on the exact details but it can be done.

Q: Also what software will I need to develop this software? For VB and VB.NET etc i presume most people would recommend Visual Studio 2005? But do i need Standard or Professional? What are the differences between the two?
A: I'm not 100%. You should look this up on the MS web site or do a search, here's one I found http://mcmanus.typepad.com/grind/2005/10/which_edition_o.html

Q: And what does a SQL server development license enable you to do? Presumably I will want to include any database software I use within an installation package that I will deploy to many companies? How much do i have to pay for database licensing in this case?
A: Develop applications. You can get a free version of SQL Server here:
http://www.microsoft.com/sql/editions/express/default.mspx

Q: Finally, what PC should I be developing this on? Vista? XP? And also what harware will I need to run the development software effortlessly?
A: Doesn't really matter. Probably XP as it 's what most organisations are using and they wont be upgrading to Vista that quickly. It'll take a while to get in everywhere.

Well I hope this helps you in some ways: Let me know how you get on.

Darren




0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month8 days, 1 hour left to enroll

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question