???????и?????????????? SQL Server 2012 ??????????? Azure SQL ?????????????????????????????????????????????????????????????????????????????????????????????????????ν??????????????????????????????????εΣ??????????????????????
????Azure SQL ??汾
????Azure SQL Database ????????? SQL ????(PaaS)???μ?汾?? Azure SQL Database V12?????????????? SQL Server 2014 ????????????

????????е??????????????????????? SQL Server 2014??????????????????????? Azure SQL Database??????????????????????汾????????
?????????????? Azure SQL Database ????????????????汾??????????????????в???????????????????????????????????
?????????????????????????? Azure SQL Database ????????????????????Щ???????μ? MSDN ??????????MS ?????????????? Azure SQL Database ????????????°???????????????????? SQL Server 2014 ?е? SSMS (SQL Server Management Studio) ????????? Azure SQL ?????????????? Azure portal ??????????°?? SSMS ???????????
?????????????????????????8G??С????????????????????????????????ж????????????????β????????????????????????????????????????????????????????????????????????????????顣???????е??????鶼??????????????????????????????????
?????????????
????????????Azure SQL Server
????Azure SQL Database ???????? Azure SQL Server ?е????????????? Azure ????? Azure SQL Server ?????á???????????????? Azure ????? SQL Server (logical server) ???????????????????????(????????????)??
??????????????? Azure SQL Server
????Azure SQL Server ???????????????? SSMS ?????????????????????????????????????????????????????????????

????????????????? IP ??????? Azure????????????????????????? Azure ???????????????????????
??????????? Azure ?????????????????????????????????ЩIP???????IP???ο?????? Azure SQL Server?????????????????????
????1???????????е? "Sign in"????Azure????????????? "OK"???????????????????????????SSMS ???? Azure SQL Server???????????????????????????????????????????? IP??
????2????????????????? Azure portal?????? Azure SQL Server ?????y??棬???????????????????????????? IP ?????????????????Σ?

?????????????
???????? MS SQL Server ?汾??????????汾????汾??в?????????????????????????????????????????????????????
???????潫??????????????????????????
?????????????????
?????????????????????????
?????????????????????????????
????Error SQL71564: Error validating element [xxxx]: The element [xxxx] has been orphaned from its login and cannot be deployed.
???????е? xxxx ?????????????????????
???????????????????????????????? SQL Server ?У???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? Azure SQL Server ?????????????????????????????????????????????????????ο? MSDN??
?????????Extended Property
?????????????????????????????
????One or more unsupported elements were found in the schema used as part of a data package.
????Error SQL71564: The element Extended Property: [dbo].[xxxx].[MS_Description] is not supported when used as part of a data package (.bacpac file).
???????е? xxxx ???????????????????
?????????????????????? Extended Property????????????????кü????????????????????????????????????????????????????????????????????????????????????Щ?????????????????????
???????? clustered index
?????????????????????????????
????One or more unsupported elements were found in the schema used as part of a data package.
????Error SQL71564: Table Table: [dbo].[xxxx] does not have a clustered index.
????Clustered indexes are required for inserting data in this version of SQL Server.
???????е? xxxx ???????????????????
?????????????? clustered index????????????С???顣????κζ???????????????????????????????????????????????????????????????????????????????? clustered index????????????е?????з????仯??
????ALTER TABLE [xxxx] ADD
????RowId int NOT NULL IDENTITY (1?? 1) PRIMARY KEY CLUSTERED
????GO
????????
?????????Щ??????????????????????????????о??????????????????????в????????????????????????????????????????????????
???????????????ж?????????д????????????????????????У???????????????н???????
??????????
????MS ?????????????м??????顢?????????????????????? SSMS (SQL Server Management Studio) ?????濴?????????????衣
?????? SSMS ???????????????????? Tasks ?е?"Deploy Database to Microsoft Azure SQL Database…"??

????????????е?? "next" ????"Deployment Settings"???檔
??????????????? Azure SQL Server ??????????????????

?????????????????????????????????????

??????? Azure SQL Database settings??MS ?????????????????????????????????Basic?? Standard?? Premium????????????????????????????????????????????????????????????????????????????????????????????????????