SQL Server在Debian下的数据迁移可参考以下步骤:
安装SQL Server及工具
sudo apt update && sudo apt upgrade
sudo apt install -y curl gnupg apt-transport-https
curl https://packages.microsoft.com/keys/microsoft.asc | sudo gpg --dearmor -o /usr/share/keyrings/microsoft-archive-keyring.gpg
echo "deb [signed-by=/usr/share/keyrings/microsoft-archive-keyring.gpg] https://packages.microsoft.com/debian/12/prod/ stable main" | sudo tee /etc/apt/sources.list.d/mssql-server.list
sudo apt install -y mssql-server
,配置时设置SA用户密码。sudo apt install -y mssql-tools
。数据迁移方法
.bak
文件并传输到Debian服务器(如通过scp
)。sqlcmd -S localhost -U SA -P <密码>
,执行RESTORE DATABASE <数据库名> FROM DISK = '/路径/备份文件.bak'
。sqlcmd
中运行脚本。验证与优化
注意: