Solved

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
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…
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…
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…

919 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now