migrating MS Access to MySql Server

[san_quentin76]

I'm an end user primarily and I need to know how to configure or export
Access tables and all of its other objects to a MySql Server so it can run
faster. Currently the Access databases are becoming too large and cumbersome
dramatically affecting processing time.

My general question is what are the necessary step in putting Access onto a
MySql Server?

Regards,

 

[a a r o n . k e m p f]

why mySQL?

Move it to MS SQL Server first

SQL Server is free-- Access database sucks.
Use the free tools and free db server -- it's called SQL Server, the
most popular database engine in the world.

-Aaron

 

[Larry Linson]

why mySQL?
Move it to MS SQL Server first
SQL Server is free-- Access database sucks.

I am sure Mr. Kempf would not want to mislead anyone: SQL Server _Express_
can be downloaded for free. SQL Server Express is a limited edition of SQL
Server, lacking many of the very real features of the full product, which
features Mr. Kempf often recommends.

Access databases do not "suck". MDB, MDE, ACCDB, and ACCDE databases are
appropriate and useful and satisfy requirements for many databases.

Use the free tools and free db server -- it's called SQL
Server, the most popular database engine in the world.

The Jet database engine (aka, Access database, the one Mr. Kempf thinks
"sucks") has been distributed with every copy of Windows for many years --
it's possible that there may be another candidate for "most popular database
engine in the world", but MS SQL Server doesn't even come _close_.

Larry Linson
Microsoft Office Access MVP

 

[a a r o n _ k e m p f]

re:
I am sure Mr. Kempf would not want to mislead anyone: SQL Server
_Express_
can be downloaded for free. SQL Server Express is a limited edition of
SQL
Server, lacking many of the very real features of the full product,
which
features Mr. Kempf often recommends.

Name one?

SQL Server Express has _ALL_ the features that 90% of the people need.
It has a great interface- SQL Server Management Studio Express Edition

and it is much faster - across the board- than your stupid Access
crapware.

Stick a fork in it, old man-- your so called database has been
obsolete for a decade.

 

[a a r o n _ k e m p f]

www.microsoft.com/sql

Microsoft SQL Server 2005 is a comprehensive, integrated data
management and analysis software that enables organizations to
reliably manage mission-critical information and confidently run
today’s increasingly complex business applications. SQL Server 2005
allows companies to gain greater insight from their business
information and achieve faster results for a competitive advantage.

SQL Server 2005 is the Data Platform leader:
•

Microsoft is positioned in Leaders Quadrant for Magic Quadrant for
Business Intelligence Platforms, 2008
•

Microsoft is positioned in Leaders Quadrant for Magic Quadrant for
Data Warehouse Database Management Systems, 2007
•

SQL Server is the fastest growing Database and Business Intelligence
vendor
•

SQL Server ships more units than Oracle and IBM combined
•

SQL Server is the #1 OLAP Server on the market
•

SQL Server is more secure than Oracle. Since July 2003 more than 100
critical Oracle database security vulnerabilities have been
identified, compared to ZERO for SQL Server for that period.
•

SQL Server is best in price/performance for TPC-H 1TB & 3TB (non-
clustered).
•

Microsoft SQL Server and Unisys are the first to publish TPC-E
benchmark results.
•

Gartner 2006 worldwide RDBMS market share reports highest growth rate
in market share for Microsoft SQL Server. With 28% growth in market
share, growth is almost twice the nearest competitor at 14.8% growth.
•

SQL Server still number 1 in databases. 74.7 percent of enterprises
are using SQL Server, while 54.5 percent are using Oracle databases.
•

SQL Server Manages the World's Largest Databases.
•

Microsoft SQL Server recognized as Best Seller and Top Growth Best
Seller by CRN Magazine.
Key Capabilities:
•

High Availability: Ensure business continuity with the highest levels
of system availability through technologies that protect your data
against costly human errors and minimize disaster recovery downtime.
Learn More
•

Performance and Scalability: Deliver an infrastructure that can grow
with your business and has a proven record in handling today's large
amounts of data and most critical enterprise workloads.
Learn More
•

Security: Provide a secure environment to address privacy and
compliance requirements with built-in features that protect your data
against unauthorized access.
Learn More
•

Manageability: Manage your infrastructure with automated diagnostics,
tuning, and configuration to reduce operational costs while reducing
maintenance and easily managing very large amounts of data.
Learn More
•

Developer Productivity: Build and deploy critical business-ready
applications more quickly by improving developer productivity and
reducing project life cycle times.
Learn More
•

Business Intelligence: Gain deeper insight into your business with
integrated, comprehensive analysis and reporting for enhanced decision
making.
Learn More

 

[a a r o n _ k e m p f]

and for the record, MS Access is _NOT_ included with Windows.

Maybe if the Access Runtime was available via Windows Update (as an
optional component) then maybe it would come close to SQL Server.
but SQL Server is everywhere.

NTFS is being replaced by SQL Server, retard

 

[BruceM]

Larry knows that Access is not included withWindows. He seems to have made
a misstatement, no doubt in part because he had become weary of having to
argue with a bitter and illogical troll.

If by NTFS you mean NT File System, then the statement:
"NTFS is being replaced by SQL Server"
is nonsensical even for you.

and for the record, MS Access is _NOT_ included with Windows.

Maybe if the Access Runtime was available via Windows Update (as an
optional component) then maybe it would come close to SQL Server.
but SQL Server is everywhere.

NTFS is being replaced by SQL Server, retard

 

[Larry Kahm]

This is probably not the appropriate forum for a discussion of how to
migrate from Access to another vendor's database plaform, but your best bet
is to use Google and view the countless articles and products.

Next, you might want to view the MySQL web site to see what they have to
offer.

Larry

Note to Aaron: MySQL Server is free...

 

