Hello everyone. (Nice to see a busy forum on a host that isn't just post after post of moans and groans, I think we must of found a good one). I have used MySQL in the field for years, so I am comfortable with it. Excuse this if it's a dumb question, I haven't developed on MS type stuff since XP first came out, I've always been on UNIX then Linux until now. (still am on those, but I needed something to get my interest in programming activated again). But before I add MS SQL to my account, I wondered if they might be advantages in using MS SQL. Would I be right in thinking that MS SQL is like MS Access, with all the same stored queries, reports snippets and even application code? Or is it just a database like MySQL only with more capitals in it's name?
MS SQL is significantly different than MS Access and mySQL. The major differences between MS SQL & Access are - Scalability. MSSQL scales much better than Access. It can handle database much larger than access. - Additional functions, like Stored procedure, views, etc. - Much faster!! - Better consisitency control. MS Access have problem if you have concurrent connection - Transactional support (this allow you to have database transaction) As for MySQL - mySQL doesn't have stored proc - mySQL doesn't support transaction Bruce DiscountASP.NET www.DiscountASP.NET
