Off Topic MYSQL.... Nu Build help needed

[The Omega Man]

Anyone who knows me will understand it when I say that I am as think as ****.

I have an abstract way of looking at things and numbers etc often get jumbled up when I use them.

I understand relational databases and have in the past built workable databases using a building tool. I stopped using it several years ago and to transfer my licences will cost £5k. The builder I used was Alpha5 and so I have been looking around for an alternative that is open source.

Look back at the first bit of this post...

I have decided to install MySQL and run a database builder Nu-Build.

I really need someone to help me at various stages of the build, simple stuff that relates more to the background and structures rather than the database itself.

I am trying to build a database for case and client management, with invoicing, remittance and financial reporting.

 

[Plum]

Anyone who knows me will understand it when I say that I am as think as ****.

I have an abstract way of looking at things and numbers etc often get jumbled up when I use them.

I understand relational databases and have in the past built workable databases using a building tool. I stopped using it several years ago and to transfer my licences will cost £5k. The builder I used was Alpha5 and so I have been looking around for an alternative that is open source.

Look back at the first bit of this post...

I have decided to install MySQL and run a database builder Nu-Build.

I really need someone to help me at various stages of the build, simple stuff that relates more to the background and structures rather than the database itself.

I am trying to build a database for case and client management, with invoicing, remittance and financial reporting.

That sounds like it could end up being a fairly complex database utilising stored procedures, reporting services and all sorts. Are you sure there isn't an off the shelf application that will do it all at a bearable cost? Most software seems to be available by monthly subscription these days so no upfront costs.

 

[The Omega Man]

That sounds like it could end up being a fairly complex database utilising stored procedures, reporting services and all sorts. Are you sure there isn't an off the shelf application that will do it all at a bearable cost? Most software seems to be available by monthly subscription these days so no upfront costs.

In 10 years of looking there isn't anything suitable. That's why I wrote my own before and it's the same now.

 

[AlRawdah]

Isn’t that what Quickbooks and Sage does?

 

[The Omega Man]

Isn’t that what Quickbooks and Sage does?

I am qualified in computerised accounts, I am actually a Sage reseller and we do the bookkeeping for 7 companies using Sage Client manager.
The difficulty for example is that I have to produce invoices for insolvent companies. I have 136 different companies on my system and that would cost me a fortune on any accounting program.

 

[Plum]

In 10 years of looking there isn't anything suitable. That's why I wrote my own before and it's the same now.

Shame, if I'd known this 10 years ago I could have sold you one!

 

[Frank Fingers]

I am qualified in computerised accounts, I am actually a Sage reseller and we do the bookkeeping for 7 companies using Sage Client manager.
The difficulty for example is that I have to produce invoices for insolvent companies. I have 136 different companies on my system and that would cost me a fortune on any accounting program.

I'm not sure what you mean by database builder?
Is it some sort of gui or is it a front end for a database?

If cost is an issue, just stick an Access front end on a MySQL or SQLExpress database? I currently use SSMS with SSRS or Power BI, but if I was after a front end to take input I'd prob build it in .Net.

 

[TigerMarv]

Isn’t that what Quickbooks and Sage does?

They're the past Xero is the future

 

[Gone For A Walk]

Kinell. Sounds like a load of expense, complexity, hassle, time, heartache, ........
I thought technology was supposed to make life easier?!!
Maybe just revert to pen and paper, and a simple spreadsheet?
Or get someone else to do it?
Life's too short.
[HASHTAG]#KISS[/HASHTAG]

 

[askewshair]

****, I've hit a translate button and can't find it now

 

[Mr Hatem]

I've hit a translate button and can't find it now

Ek het 'n vertaalknoppie getref en kan dit nie nou vind nie

 

[The Omega Man]

I'm not sure what you mean by database builder?
Is it some sort of gui or is it a front end for a database?

If cost is an issue, just stick an Access front end on a MySQL or SQLExpress database? I currently use SSMS with SSRS or Power BI, but if I was after a front end to take input I'd prob build it in .Net.

The builder I used before was like a very fast Access, but with everything

I'm not sure what you mean by database builder?
Is it some sort of gui or is it a front end for a database?

If cost is an issue, just stick an Access front end on a MySQL or SQLExpress database? I currently use SSMS with SSRS or Power BI, but if I was after a front end to take input I'd prob build it in .Net.

Thanks