DB Access to DB Linux

DB Access to DB Linux

Post by evb » Wed, 12 Sep 2001 23:06:08



Hi !

I want to import an Access DB on Windows NT Server to a database system
running on Linux,
which database is the best on Linux and how I can do the import between the
two databases.

thanks

PS Sorry for my broken english, i'm french

 
 
 

DB Access to DB Linux

Post by timo rat » Thu, 13 Sep 2001 19:16:42


Quote:>I want to import an Access DB on Windows NT Server to a database system
>running on Linux,
>which database is the best on Linux and how I can do the import between the
>two databases.

Out of the free/open ones: PostgreSQL and MySQL in that order.
Postgres is - as far as I know - the more professional and heavy-weight
of the two, altough MySQL might have easier tools.

You can have Oracle running on your Linux as well.

regards,

timo

 
 
 

DB Access to DB Linux

Post by MM » Sat, 15 Sep 2001 01:55:53


Hello evb,
As far the choice of database goes, you have a wide range to pick. The only
database that I have not seen a Linux port is MS Access and MS SQL Server. If
this is a comercial app and you are willing to spend money, go with either
Oracle or IBM DB2. If you want something for free but not as robust and
scallable, go with PostgreSQL or MySQL.

As far as data migration goes, you can either use MS Access or WinSQL
(http://www.indus-soft.com/winsql). I personally like WinSQL as it has lots of
cool features.

Thanks,
MM.


> Hi !

> I want to import an Access DB on Windows NT Server to a database system
> running on Linux,
> which database is the best on Linux and how I can do the import between the
> two databases.

> thanks

> PS Sorry for my broken english, i'm french

 
 
 

1. Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB

I'm planning to create a VB application and am trying to figure out how
to best store the DB.  The DB tables can have as much as 500,000 records
in them and can be well over 100MB in size.

Which DB format will work best with VB.  I want the queries to run
quick.  Will storing the DB in Foxpro take advantage of FoxPro's
Rushmore technology.  What about an SQL Server?

Thanks

Sailesh

2. OLEDB Providers

3. Attaching Access Db files to Access DB

4. Profanity (Was:Re: Can I get Ingres WindowView to work under OpenWindows?)

5. Accessing both Access db and SQLServer db faster from VC++

6. Turning off headings and footings

7. Converting Access 2.0 DB to Access 97 DB in VB code

8. the freetds type 4 jdbc driver -- where do i find instructions for how to use it?

9. Convert Access 97 DB to Access 2002 DB

10. Linux user www-data has no access to amphora2 DB

11. C++ class library for accessing Oracle DB on unix/linux

12. MSSQLReporter to access db from Linux (perl)

13. Trying to INSERT info from Access DB using VB 6.0 to SQL 6.5 DB