Is it possible to attach a MDF file to an Azure SQ

2020-06-04 09:01发布

I have just created an Azure Website and Linked SQL Database.

I have a SQL Server 2008 SP2 database on my local machine. Is it possible to detach the local .mdf file, FTP it to Azure and then attach it as a SQL database in Azure? The only other way is to export the scheme and load this, followed by the data.

In the absence of detaching and attaching DBs, I have come across "SQLAzureMW" which looks very useful in guiding me through this process.

Thank you in advance.

1条回答
神经病院院长
2楼-- · 2020-06-04 09:22

You can deploy an database from Management studio to Azure.

Just use this wizard

查看更多
登录 后发表回答