[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2007-03-20
3
Medium Priority
?
384 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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

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…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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

649 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