Microsoft SQL Azure ³£¼ûÎÊÌâ½â´ð
¹«¸æ£º±¾²©¿ÍΪ΢ÈíÔÆ¼ÆËãÖÐÎIJ©¿ÍµÄ¾µÏñ²©¿Í£¬²¢²»±£Ö¤Á´½Ó¿ÉÓÃÐÔ£¬ÎªÁ˱£Ö¤ÔĶÁÌåÑ飬Çë·ÃÎÊhttp://blogs.msdn.com/azchina¡£
October CTPµÄ SQL Azure DatabaseµÄ¹Ø¼ü¹«¸æÊÇʲô£¿
October CTPµÄSQL Azure database¶ÔÓÚPDC2009À´Ëµ»ù±¾¹¦ÄÜÒѾÍê³ÉÁË¡£ October CTP ÒѾ±»²¿ÊðÖÁÉú²ú¼¯ÈºÖ®Ò»¡£µ±SQL Azure Database±äΪ¹ã·º¿ÉÓ㬴˻·¾³»á×Ô¶¯×ª±äΪһ¸öÊܵ½Íêȫ֧³ÖµÄÉú²ú»·¾³¡£»ùÓÚÄúËùÑ¡ÔñµÄSQL Azure databaseÈϹº·½Ê½£¬ÄúËùÓÐÔÚ´Ë»·¾³ÖеÄÊý¾Ý¿âÓëÊý¾Ý»á±»×ª»»ÎªÒ»¸öÓÐЧÈϹºµÄ״̬¡£
SQL Azure Database°üÀ¨ÄÄЩÐÂÌØÐÔ£¿
October CTPµÄSQL Azure database¶ÔÓÚPDC2009À´Ëµ»ù±¾¹¦ÄÜÒѾÍê³ÉÁË¡£ÔÚOctober CTPÖеÄһЩÐÂÌØÐÔ°üÀ¨£¨·À»ðǽ֧³Ö£¬ÅúÁ¿²åÈ룬ÊôÐÔ¸ü¸Ä£¬ÃÅ»§ÍøÕ¾£¬¶îÍâµÄTSQL¹¦ÄÜ£©¡£¸ü¶àÏêϸÐÅÏ¢Çëä¯ÀÀBlog post¡£
ʲôÊÇSQL Azure Data Sync?
SQL Azure Data Sync ÊÇÒ»¸ö¹¤¾ßÓëÔËÐÐʱ£¬ÓÃÀ´ÓëSQL Azureͬ²½¡£¸Ã¼¼ÊõÔÚÄܹ»ÔËÓÃÓÚ2¸ö·½°¸£¨ÔÚÆäËûÔÆÆ½Ì¨ÔÝÎÞͬÀ༼Êõ£©£º½«·ÇÔÆ¶ËµÄ»ù´¡Éèʩͬ²½ÖÁÔÆ¶Ë£¬¹¹½¨¾ßÓÐÀëÏߣ¨»º´æÄ£Ê½£©Ö§³ÖµÄ¿Í»§¶Ë¡£½«·ÇÔÆ¶ËµÄ»ù´¡¹¹½¨Í¬²½ÖÁÔÆ¶Ë£¬Í¨¹ýʹÓÃÔÆ¶ËµÄзþÎñÄܹ»ÈÃÐÅÏ¢ÔÚÊÖ»úÓû§¡¢ÉÌÒµ»ï°é¡¢Ô¶³Ì°ì¹«¡¢ÆóÒµÊý¾Ý×ÊÔ´Ö®¼ä¸ü¼ò±ãµÄ±»¹²Ïí¡£ÕâÏî¼¼ÊõÌṩÁËÒ»¸öÇÅÁº£¬ÔÊÐí·ÇÔÆ¶ËÓëÔÆ¶ËµÄÓ¦ÓóÌÐòͬʱ¹¤×÷¡£Ê¹Óûº´æÄ£Ê½£¬µÍÑÓ³ÙÓë¸ß¿ÉÓÃÐÔʹµÃÄܹ»¿ª·¢³ö¾ßÓÐÓÅÐãÓû§ÌåÑéµÄ¿Í»§¶Ë¡£ÁíÍ⣬»º´æÄ£Ê½Í¨¹ýµÍ¸ººÉÒÔ¼°¸ü¼ÓÓÅÐãµÄµ÷¶ÈÄÜÁ¦£¬ÌṩÁ˸üµÍµÄÍøÂçʹÓÃÂÊÓë¸üºÃµÄ·þÎñÆ÷¹æÄ£µÄºÃ´¦¡£
ÎÒÈçºÎµÃµ½SQL Azure Data Sync¸ü¶àÏêϸÐÅÏ¢£¿
ÔÚPDC 2009»áÒéÉÏ£¬SQL Azure Data Sync×÷ΪCTP°æ±¾ÔÚ´ËÁ´½ÓMicrosoft Sync Framework Power Pack for SQL Azure¿ÉÏÂÔØµ½¡£ÈçÐè»ñµÃ¸ü¶àÐÅÏ¢£¬Çë·ÃÎÊhttp://www.microsoft.com/windowsazure/sqlazure/datasync¡£SQL Azure CTP ²¢²»°üÀ¨Microsoft Sync Framework Power Pack for SQL Azure,ËüÐèÒª¶ÀÁ¢ÏÂÔØ¡£
ʲôÊǶÔÓÚ»ùÓÚSOAPºÍRESTµÄAuthority-Container-Entity (ACE) ±à³ÌģʽµÄ·ÃÎÊ£¿
Ëæ×ÅÇ¨ÒÆÖÁ»ùÓÚT-SQLµÄ¹ØÏµÐÍÊý¾Ý¿âģʽ£¬SQL Azure Database ²»»áÖ§³Ö»ùÓÚSOAPºÍRESTµÄ Authority-Container-Entity (ACE)µÄ±à³Ìģʽ¡£»ùÓÚ´óÁ¿ÔçÆÚʹÓõĿͻ§Óë»ï°éµÄ·´À¡£¬´ó¶àÊý¿Í»§»
Ïà¹ØÎĵµ£º
tempdb¶ÔSQL ServerÊý¾Ý¿âÐÔÄÜÓкÎÓ°Ïì
±¾ÎĹؼü´Ê£ºSQL Server ÍøÂç
Ïà·´Èç¹û·ÃÎÊºÜÆµ·±,loading¾Í»á¼ÓÖØ,tempdbµÄÐÔÄܾͻá¶ÔÕû¸öDB²úÉúÖØÒªµÄÓ°Ïì.ÓÅ»¯tempdbµÄÐÔÄܱäµÄºÜÖØÒªµÄ,ÓÈÆä¶ÔÓÚ´óÐÍÊý¾Ý¿â.Èç¹ûʹÓÃÁÙʱ±í´¢´æ´óÁ¿µÄÊý¾ÝÇÒÆµ·±·ÃÎÊ,¿¼ÂÇÌí¼ÓindexÒÔÔö¼Ó²éѯЧÂÊ.
¡¡ 1.SQL ServerϵͳÊý¾Ý¿â½é ......
tempdb¶ÔSQL ServerÊý¾Ý¿âÐÔÄÜÓкÎÓ°Ïì
±¾ÎĹؼü´Ê£ºSQL Server ÍøÂç
Ïà·´Èç¹û·ÃÎÊºÜÆµ·±,loading¾Í»á¼ÓÖØ,tempdbµÄÐÔÄܾͻá¶ÔÕû¸öDB²úÉúÖØÒªµÄÓ°Ïì.ÓÅ»¯tempdbµÄÐÔÄܱäµÄºÜÖØÒªµÄ,ÓÈÆä¶ÔÓÚ´óÐÍÊý¾Ý¿â.Èç¹ûʹÓÃÁÙʱ±í´¢´æ´óÁ¿µÄÊý¾ÝÇÒÆµ·±·ÃÎÊ,¿¼ÂÇÌí¼ÓindexÒÔÔö¼Ó²éѯЧÂÊ.
¡¡ 1.SQL ServerϵͳÊý¾Ý¿â½é ......
±¾ÎĹؼü´Ê£ºSQL 2008 SQL SQL Server SQL Server 2008
¶ÔÓÚ¼´½«ÔÚ2008ÄêÂ¡ÖØ·¢²¼µÄSQL Server 2008£¬Î¢ÈíÆÚÍûÊг¡²»½ö½öÊǰÑËü×÷Ϊ¹ØÏµÊý¾Ý¿âϵͳÀ´¿´´ý£¬Î¢Èí½«Æä¶¨Î»ÎªÒ»¸öÆóÒµÊý¾Ýƽ̨£¬ËäÈ»¹ØÏµÊý¾Ý¿âÒýÇæÈÔÈ»ÊÇSQL Server 2008µÄºËÐÄ£¬²»¹ýSQL Server 2008ËùÄÜÌṩµÄ·þÎñ¹ã¶È½«Ô¶³¬¹ý¼òµ¥µÄ¹ØÏµÊý¾ ......
--Óï ¾ä ¹¦ ÄÜ
--Êý¾Ý²Ù×÷
SELECT --´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
INSERT --ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐÐ
DELETE --´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐÐ
UPDATE --¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý
--Êý¾Ý¶¨Òå
CREATE TABLE --´´½¨Ò»¸öÊý¾Ý¿â±í
DROP TABLE --´ÓÊý¾Ý¿âÖÐɾ³ý±í
......