Networks

Ask something
Question Locked

My SQL vs SQL server

0 helpful
3 replies

by assiram

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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

3 replies

by thorrington

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.

by tony hopkinson

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.

This discussion is closed to new replies.