Page 1 of 1

Use my Base Front End with SQL as database

Posted: Mon Apr 07, 2014 4:01 pm
by jcmckeon
Hello All, I have a Base db with a nice front end that works great. I now want to use this same front end but instead of using Base as the db I want to use SQL, can I??? Can I easily migrate the data from Base into a new SQL table?

I'm not great with SQL so any and all help is most appreciated...

Best Jill

Re: Use my Base Front End with SQL as database

Posted: Mon Apr 07, 2014 7:06 pm
by Villeroy
There is no such thing as a Base db and SQL is not a type of database.
I think you have an "embedded HSQLDB" which is indicated in the status bar of your Base document. This means your database is a HyperSQL (aka HSQL) database which is wrapped in the Base document, extracted when you open the document and repackaged when you close the containing document.
HSQL, H2, PostgreSQL, MySQL and dozends of other databases can be created, managed and controlled by means of the SQL language. SQL is not a database. It is the universal language to control them all. Yes, I think there are ways to connect your front end (queries, forms and reports) to some other type of database.

Re: Use my Base Front End with SQL as database

Posted: Thu Apr 10, 2014 4:38 am
by jcmckeon
Thank you for taking the time to respond.

Re: Use my Base Front End with SQL as database

Posted: Thu Apr 10, 2014 6:05 am
by DACM
Jill,

You've been around these forums for some time, and know your way around the Base Query Builder. If you're now ready to utilize SQL directly, simply switch to 'SQL view' in the Query Builder, or open the Tools > SQL console in Base. LibreOffice 4.x uniquely offers to display query results within the Tools > SQL console window. Or proceed to 'split' your 'embedded' database so you can utilize a more advanced database manager. Most of these managers are free, but RazorSQL is particularly nice if you can justify the ($100) price tag.
...

Re: Use my Base Front End with SQL as database

Posted: Thu Apr 10, 2014 4:32 pm
by jcmckeon
This is a great respond. Thank you so much...