Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SQL Azure Data Sync on VS 2010 B2 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    The instructions for SQL Azure Data Sync say it's supported on Visual Studio 2008. Will it install on VS 2010 B2 as well? I don't want to try it and come away with a half-installed product.

    Thanks,
    Bob Beauchemin
    SQLskills
    • Moved by Max Wang_1983 Monday, April 18, 2011 10:14 PM Forum consolidation (From:SyncFx - Feedback [ReadOnly])
    Sunday, November 29, 2009 6:00 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    We have not done a full test pass of VS 2010 B2 so we can not state that is officially supported in this CTP.  However I do know that a number of developers have machines with VS 2010 B2 and have not heard of any major issues.

    Liam
    Sr. Program Manager, SQL Azure and Sync Framework - http://msdn.microsoft.com/sync/
    Monday, November 30, 2009 5:00 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes the template is for C# only for now :)

    Meanwihle if you want these teamplates to show up on your VS 2010 B2 installs, please try the below:

    1. Make sure you installed the MSI
    2. Copy the vs templates from "%SystemDrive%\Users\%username%\Documents\Visual Studio 2008\Templates\ItemTemplates\Visual C#" to "%SystemDrive%\Users\%username%\Documents\Visual Studio 2010\Templates\ItemTemplates\Visual C#"

    Hope it helps.
    This posting is provided AS IS with no warranties, and confers no rights
    Saturday, December 5, 2009 2:12 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    We have not done a full test pass of VS 2010 B2 so we can not state that is officially supported in this CTP.  However I do know that a number of developers have machines with VS 2010 B2 and have not heard of any major issues.

    Liam
    Sr. Program Manager, SQL Azure and Sync Framework - http://msdn.microsoft.com/sync/
    Monday, November 30, 2009 5:00 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Great! Thanks Liam, I'll give it try.

    Cheers,
    Bob
    Monday, November 30, 2009 6:48 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Just a note for others who might go in this direction. I installed Sync Framework and SQL Azure Data Sync on a machine with VS2010 B2 and SQL Server 2008 R2, logged in as administrator. I can see and use the Azure sync application, but the New Item for VS2010 is not available (does not appear on the list of items to add for a C# Console App). The general Sync item is available, just not the Azure-specific one (SQL Azure Data Sync Client). I haven't yet investigated where it got installed and why it doesn't appear yet. I will do an install on VS2008 SP1 to confirm it appears there.

    Tuesday, December 1, 2009 12:46 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    The same with me but with VS2008 SP1.

    It is a nice tool but the msi did not install the VS2008 Sp1 plug-in.
    I do not see the SqlAzureDataSyncClient in My Templates.
    A search in MSDN returns 0 results as well.
    This tool must be fairly new and not many links to it.
    Could you tell what may be the problem?
     
    SqlAzureDataSyncClient
     
    http://hodentek.blogspot.com/2009/12/synchronizing-with-cloud-database.html
     
    Is there a way to sync with SQL Server CE?
    mysorian
    Friday, December 4, 2009 4:56 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I just installed Sync 2.0, then the SQL Azure Data Sync on a system with VS2008 SP1. I can see the template under "Add New Item", right at the bottom of the list under the "MyTemplates" heading when I'm using a C# Console Application. I do not see it when using a VB Console Application. So, if I had to guess, in no particular order, I'd try:
    1. Make sure the Sync 2.0 pre-req is installed.
    2. Make sure you install SQL Azure Data Sync and choose "For Everyone".
    3. Make sure you look in the right spot, at the bottom of the list, under MyTemplates.
    4. Make sure you have a C# application.

    To sync between SQL Server CE and SQL Server (but not SQL Azure), the item template is called "Local Database Cache" and it appears in C# and VB.

    Hope this helps,
    Bob Beauchemin
    SQLskills
    Friday, December 4, 2009 8:25 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes. Microsoft proved itself partial to C# programmers (kidding). You are dead on.

    Thanks
    mysorian
    Friday, December 4, 2009 8:42 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes the template is for C# only for now :)

    Meanwihle if you want these teamplates to show up on your VS 2010 B2 installs, please try the below:

    1. Make sure you installed the MSI
    2. Copy the vs templates from "%SystemDrive%\Users\%username%\Documents\Visual Studio 2008\Templates\ItemTemplates\Visual C#" to "%SystemDrive%\Users\%username%\Documents\Visual Studio 2010\Templates\ItemTemplates\Visual C#"

    Hope it helps.
    This posting is provided AS IS with no warranties, and confers no rights
    Saturday, December 5, 2009 2:12 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    That worked great on VS2010 B2, THANKS Mahesh!

    Cheers,
    Bob Beauchemin
    SQLskills
    Saturday, December 5, 2009 5:36 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Bob,

    To continue my experiene, I could and did add the client that was missing in the VB.NET. It turned out however it refuses to acknowledge the authentication information and throws an internal exception (server not found) error. I tried several databases to no avail. All these tables were accessible from SSMS.

    Any clues?

    It does comes up with semi ready Serrver name like:
    .windows.database.net

    Since the above did not work, I also tried just the Server name and it did not accept. The connetion failure came back again.

    Would you mind just testing this for me?

    mysorian

    Can this be the reason?
    http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/849bad83-0656-4a8e-b98c-6917c4a5d52f

    Perhaps not, the above is a transport error but what I am getting is a conneciton error.
    Saturday, December 5, 2009 3:55 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi Jayaram,

    On VS2008SP1 running on Windows Server 2003 R2 OS this works fine. And I get sync setup with a local (SQL CE) and an Azure database.

    On VS2010 beta2 running on Windows Server 2008 OS this does not work. I get the same error as you even though the database exists and I can connect to it with SSMS.

    I'm guessing it's the firewall setup that I'm missing, but right now the Azure portal seems to be down and I can't configure the firewall on this machine. More later, if I get it working.

    Cheers,
    Bob
    Saturday, December 5, 2009 10:39 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks. I guess the program has problems on Windows 7 RC Ulitmate/Vs 2008 SP1 combination as the Windows server 2008/Visual Studio 2008 SP1 works ok. I will have to see if someone on my combination has tried. It is some what discouraging working with betas.

    Jay

    http://hodentekl.blogspot.com
    mysorian
    Sunday, December 6, 2009 1:51 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Jayaram, I see that you have a different thread on your problem. We can use that to track your problem and close this thread.

    This posting is provided AS IS with no warranties, and confers no rights
    Monday, December 7, 2009 5:40 AM