Tuesday, March 4, 2014

Converting a Desktop App to the Cloud

In the past I have mentioned a tool we have created for converting Access to nuBuilder.

One of the main dificulties with an Access DB is that you can call your field names nearly anything but you can't do that with a field in the Browser.

Not only are there certain HTML rules that need to be followed, HTML is also case sensative.

Here's what was created from an Access Wizard.

It has forward slashes, spaces and hyphens. Things that don't live nicely on a web page as names or ids.
But run it through this tool.

And you will get the SQL required to build a mySQL Table like this.

That's the first step in the convertion process.

You can find that tool here. https://www.nubuilder.net/A2N.zip