Access migration to mySQL or SQL?

D

diegoarbe

Group.

Have a probelm.
I have a database which is holding at 1.5Gb right now, Access can
still handle it.
This was a prototype which is holding 10% of existing data.

Normally I would migrate directly to SQL, but costwise it may not be
an option in a very long term, therefore I need an internediate
solution.

I normally start in Access and jump to SQL, is there anything else in
between?
I can continue using access as my frontend, but I need a database to
store 15Gb of data.

I've heard about mySQL, but never used it, would that be an option?
any ideas?

Thank you!

Diego
 
L

Larry Linson

diegoarbe said:
Probelm: database holding 1.5Gb now . . .
it is a prototype and 1.5GB is 10% of existing data.
I've heard about mySQL, but never used it, would
that be an option?

I've heard somewhat better opinions about PostgreSQL, if you are looking for
an Open Source database. But, MySQL seems to have overcome many of the
objections that people raised a few years ago. There are other Open Source
DBs, too, that I know even less about, and (CAVEAT) I have not personally
used either of these, so don't take this as a recommendation of either.

Some have reported being happy with both of these, by the way.

Larry Linson
Microsoft Access MVP
 
D

dbahooker

SQL Server 2000 MSDE.. once that conversion is done then move it to
SQL Server 2005.

Use SQL Server 2000 for development purposes; ADP works like a charm

a rewrite using ODBC is MORE DIFFICULT then using ADP
 
D

dbahooker

on the other hand, mySql is a _LOT_ more popular.

mySql has a frontend called PhpMyAdmin and it totally rocks
 
D

diegoarbe

Thank you all for your responses.

In the long run (1 year from now) we WILL work in SQL Server
Enterprise, the server has been requested and we are just in the long
waiting process. So this is a short term solution (for this first
year).

Knowing this, I will go on with the SQL Server 2005 Express, I didn't
know it was available. As they are both part of the same family of
products, I am certain that migrating from the Express to Enterprise
must be quite simple.

if I were to go on with MySQL, and developed with it's frontend tool,
would it be too hard to move later to SQL Server?

Thank you!

Diego
 
D

diegoarbe

Larry:
* Open Source programs are not approved in the company, so I cant
consider PostgreSQL, mySQL on the other hand has been used before and
I know it will be approved.

MH
* I am downloading SQL Server 2005 Express and will give it a try.

dbahooker:
* You talk about the front end for MySQL, can I make graphs and
reports or something similar? This is a functionality of SQL Server
does have.

Thank you

Diego
 
L

Larry Linson

diegoarbe said:
dbahooker:
* You talk about the front end for MySQL, can I make graphs and
reports or something similar? This is a functionality of SQL Server
does have.

"dbahooker" is a a r o n k e m p f, who frequently trolls these newsgroups
and often posts false information. Verify what he's posted before getting
"excited" about it; I don't recall hearing of a MySQL feature of this kind.

Larry Linson
Microsoft Access MVP
 
D

David W. Fenton

I've heard somewhat better opinions about PostgreSQL, if you are
looking for an Open Source database. But, MySQL seems to have
overcome many of the objections that people raised a few years
ago.

Not well, though. For instance, you can have full-text indexing or
you can have referential integrity, but not both.

Also, Access can't link to MySQL tables with full-text indexing.
 
L

Larry Linson

David W. Fenton said:
Not well, though. For instance, you can have full-text indexing or
you can have referential integrity, but not both.

Also, Access can't link to MySQL tables with full-text indexing.

Those limitations would surely be drawbacks. Maybe that's why I've heard
better reports from people using PostgreSQL. (There are a lot of web hosts,
though, who only provide MySQL. But this question wasn't about using them
on the web.)

Larry
 
D

David W. Fenton

Those limitations would surely be drawbacks. Maybe that's why
I've heard better reports from people using PostgreSQL. (There
are a lot of web hosts, though, who only provide MySQL. But this
question wasn't about using them on the web.)

The reason I know about MySQL is because my own website and that of
one of my clients uses it. It's fine for website databases,
especially ones that are heavily read-biased. But I wouldn't use it
for the data store for the apps my clients use on a regular basis.
 
D

dbahooker

David;

do you actually know what full text search is?

I thought that you were a MDB newbie dipshit


-Aaron
 
D

dbahooker

yes.. moving from mySql to SQL Server is a lot of work

move to Access Data Projects, develop in SQL 2000.. and then use SQL
2005 Express for production.

it's a great combination!

and it's all free.

SQL Server 2000 _FREE_ = MSDE 2.0 (download it via Sp4 link)
SQL Server 2005 _FREE_ = SQL Server Express 2005


Access Data Projects are a great cheap way to do this.

Moving from MDB to mySql and then SQL Server is just a waste of time.




-Aaron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top