Sorry, Leo I got sucked into some stuff.. you know how it is This is what thou need
https://github.com/jbennie/tbldefexport There are a few years of my assembled libraries etc in this upload and this is my first official publication of unique code. Whoop Whoop. You shouldn’t need visual studio for this … Its should work under mono 3.2.4 and Xamirin Studio out of the box unless I forgot something. Also this code can be the basis for a data migration tool… currently it's setup for my target and source DB’s. Joseph Bennie | Founder 07976 300036 | @Lincoreltd j...@lincore.com On 10 Dec 2013, at 22:11, Leo <li...@fractal.me.uk> wrote: > Thank you all. I'll take a look at yii and cakephp. > > Also, Joseph, are the scripts similar to those here: > http://stackoverflow.com/questions/698839/how-to-extract-the-schema-of-an-access-mdb-database > > Regards, > Leo > > On 03/12/13 09:43, Joseph Bennie wrote: >> >> database: >> >> I’ll push some simple vba scripts to git that will allow you to extract >> the table structures into mysql or Ms SQL DDL queries >> >> Once you have the data structures exported, you can use a trial version >> of DBcompare or a like tool to move the data from the old db to the >> mysql db … OR just use the access export to dump csv files. >> >> for the application layer/web layer… I’ve used cakephp many times to >> scaffold most of the basic functionality with its inbuilt commands, this >> also builds the models/controllers and default views. Cakephp is an >> established well tuned php MVC framework. >> >> you can then extend the scaffolded pages with custom functions and view >> models (MVVM) or ignore the scaffold and do your own thing. ( also you >> might want to add a javascript layer to the app … i.e. extending table >> functionality with jTable, or date pickers and other widgets with >> jqueryUI or wijimo. >> >> another neat trick with Cakephp is the ease of adding a REST API for the >> future when you needed to build a native mobile client. >> >> I’ve tried using a few of the other options out there but this has been >> the most successful and reliable overall… most of the other point and >> click options fail in some critical aspect or auto generate code hell. >> >> but let me know how you get on with the one below, its not one i have >> tried yet. >> >> >> Joseph Bennie | Founder >> 07976 300036 | @Lincoreltd >> j...@lincore.com <mailto:j...@lincore.com> >> >> On 3 Dec 2013, at 09:26, Paul Freeman <p...@noc4.net >> <mailto:p...@noc4.net>> wrote: >> >>> On 2013-12-02 23:19, Leo wrote: >>> >>>> I was thinking of porting a fairly simple [1] Access database to a LAMP >>>> stack with a few web pages to do various updates, searches etc. I was >>>> just wondering, before I start looking, if there's something I could use >>>> that would provide some of this functionality for me off the shelf. >>>> (E.g. maybe something out that would pre-create all the simple single >>>> table CRUD pages for me.) >>> >>> http://www.yiiframework.com/ is worth a look. it will run on a >>> standard LAMP stack. >>> >>> >>> -- >>> Please post to: Hampshire@mailman.lug.org.uk >>> <mailto:Hampshire@mailman.lug.org.uk> >>> Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire >>> LUG URL: http://www.hantslug.org.uk >>> -------------------------------------------------------------- >> >> >> > > > -- > Please post to: Hampshire@mailman.lug.org.uk > Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire > LUG URL: http://www.hantslug.org.uk > --------------------------------------------------------------
-- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --------------------------------------------------------------