ringkasnya ini dimaksudkan untuk merestore database yg dikirimkan dari simda (mssql2000) lanjutkan upgrade oleh mssql2008 dan agar dapat digunakan lebih lanjut oleh mssql2012 di ubuntu.
1. sudo mkdir -p /var/opt/mssql/backup
2. sudo mv /home/user/usersdb_erp_bc.bak /var/opt/mssql/backup/
3. sqlcmd -S localhost -U SA
| 1> RESTORE FILELISTONLY from DISK = ‘/var/opt/mssql/backup/usersdb_erp_bc.bak’ |
| 2> GO |
didapatkan logical name database dimaksud
- UsersDB_ERP_QL
- UsersDB_ERP_Log
perintah restore sbb :
| 1> RESTORE DATABASE UsersDB_ERP_BC |
| 2> FROM DISK = ‘/var/opt/mssql/backup/usersdb_erp_bc.bak’ |
| 3> WITH MOVE ‘UsersDB_ERP_QL’ TO ‘/var/opt/mssql/data/UsersDB_ERP.mdf’, |
| 4> MOVE ‘UsersDB_ERP_QL_log’ TO ‘/var/opt/mssql/data/UsersDB_ERP.ldf’ |
| 5> GO |
selamat mencoba
sumber : https://medium.com/@amalrikmaia/how-to-restore-a-sql-server-database-on-ubuntu-437882a134bf