IT Employment

Ask something
Discussion Locked

MySQL Deployment

0 helpful
5 replies

by michael34 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,
I work for a company who is wanting to move all the databases they have in Microsoft Access to Microsoft SQL Server. The problem we have is the previous people who worked here programmed the entire access database with GUI's and forums. My question is, does anyone know a good program we could implement which is easy to use and would allow us to customise the User interface (So we could design forums so our staff can enter data and view data in the mysql database using a GUI).

5 replies

by michael34

What we are looking for is a program we can use that will work with microsoftsql that will allow us to pull data and enter data through a user interface. Just like forum systems do as the company I am working for thinks going to sql will fix the problem but im not so sure it will .... From what I have seen is Mysql and Microsoft SQL are mainly web baised databases used with PHP but this company needs a program we can use to access the databases where they can enter data through a form and display data in a graphic user friendly enviroment.

by adagroup

Hi,
From what I can gather, a few sugesstions for you:
a) If your database connectivity is configurable, that is, the coders have not hardcoded the database credentials, you can shift to MSSQL without hassles. Of course you'd need to create the data tables/structures in MS SQL or use a utility like mySQL Migration Toolkit (http://dev.mysql.com/downloads/migration-toolkit/1.0.html) Then you change the connection string in the configuration file of the software developed by your (previous people)

b) Redesigning the forms/software is most often the best solution since it eliminates "unknown" issues. This could also be a cost-effective solution.

c) If you can install PHP/MySQL, You could use phpformgenerator (phpformgen.sourceforge.net). This will create forms for you to add fields to a database, quickly.

d) If you're familier with Linux, you can see this URL: http://linas.org/linux/db-rad.html

Hope it helps.

Regds
Inderjeet
www.inderjeetsodhi.com

by adagroup

Forgot to mention, in Access 2003, you can design forms that even connect to SQL databases..this should solve your problem mostly.

All the best!!

by prubyholl

i ges u talking abt VBA in access. am sure u will av 2 re-write a new web application-maybe asp.net, to run on ur local LAN.

well u can easily import or migrate ur access db to sql.

This discussion is closed to new replies.