SQL Azure Data Sync Preview is not backward compatable with the CTP2 version. This article covers how to move from the CTP2 version of SQL Azure Data Sync to the Preview version.
Important! This wiki topic may be obsolete. This wiki topic is no longer updated by Microsoft. We moved the content to the MSDN Library where we keep it current. To find the latest version of this topic on MSDN click here. |
How to I upgrade from CTP2 to the Preview version of SQL Azure Data Sync?
Essentially there are two broad steps:Clear out all CTP2 Artifacts
Make sure your databases are de-provisioned i.e. Sync related metadata should be cleaned up from your database.
You can use a standalone executable deprov.exe for this de-provisioning. This executable was installed when you installed LocalAgentSetup msi for CTP2 (If your system directory is C: and you used default path of installation, this utility will be at c:\program files (x86)\Microsoft SQL Azure Data Sync). Latest version of this msi is at the download center now.
Usage: | ||||
CPT2 Preview |
Deprov.exe <connectionstring> [/f] DeprovisioningUtil.exe <connectionstring> [/f] |
|||
<connectionstring> | Specifies the connection string of the Sql Server or Sql Azure database to be deprovisioned. | |||
[/f] | Deprovision without warning. | |||
Examples: | ||||
SQL Server | CTP2 | deprov "Server=(local);Database=NorthWind;Trusted_Connection=True" | ||
Preview | deprovisioningutil "Server=(local);Database=NorthWind;Trusted_Connection=True" | |||
SQL Azure | CPT2 | deprov "Server=tcp:rwbhdyp2ym.database.windows.net; Database=NorthwindAzure; User ID=<yourID>; Password=<yourPassword>; Trusted_Connection=False;" /f | ||
SQL Azure | Preview | deprovisioningutil "Server=tcp:rwbhdyp2ym.database.windows.net; Database=NorthwindAzure; User ID=<yourID>; Password=<yourPassword>; Trusted_Connection=False;" /f |
Uninstall the local agent.
To uninstall a local agent you:
-
Open Programs and Features in your Control Panel
Start > Control Panel > Programs and Features -
Find the entry Microsoft SQL Azure Data Sync CTP2 and right-click it.
-
Select Uninstall.
Recreate Your Sync Groups
To recreate your sync groups see the article SQL Azure Data Sync Create a Sync Group.Feedback
This release was provided in order to gather feedback from our customers. Now that you have previewed what the SQL Azure Data Sync team is doing, please let us know what you think of our direction, and tell us about your experiences. You can send us your thoughts in any of the following ways:- Send us a note on http://twitter.com/syncfx.
- Post a comment to our blog at http://blogs.msdn.com/sync.
- Post a thread to our forum at http://social.msdn.microsoft.com/forums/en-US/ssdsgetstarted/threads/