Question

Locked

My SQL vs SQL server

By Assiram ·
I Want to know the difference between My SQL and SQL server. Which one is better in terms of easy access of large database and increasing records. I have a MS Access database which handles PDF attachments. The problem I have right now is that the database has reached its maximum capacity of Ms Access so I need to convert the database to other Apps. Please help

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

SQL Server all the way

by Thorrington In reply to My SQL vs SQL server

The later versions of msaccess carry specific key functionality for SQL server including the ability to manage the table creation and modification activities directly from the Access UI. Slicker stored proc execution and failover support make SQL Server (or even the free express version) the perfect partner for a MS Access front end. The MySQL driver for ODBC into access it 'touchy' to say the least with poorer performance and ease of DB management. The attachment file type is now also available in SQL Server.

Collapse -

Much of a muchness in terms

by Tony Hopkinson In reply to My SQL vs SQL server

of capability. You are going to find it a lot easier to migrate from access to sql server though, and mysql doesn't really show it's stuff under windows anyway, so unles you want to pick up linux as well...

That said access among it's other faults is truly crap with blobs (pdfs, images etc). Have you looked at just storing the filenames in the db, do it as a url and you could then put them anywhere. It's a bit more work coding wise, keeping things in step, but dbms's of any stripe aren't good file managers.

Back to Networks Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums