Web interface for SQL Server database

I am working on desktop VB6 database programming, but now the client asks for a simple web interface (some inserts in SQL Server db used by the desktop application).

The question is, which approach is better?

1) creating an asp.net project directly linked to the SQL Server database;

2) creating a separate (simple) mysql database managed by php and sync (e.g. after 15 minutes)

Thank.

+2


source to share


3 answers


I would rather use a separate database approach.



  • It is more secure.

  • PHP / Mysql hosting is widespread

0


source


Personally, since you already have a SQL Server database, I see no reason to add complexity to another database and then sync. The first option is easier to create and can be safe if you design it correctly. The hosting issue is irrelevant since you are going to your own database that already exists, as is the cost issue as the database already exists. Also, since you already maintain SQL Server, you can reuse some code rather than write new code (mysql SQL version is not the same as SQl Server version). Synchronizing two databases can be more complicated than you think (different data types, etc.) and the data in a real database is not in real time, whereas with the first alternative it is.



+1


source


You can pretty much achieve anything with the technology available, it just depends on your skills and productivity with specific technologies and the availability of online help. Plus Microsoft, which you usually have to pay for, whereas PHP / MySQL is completely free.

0


source







All Articles