| Author |
 Topic Search  Topic Options
|
zMaestro 
Senior Member
Joined: 11 May 2003
Location: Egypt
Status: Offline
Points: 1183
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: a 165 MB Access database
Posted: 29 December 2004 at 6:15pm |
I brought a database of a huge book I've to put online, it is an access (.mdb) database. I've a few questions (hope to find someone to answer them during the Christmas holidays  )
- It was an Access 97 database, when I converted to access 2000 its size was doubled!!! it was 85 MB on Access 97, and then it became 165 MB after converting to Access 2000 even after compacting and repairing it. Is this normal?
- Is it wise to use it as .mdb or I have to change to MsSQL, or I must change to MsSQL?
Thanks :)
|
 |
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 December 2004 at 9:21pm |
|
I'd change it to MSSQL
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 30 December 2004 at 6:16am |
|
Access 2000 databases are usually larger than 97 databases, but it is
worth changing as in my experience access 97 often becomes corrupted
when used as a web site backend.
If the database is not going to be opened very often and the server is
has enough speed and resources to load in a 165mb access database to
memory it should be OK.
If the database is to be accessed often, or on a shared hosting environment then you should look at using MS SQL Server or mySQL
|
|
|
|
dbob
Newbie
Joined: 04 January 2005
Location: United Kingdom
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 January 2005 at 10:54am |
Hello, I have downloaded the Search engine from Web Wiz. Its brilliamt, becuase now I have taken the first steps to knowing asp and mySQL databases.
I want to convert the MS Access db which came with the zip download.
Firstly, are there any suggestions on a way that i can convert MS access to mySQL?
Secondly, Will i be able to replace the ms access with mysql without needing to change the asp in any massive way?
Thanks
d
|
|
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 January 2005 at 11:24am |
|
I would use MSSQL Server for that db, as for every db call the server
must load the 165mb access database into its memory.... which is very
expensive
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 January 2005 at 11:24am |
|
Converting from Access to mySQL is normally done by hand, unless you can
find a tool to do it, by recreating the database in mySQL.
Most of the applications on this site I have written using ADO updates,
mySQL doesn't support this so you would need to change allot of the
code.
If you want to look at a database that is better then MS Access and
mySQL and is more compatible with ASP and often only requires that you
change the connection string in the ASP code, then look at MS SQL
Server 2000.
|
|
|
|
dbob
Newbie
Joined: 04 January 2005
Location: United Kingdom
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 January 2005 at 7:41am |
mmm....thanks. That is very specific, which helps. It feels cool that the app maker is giving advice.
MS SQL Server 2000 is server technology right.....i mean mySQL is a lang for producing datadbases......
I'll research the basics. But....
I host a mySQL DB on a MS SQL Server right?
I'll look into it, and i'll prob be back
Thanks for now
D
|
|
dbob
Newbie
Joined: 04 January 2005
Location: United Kingdom
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 January 2005 at 7:53am |
OK, im back.
Let me try and cut this down into simple parts.
I have a MS Access DB. I want to migrate over to mySQL.
Say that i do this, then I will want to host the mySQL db on a server that provides MS SQL 2000.
boRg, what I need to do is: - create a mySQL database with the most recent release. And, then ensure that I can host the db, as i have said, on MS SQL...??
|
|
