SQL Server数据迁移到Ubuntu主要有以下步骤,以备份还原法为例:
备份源数据库
C:\backup\YourDB.bak)并完成备份。传输备份文件到Ubuntu
scp YourDB.bak user@ubuntu_ip:/path/)将备份文件从Windows传输到Ubuntu服务器。在Ubuntu上安装SQL Server
sudo apt-get updatesudo apt-get install -y mssql-serversudo /opt/mssql/bin/mssql-conf setupsudo 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导入。注意事项: