| Author |
 Topic  |
|
|
mortioli
Average Member
United Kingdom
898 Posts |
 Posted - 26 March 2004 : 11:49:59
|
I soon have the option to upgrade to an MS Sql database, but it limits it too 150 MB. Currently my Access database is 140 MB, so I was wondering if there is a size difference between the two databases?
Eg, does 1 MB on Access = 1 MB on MS Sql?
I've tried to find an answer, but was unlucky.
Thanks for your help! |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 26 March 2004 : 12:07:13
|
No it doesn't, unfortunately. and there is no hard and fast rule that I am aware of, it entirely depends on your database, but would generally expect one of that size to be smaller in SQL than access.
I have a few forum dbs of varying sizes, will run a couple of tests to give you a rough idea. |
 |
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 26 March 2004 : 14:33:36
|
| Just something to consider. Have you tried compacting/repairing the database? Especially if you've pruned data out of it. It can significantly shrink the size of the database. |
Dave Maxwell
Barbershop Harmony Freak |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 26 March 2004 : 14:41:44
|
| And if it is still that big after compacting then you will run out of space pretty soon in your 150Mb DB, you will only gain a few meg in the upgrade to sql (maybe 10 Mb max) so you will not have that much room to play with. |
|
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 26 March 2004 : 16:47:55
|
I haven't got round to compacting or repairing it...it always timesout when I'm attempting to do it through Snitz, so I have to download it and re-upload it, and it's finding the time to do that 
I'll give it a go though, and see how much difference it makes!
I'd be interested to see your results HuwR  |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 26 March 2004 : 17:11:16
|
sorry, those were the results, if 140Mb is the actual size after compressing, then you will gain around 10Mb converting to SQL, If you have not compacted it then as Dave said it should make a big improvement.
If you don't mind giving me ftp access to it, I can download and compact it for you, I have a very quick connection, just email me your details, I would however advise taking your forum ofline while it is done.
|
|
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 26 March 2004 : 18:38:52
|
I downloaded my database earlier, and just compacted it...from 138 MB to 86.4 MB
I'll have to decide on a quiet time to do it properly and upload it afterwards. Thanks for the offer...I'll keep it in mind |
|
|
| |
Topic |
|
Topic Locked
