LINK - Windows Azure - Clone of SQL Azure

最新推荐文章于 2024-07-03 21:20:53 发布

jameszhouhvs

最新推荐文章于 2024-07-03 21:20:53 发布

阅读量649

点赞数

CC 4.0 BY-SA版权

分类专栏： Windows Azure

本文链接：https://blog.youkuaiyun.com/jameszhou/article/details/47038789

Windows Azure 专栏收录该内容

23 篇文章

订阅专栏

本文介绍了如何在 Windows Azure SQL 数据库中复制数据库。具体包括在同一服务器上复制数据库的命令及跨服务器复制的方法。此外还提到了使用导入导出功能进行数据库迁移、归档以及创建事务一致性副本。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

http://blog.idera.com/sql-server/how-to-make-a-copy-of-a-database-on-windows-azure-sql-database/

The exact command to run depends on whether or not you are copying a database to the same SQL Database server or to a different one. To create a new database (new_db) as a copy of an existing database (current_db) on the same server, simply connect to the master database then run the following statement:

CREATE DATABASE [new_db] AS COPY OF [current_db]

If current_db is to be created on another SQL Database server, connect to the destination server and run this command (where source_server is the SQL Database name where current_db is stored):

CREATE DATABASE [new_db] AS COPY OF [source_server].[current_db]

https://msdn.microsoft.com/en-us/library/azure/hh335292.aspx

Migrating your database is as simple as exporting the schema and data, storing this file in an Azure Storage Account, and then importing the file to create a new database. Import and Export can also be used for archiving, as well as combined with Database Copy to create a transactionally consistent copy of a database.