| Author |
 Topic  |
|
|
VodkaFish
Average Member
USA
654 Posts |
 Posted - 18 July 2002 : 10:55:27
|
Ok, I was looking at a hosting company and saw some add-on options. They had two SQL Server options. One for 15 megs, one for 50. Now, my Access db (for Snitz) is 60 megs. I was wondering, how does it translate? I know it's less, but how much? Would I already be forced to use the larger package?
btw - this is a hypothetical question. I am setting up my own server, but even if it's for a few months, I may just change over to SQL now (it's getting that bad - and I also need a little more security - I've been hacked - site, not forums - and I feel if my db's weren't in file form, it could be a little safer), even if it's for just a few months before my setup. Which then makes me ask this question - is it easy to move a SQL Server database?
Thanx whoever can answer these. Huwr, I think you'll chime in, so I'll thank you already 
v ø d k â f ï § h |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 18 July 2002 : 11:03:32
|
if you are speaking about migrating your existing data from Access to SQL there are some issues you need to be aware of. the biggest issue I ran into when trying to take this path is that Access uses AUTONUMBER and SQL does not support that. Instead you have to use IDENTITIES which has a default seed value of 1 which will then autoincrement. I had to go through all the tables that had AutoNumber in Access and convert them. There were some other issues as well, but I think that was due to some of the mods I was using, so I just decided to scrap everything and start from scratch with exception of my MEMBERS info. I did not want everyone to re-register nor lose their stats so I imported that information successfully.
As for size, it appeared to me to be somewhat equivilant but I'm not sure. I do know that my backups are extremely large but that is because of the transaction log (I think) that goes with the database. When you create a SQL database there will be 2 file components with an .MDF and .LDF
Anyway, there are some SQL experts here that can probably provide more info as it pertains to Snitz Forums
http://www.nineinchnailz.com |
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 18 July 2002 : 11:56:49
|
quote:
Thanx whoever can answer these. Huwr, I think you'll chime in, so I'll thank you already
Bing bong
If your access db is 60Mb, it will not fit into 50Mb SQL db, because of indexes etc, you database is more likely to be large in SQL than in Access.
It is fairly simple to migrate, but you must follow a few steps. Do a search in this forum, s someone posted an easy upgrade guide not that long ago.
|
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
grazman
Junior Member
USA
193 Posts |
Posted - 18 July 2002 : 12:29:09
|
Here's some sizing information from SQLTeam.com's (www.sqlteam.com) forums.
Table_Name rows reserved_KB
----------------------------------- ----------- ------------------
bgraziano.FORUM_REPLY 38884 31544 KB
bgraziano.FORUM_TOPICS 16221 23624 KB
bgraziano.FORUM_MEMBERS 5078 4328 KB
bgraziano.FORUM_SUBSCRIPTIONS 987 136 KB
bgraziano.FORUM_MODERATOR 33 104 KB
bgraziano.FORUM_ALLOWED_MEMBERS 11 40 KB
bgraziano.FORUM_FORUM 15 40 KB
bgraziano.FORUM_TOTALS 1 32 KB
bgraziano.FORUM_CONFIG 1 32 KB
bgraziano.FORUM_CONFIG_NEW 122 32 KB
bgraziano.FORUM_CATEGORY 3 24 KB
bgraziano.ForumDisplay 16 24 KB
bgraziano.Forums 1 16 KB
bgraziano.FORUM_A_REPLY 0 0 KB
bgraziano.FORUM_A_TOPICS 0 0 KB
I generated that using this script: http://www.sqlteam.com/item.asp?ItemID=282. A SQL Server database will almost always be bigger than an Access database. SQL Server allocates data in 8K pages and that results in unused space floating around.
My forums tends to get alot of code snippets posted so the size of the posts is fairly large. You can get a round bytes/reply number and use that to estimate the size of your forum. I will be a VERY rough guess though.
If you convert your data to SQL Server you aren't that much safer. If they get access to your source code they will find your connect string which will get them into your database. There are ways to make SQL Server more secure (stored procedures and views) but because Snitz supports so many databases they are unable to take advantage of those.
SQLTeam.com - For SQL Server Developers and Administrators
Snitz Info - SQL Server info on Snitz Forums |
|
|
|
VodkaFish
Average Member
USA
654 Posts |
Posted - 18 July 2002 : 18:04:35
|
Yeah, I've read a lot on the conversion Tried to see most problems associated with it, etc.
Thanx for the info on size. I had no idea it could be bigger. Performance is key in the end, so is getting all my Access databases into one SQL Server db.
As for security, the only thought I had for it was just that if someone hacks into my ftp account, they cannot d/l the db (Snitz or otherwise).
Thanx again guys.
v ø d k â f ï § h |
|
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 19 July 2002 : 14:15:03
|
I know this will probably be a weird question, but about how many posts will fit into a 50 meg SQL 2000 DB? I guess I could get a good idea with this forum. How many posts are there, and how big is the DB?
<-- Eric --> |
|
|
| |
Topic |
|
Topic Locked
