Move Database file in MySQL and MsSQL

1.MsSQL

Stop all SQL service

Set permission to new folder

Detect names and location of each files

Alter database to new location

Set database offline

Move files

Set database online

2.MySQL

Detect location of data and control file

Stop service

Change location in config

If needed change other parameters include default data directory by GUI

Move data and start server again

Comments ( )