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 (
)

Link to this page:
//www.vb-net.com/MoveDatabase/Index.htm
<SITEMAP> <MVC> <ASP> <NET> <DATA> <KIOSK> <FLEX> <SQL> <NOTES> <LINUX> <MONO> <FREEWARE> <DOCS> <ENG> <MAIL ME> <ABOUT ME> < THANKS ME> |