Eksportér (0) Udskriv
Udvid alt
EN
Dette indhold er ikke tilgængeligt på dit sprog, men her er den engelske version.

How to Upgrade a Client Agent

Updated: February 12, 2014

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

 

SQL Azure Data Sync Icon

If any of your sync groups include an on-premises SQL Server database, you must have the current client agent installed. You can install an agent from SQL Database at the Azure Management portal. (See Install a SQL Data Sync (Preview) Client Agent.)

Before you can add an on-premises SQL Server database to your sync group, you must register it with the agent. (See Register a SQL Server Database with a Client Agent.)

The current client agent version is 4.0.89.0). You can download the latest client agent from client agent download site.

The Microsoft Azure SQL Data Sync plug-in on the Microsoft Azure Silverlight portal has been decommissioned. Going forward, use the Microsoft Azure Management portal, for Azure SQL Data Sync.

You access SQL Data Sync (Preview) via the SYNC tab under SQL Database at the Microsoft Azure Management portal. The SYNC tab is only available when you have one or more sync groups. See the topic How To: Create a Sync Group (SDS) for guidance on creating and modifying a sync group from this portal.

See the Navigation section below for links to topics you should read before you start and guidance on creating and modifying sync groups.

How to upgrade to the latest version of the client Agent?

Before you upgrade, check to see if you need to. If you have client agent version 4.0.89.0 or later, you do not need to upgrade.

A. Determine your client agent version

There are two ways to determine the version of the installed client agent.

  • From the client agent UI.

    1. Make sure your client agent is running.
      If the client agent isn’t running the UI shows version 0.0.0.

      1. Click Start.

      2. Type services.msc in the search textbox.

      3. In the results pane, click the services program.

      4. Scroll down to Microsoft SQL Data Sync.

      5. If the status is not Started, right-click the service and select Start.

    2. Navigate to where you installed the client agent.

    3. Find and launch the application SqlAzureDataSyncAgent.

    4. Find the version in the lower-right corner of the client agent UI. (Figure 1.1)

      Use the agent UI to determine the agent's version
      Figure 1: SQL Data Sync Status, Agent Name, and Agent Version


  • From Start -> Control Panel -> Programs and Features.

    1. From the Start menu, click Control Panel.

    2. Click Programs and Features.

    3. Scroll down to Microsoft SQL Data Sync.

    4. Find the version number in the far right column. (Figure 2)

      Use Add/Remove programs to find agent's version
      Figure 2: Agent Version

If your client agent version is 4.0.89.0 or later, you do not need to upgrade.

B. Start the client agent

If the client agent is not running, start it. If the service is running, skip to step 2.

  1. Navigate to the installation folder. The default installation path is:
    32-bit systems - C:\Program Files\Microsoft SQL Data Sync
    64-bit systems - C:\Program Files (x86)\Microsoft SQL Data Sync

  2. Find and launch the application SqlAzureDataSyncAgent under the bin folder of the install path.

C. Upgrade to the new agent

See the topic section Option 2-a: Install a new Agent for instructions on how to install a client agent.

  1. Click Upgrade Agent from your client agent window.
    The upgrade wizard upgrades your agent. Accept the default installation path.
    32-bit systems - C:\Program Files\Microsoft SQL Data Sync
    64-bit systems - C:\Program Files (x86)\Microsoft SQL Data Sync

  2. After the installation completes, close the client agent window.

D. Retain current sync group info

If your old agent installed in a different folder than the upgrade agent, do not delete the installation folder of your old agent. All of your sync group information is contained in AgentConfigData.xml. Copy this file to where the upgrade agent was installed.

  1. Start Windows Explorer.

  2. Navigate to the old installation folder. The old default installation path is:
    32-bit systems - C:\Program Files\Microsoft SQL Data Sync
    64-bit systems - C:\Program Files (x86)\Microsoft SQL Data Sync

  3. Navigate Windows Explorer to the data folder.

  4. Find and make a copy of AgentConfigData.xml.

  5. Navigate Windows Explorer to the data folder of the newly installed client agent.
    32-bit systems - C:\Program Files\Microsoft SQL Data Sync\data
    64-bit systems - C:\Program Files (x86)\Microsoft SQL Data Sync\data

  6. Paste the AgentConfigData.xml file (copied in step 3) into the data folder.

E. Repeat

Repeat steps A - D for each client agent installed on your system.

F. Restart the Microsoft SQL Data Sync Service

  1. Click the Start menu.

  2. In the search textbox, enter "Services."

  3. In the results, click the Services program.

  4. Find and right-click the Microsoft SQL Data Sync service.

  5. If the service is running, select Stop from the context menu.

  6. After the service stops, right-click the Microsoft SQL Data Sync service and click Start from the context menu.

Navigation

SQL Data Sync (Preview) is a feature of SQL Database. From the Azure Management portal you can perform all tasks necessary to create, deploy, and modify a sync group.

 

Before you start

Before you begin to design and implement your synchronizations, you should be familiar with these topics.

How to create a sync group

There are six steps to creating a sync group from the Azure Management portal. Details on each step can be found by following these links.

  1. Sign in to the Azure SQL Database Management portal
    SQL Data Sync (Preview) is found as a tab under SQL Database only after you create a sync group.

  2. Install a SQL Data Sync (Preview) Client Agent

  3. Register a SQL Server Database with a Client Agent

  4. Create your Sync Group (SDS)

  5. Define your sync data (SDS)

  6. Configure your sync group (SDS)

 

How to modify a sync group

You can modify a sync group’s schema by adding/removing tables or columns in the sync group; or by altering a column’s width or data type. Details can be found by following the links.

See Also

Fællesskabsindhold

Tilføj
Vis:
© 2014 Microsoft