Database software

[snafu]

Have had tremendous results with the following setup

Under 500K records, MSAccess running on local machines.

Over 500K records, MSSQL running off of a relatively cheap server (or running on a really powerful shared machine). Have easily run 20 gig databases with 20-30 million premium records in a single table and 10 million related loss records.

The hardest part about using MSSQL is getting the large quantities of data into the database. Recommend some research on this item before hand as it can be tricky.

[IMHO]

Originally Posted by snafu

The hardest part about using MSSQL is getting the large quantities of data into the database. Recommend some research on this item before hand as it can be tricky.

That's why I would recommend MSSQL Server. It has the best instruments for upload/data manipulation. There is nothing tricky in DBF files upload.
And I have never heard it is expensive. Talking about security issues with people who are happy with FoxPro is a joke itself.

[wtt]

Originally Posted by IMHO

That's why I would recommend MSSQL Server. It has the best instruments for upload/data manipulation. There is nothing tricky in DBF files upload.
And I have never heard it is expensive. Talking about security issues with people who are happy with FoxPro is a joke itself.

MySQL is good. It is not only free, it also has the web admin interface developed by other people.

[vchagas]

If there is budget, I would recomend SAS. It does everything a DBMS do (for actuarial purposes) and much more.

Like many others I followed the Microsoft PATH
ACCESS -> FOX PRO -> SQL SERVER

But eventually ended up with the following configuration:
SAS 9.1 Analytics Server + SAS/ACCESS for ODBC + Enterprise Guide 4.1

No more size limits (except disk capacity), no more needs to compact the databases and endless logs.

[MillyT]

Hello, does anyone know about some of the advantages and disadvantages of moving a mysql system to the cloud using cloud database solutions (such as this one), any known pitfalls to be aware of, and how do I know that it's time to move to a cloud based solution, or on the contrary that a system isn't fit for cloud environment.
Any thought will be appreciated,

Thanks,
Milly.

[ADoubleDot]

Originally Posted by Polly Nomial

In FoxPro we have it set up so that the data files reside on a separate server, but any data handling is done on our C drive. (probably explains why we have 37 gig hard drives) I assume you are talking about not using the C drive for this purpose. Is this a setup issue or is it the way the software works?



I don't understand "µserf ." Is that a typo or just a term I don't know?


It's the Evil Empire of Redmond!

Was 37 GB considered large in 2002? Seems odd.

[atfl]

Originally Posted by ADoubleDot

Was 37 GB considered large in 2002? Seems odd.

I think my largest MP3 back then was ~9MB. Biggest game install was 2 or 3GB. Now my smallest FLAC or game are of those sizes.

I could see how a 37GB database could be considered gigantic.

Heck I remember someone with a terabyte of total hard drive space in '02 was picked on for amassing a collection of pr0n of that size (no other reason one needed that much space).

[AndrewC]

There are a few things that you may want to consider:

- performance
- scalability
- manageability
- security
- extensibility

And today's enterprise grade database offers more than just data storage and access; they also provide features like reports, business intelligence, data migration, data mining, master data management. You don't often find these features from desktop database software such as Access and FoxPro.

If you're using FoxPro, I assume you are not just using its database feature, you may be using its development tool as well. Are you going to migrate the development part to something else as well?

[SpaceActuary]

This was a 9-year-old thread that got bumped...

Originally Posted by MillyT

Hello, does anyone know about some of the advantages and disadvantages of moving a mysql system to the cloud using cloud database solutions (such as this one), any known pitfalls to be aware of, and how do I know that it's time to move to a cloud based solution, or on the contrary that a system isn't fit for cloud environment.
Any thought will be appreciated,

Thanks,
Milly.

[AndrewC]

Originally Posted by MillyT

Hello, does anyone know about some of the advantages and disadvantages of moving a mysql system to the cloud using cloud database solutions (such as this one), any known pitfalls to be aware of, and how do I know that it's time to move to a cloud based solution, or on the contrary that a system isn't fit for cloud environment.
Any thought will be appreciated,

Thanks,
Milly.

Advantage and disadvantage are relative! Are you running mySQL on Linux or windows? What is your business continuity plan? What is your current application configuration? Windows application? Web application? ASP.Net? J2EE? Web Services?

You may also want to examine if there is any legal obligation or business requirements, e.g. you have to store the data in your own country.


It is difficult to make a recommendation without knowing the background.


But you may want to compare more than 1 cloud provider, e.g.

http://aws.amazon.com/ec2/
http://www.microsoft.com/windowsazure/

At least Apple choose both Amzon and Microsoft to be its iCloud provider.