| Author |
 Topic  |
|
JohnC
Junior Member
215 Posts |
 Posted - 23 January 2007 : 12:59:43
|
I'm currently running version 3.4.03 with MS Access of about 60MB, and I think it's about time I start looking at converting to MySQL or MSSQL. I'm getting a little clocking from whatever (open db connections?) when the Access db deadlocks. If it wasn't for that, the speed of my Access-based forums is great!
With my current host I am able to have more MySQL databases (8) compared to MSSQL database (1). In addition, my host has an online version of PHPMyAdmin and offers no administration application for MSSQL.
Given my current situation, do you feel it would be better to convert my Access to MSSQL and use up my one MSSQL allotment and install MS SQL Server Management Studio Express or go with MySQL and use what's already available to me?
Admins: If you feel this topic would be better somewhere else, by all means please move it there. Hopefully the email notification is turned on snitz.com forums. |
Edited by - JohnC on 24 January 2007 13:26:29 |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 23 January 2007 : 13:16:40
|
My own preference is very strongly for MS SQL Server, and if this were a commercial question I would not hesitate in my answer. However, Snitz and your host between them don't use all the things I really love (I love the power of the DB, getting deep into the engine (which your host won't let you), and some of the language constructs (for instance the language enhancement I personally had added to the full-text search capability)).
In your position though, I guess I'd swallow my pride and go for MySQL if you believe it'll outperform Access/Jet in this case. |
 |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 23 January 2007 : 13:49:56
|
While either one will better serve you than Access, I would go with MySQL simply because they are giving you better admin tools to manage it.
All things being equal I've had fewer problems with MS SQL Server, but you also need to be able to use the proper admin tools or it will ultimately be more frustrating. |
|
|
|
JohnC
Junior Member
215 Posts |
Posted - 23 January 2007 : 15:24:24
|
Wow, thanks for the quick response, pdrg and AnonJr!  After looking into my account a little further, I noticed that I have the following database architecture available to me:
- MSSQL: 1
- MSSQL Express: 2
- MySQL: 8
- MS Access: No limit
And the following tools:
- MySQL: PHP MyAdmin (online version)
- All Others: Download and install MSSQL management studio
Given the resources listed above, do you still feel that I would be better off going with MySQL? |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 23 January 2007 : 15:42:53
|
I've not had a chance to familiarize myself with MS SQL Management Studio (why oh why does MS insist on long product names?), but since (as I understand it) its the replacement for Enterprise Manager, I'd give serious consideration to SQL Server.
The next big question to find out is if there is a space limitation on the size of the database and if so, can it be increased if needed. Odds are there is a limitation and its big enough that you won't have to worry about it for a while... but its always good to know these things up front.
Oh, and before I forget, if you do go to upgrade to SQL Server, make sure you follow the directions in the second post in this thread. 
(Now I should add that I am by no means an expert in SQL Server... so keep that in mind too.) |
Edited by - AnonJr on 23 January 2007 15:43:54 |
|
|
|
JohnC
Junior Member
215 Posts |
Posted - 23 January 2007 : 16:11:37
|
Late breaking info: I just found out that I have available to me one of Microsoft's online SQL management tools, Web Data Administrator. I created a test MSSQL 2000 db, logged into WDA, and it looks nice, and easy to use! Not sure if I'll be able to edit data in a table with it though...
I know my MSSQL db limit is 200MB, which will be plenty for me.
Thanks for the link! Got it, you're no expert!
So should I shoot for converting my Access db to MSSQL 2000?  |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 23 January 2007 : 16:27:23
|
| FWIW, that would be my recommendation. |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 23 January 2007 : 16:35:08
|
| Yeh, I'd go for the MSSQL db in that case, or even one of the Express ones |
|
|
|
JohnC
Junior Member
215 Posts |
Posted - 24 January 2007 : 11:48:16
|
| Now I would like to use my one MSSQL allotment for another program that I know uses only MSSQL 2000. So between the MySQL and MSSQL Express, do you feel MSSQL Express would be better to convert to? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 24 January 2007 : 13:10:44
|
As Rui says, you can have several sets of tables and apps within the one database, but you'd normally segment them for ease of upgrade etc.
As for SQL Express vs MySQL, I don't know if Snitz has been officially 'thumbs-up'-ed with MSSQL Express, but if it has, I'd use that no question, otherwise MySQL.
However, I have to be frank, I'm not a MySQL fan, mostly for historic reasons I guess! I may just be prejudiced |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
JohnC
Junior Member
215 Posts |
Posted - 24 January 2007 : 15:00:53
|
| Upon doing a search I ran across a thread where the Support Moderator, Podge, was playing with MS SQL Express. I wonder if he would be so kind as to chime in here and voice his or her opinions... |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 24 January 2007 : 15:42:39
|
Oh, if the only limit is the 1G db size, without question you should use that.
And I agree Rui, you're certainly right, and I'm sure MySQL is still worth every cent of the money it costs, but when you compare the feature list with even the Express edition of MSSQL, it's just not there yet...
*sprocs
*inline functions
*subqueries
*on-the-fly temp table management
are just a few that have come up on the boards in the past month or two! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 January 2007 : 15:54:17
|
Paddy, I'm all for SQL Server, even if MySQL has been recovering some ground, feature wise: sprocs and subqueries are available in 5.x versions of MySQL.
Of course, SQL Server has lots of new features as well :). |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Topic |
|
Topic Locked
