Does it protect data, having sql copy database as backup

Asked By 0 points N/A Posted on -
qa-featured

 

Hi everyone,

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?

SHARE
Answered By 0 points N/A #167073

Does it protect data, having sql copy database as backup

qa-featured

Hello Muller,

 

 

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. 

 

Thank you.

Rubi Sharlene

Related Questions