Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - a 165 MB Access database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

a 165 MB Access database

 Post Reply Post Reply Page  <12
Author
dbob View Drop Down
Newbie
Newbie


Joined: 04 January 2005
Location: United Kingdom
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote dbob Quote  Post ReplyReply Direct Link To This Post Posted: 05 January 2005 at 11:40am
oh, MS SQL SERVER 2000 software is expensive, since i am only learning. so it is a software, that much is clear.
Back to Top
JohnKn View Drop Down
Groupie
Groupie


Joined: 22 March 2003
Status: Offline
Points: 46
Post Options Post Options   Thanks (0) Thanks(0)   Quote JohnKn Quote  Post ReplyReply Direct Link To This Post Posted: 05 January 2005 at 4:37pm
http://www.dbtools.com.br/EN/ is a great tool for managing mySQL databases and has import wizards to convert Access databases to mySQL very easily.

SQL = "structured query language" the language sql based servers use
MS SQL = Microsoft sql database server
mySQL = open source database server

Both MS SQL and mySQL use the SQL language to greater or lesser extant but they're totally seperate products dwdws. If your host only supports MS SQL that you'll need to "upsize" it to MS SQL, not mySQL. That can be done either though Access or by using microsofts Enterprise manager. There are likely other tools to do it, but those are the ones I'm aware of.

To zMaestro I would take borgs advice and convert that large Access db to either mySQL or MS SQL especially if you expect a lot of traffic on your site. The db will likely get even larger after upsizing to MS SQL, at least my Web Wiz db did.




Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.