Solved

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

Posted on 2007-03-20
3
353 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
3 Comments
 
LVL 18

Accepted Solution

by:
DarrenD earned 500 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

Independent Software Vendors: 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

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

756 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