Solved

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

Posted on 2007-03-20
3
348 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

839 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