SQL Server数据迁移到Ubuntu主要有以下步骤,以备份还原法为例:
备份源数据库
C:\backup\YourDB.bak
)并完成备份。传输备份文件到Ubuntu
scp YourDB.bak user@ubuntu_ip:/path/
)将备份文件从Windows传输到Ubuntu服务器。在Ubuntu上安装SQL Server
sudo apt-get update
sudo apt-get install -y mssql-server
sudo /opt/mssql/bin/mssql-conf setup
sudo systemctl start mssql-server
还原数据库到Ubuntu
sudo apt-get install mssql-tools unixodbc-dev
,并添加到PATH(echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
)。sqlcmd
还原数据库:sqlcmd -S localhost -U SA -P 'YourPassword' -Q "RESTORE DATABASE YourDB FROM DISK '/path/YourDB.bak' WITH MOVE 'YourDB_Data' TO '/var/opt/mssql/data/YourDB.mdf', MOVE 'YourDB_Log' TO '/var/opt/mssql/data/YourDB_Log.ldf'"
验证迁移结果
sqlcmd
或SSMS连接Ubuntu上的SQL Server,运行查询(如SELECT Name FROM sys.Databases
)确认数据库已成功还原。其他方法:
sqlpackage
工具或SSMS导入。注意事项: