N/APosted on - 01/31/2013
We have a large customer’s database in MS access. In recently, it is getting stuck when we work in our network, so my boss needs to make a new database for our company, we are planning to use MySQL server for develop a new database. I want to know, will it be totally protected our data with having SQL copy database as backup?
Does it protect data, having sql copy database as backup
Yes Of course you can obtain many benefits using SQL database over Access database even as back up. Here are some advantages you will gain with SQL databases.
You can fast search and load of pages WHEN you have a lot of data.
You can fairly easily make backups on SQL.
You can easily import SQL files into another database.
SQL is usually more secure than Access but then again it will depend on how your set up is configured.