[David W. Fenton]

SQL Server _Express_
can be downloaded for free. SQL Server Express is a limited
edition of SQL Server, lacking many of the very real features of
the full product, which features Mr. Kempf often recommends.

It *is* more full-featured that MySQL, so the fact that it is free,
too, makes it more than competitive, in my opinion.

 

[David W. Fenton]

m:

and for the record, MS Access is _NOT_ included with Windows.

True, indeed. But why are you stating this? Larry never claimed
anything different -- he said that *Jet* was included in Windows,
which is indisputably true, and has been since 1999 (i.e., from the
release of Win2K on).

*You* are the one who makes a habit of purposefully obfuscating the
difference between Access and its Jet database engine.

[]

NTFS is being replaced by SQL Server, retard

You mean the WinFS? That is long dead -- it was planned for the
version of Windows that was abandoned about 4 years ago in favor of
a new version of Windows based on the Win2K3 server codebase (which
was itself based on the WinXP codebase).

 

[a a r o n _ k e m p f]

WinFS-- Long dead.. Good Stuff-- Actually it's here ALREADY it's
called SQL Server Compact Edition
and SQL Server Data Services, for that matter.

Access doesn't have a history, a future-- a high end or a migration
path.
Move to SQL Server 2005 and things just work.

and for the record, MS Access is _NOT_ included with Windows.

True, indeed. But why are you stating this? Larry never claimed
anything different -- he said that *Jet* was included in Windows,
which is indisputably true, and has been since 1999 (i.e., from the
release of Win2K on).

*You* are the one who makes a habit of purposefully obfuscating the
difference between Access and its Jet database engine.

[]

NTFS is being replaced by SQL Server, retard

You mean the WinFS? That is long dead -- it was planned for the
version of Windows that was abandoned about 4 years ago in favor of
a new version of Windows based on the Win2K3 server codebase (which
was itself based on the WinXP codebase).

 

[a a r o n _ k e m p f]

is DAO included on Windows XP x64 edition?

which components of JET don't work on X64 editions of Windows?

and for the record, MS Access is _NOT_ included with Windows.

True, indeed. But why are you stating this? Larry never claimed
anything different -- he said that *Jet* was included in Windows,
which is indisputably true, and has been since 1999 (i.e., from the
release of Win2K on).

*You* are the one who makes a habit of purposefully obfuscating the
difference between Access and its Jet database engine.

[]

NTFS is being replaced by SQL Server, retard

You mean the WinFS? That is long dead -- it was planned for the
version of Windows that was abandoned about 4 years ago in favor of
a new version of Windows based on the Win2K3 server codebase (which
was itself based on the WinXP codebase).

 

[So Sorry For Poor Aaron]

SQL Server Express has _ALL_ the features that 90%
of the people need.

So you sayin' The Man, he right -- it don't have all the stuff of the full
product. Le's hear it for The Man!

Pull your head out, babykins. Big Bruce, Big Bubba, and Big Barney ain't
gonna want your empty head in their way, anyway.

Stick a fork in it, old man-- your so called
database has been obsolete for a decade.

Go tell that to all them folks out at Microsoft. They need a smart feller
like you to splain it, cuz they sure done waste lotta work on four new
versions in that decade. Maybe they give you a percentage of what you save
'em? But maybe they run you sorry ass off again?

 

[So Sorry For Poor Aaron]

is DAO included on Windows XP x64 edition?
which components of JET don't work on X64 editions of Windows?

Oh, him so smart, he think. He head be where sun don shine.

 

[Larry Linson]

It *is* more full-featured that MySQL, so the fact
that it is free, too, makes it more than competitive,
in my opinion.

I only drew the distinction between the free MS SQL Server product from
which Mr. Kempf omitted the "Express" part of the name and the full MS SQL
Server product, so others would not be misled.

His other assertions here fail any test for merit, especially his claim that
"It (SQL Server Express) has a great interface- SQL Server Management Studio
Express Edition." implying that "interface" is in competition with Access.
The "Management Studio" is, as its name implies, for managing your SQL
Server and it is very good for what it is intended to do; it most definitely
does not have the ability to create database applications for users.

Larry Linson
Microsoft Office Access MVP

 

[Larry Linson]

Larry knows that Access is not included withWindows.

No, of course Access is not part of the Windows distribution. I tried to be
quite clear that the _Jet database engine_ is included with Windows.

He seems to have made a misstatement, no doubt in
part because he had become weary of having to
argue with a bitter and illogical troll.

No misstatement. I do not engage in debate or argument with Mr. Kempf, and
generally do not even comment on his posts unless it is necessary to keep
him from misleading some new users of Access or of the newsgroup-- and
that's what I was doing.

And, as I said, the Jet database engine has been included with Windows for
many years.

 

[David W. Fenton]

m:

is DAO included on Windows XP x64 edition?

No, and it's not included in regular Windows, either. DAO != Jet --
they are completely independent, and Jet is included with Windows by
default and DAO is not.

which components of JET don't work on X64 editions of Windows?

You're the one making the argument here, so *you* tell *us* what
parts of Jet don't work.

 

[a a r o n _ k e m p f]

what.. SQL Server Express doesn't have Analysis Services. and SQL
Agent.
If you need SQL Agent, run MSDE 2.0

It''s still a 100 times better database _ENGINE_ than coasting down
the information highway _WITHOUT_AN_ENGINE_.

 

[a a r o n _ k e m p f]

name one feature that they put into MDB that they didn't put into ADP

seriously-- go ahead, stalker

 

[a a r o n _ k e m p f]

Dude you're such a fucking retard

it's the same product
100% compatabile.

SQL Server has been free for a decade.
Any dipshit stupid enough to be using JET in this day and age-- should
be fired and then spit upon