Solved

Occassionally connected replacemenr in Visual Studio 2012

Posted on 2013-02-02
5
210 Views
Last Modified: 2013-02-27
I have written and used a program using Visual Studio 2010 that uses a SQLserver 2008 r2 database and SQLCE compact that is occasionally connected.

Consultants in the field can return to their office and exchange data with the main database. It is working very well. There is now talk of using tablets.

 I assume this will mean using Windows 8 and Visual Studio 2012. I have purchased a copy of each of these but I cannot find an equivalent for the Sync framework. It appears that it will be no longer supported.

Can anybody shed a light on this?

I am locked into .Net be cause of various aspects of the program and I know that I can temporarily 'bend' my existing program to work with VS2012 BUT that orphans the program for future development
0
Comment
Question by:milkwood
  • 2
  • 2
5 Comments
 
LVL 18

Expert Comment

by:Gary Davis
ID: 38848881
You might see if you could use something like OneNote instead of using a database. The OneNote file would be on SkyDrive and if the pc is connected, it will sync with the SkyDrive version of the data.

Another possibility is simply using SkyDrive, DropBox, Google Drive (etc) which will sync files when connected.

Finally, check out SqlLite as a SqlCE replacement: http://social.msdn.microsoft.com/Forums/en-US/winappswithcsharp/thread/bc692941-b3d0-4ca0-a243-4ffa2a5d116e

Gary
0
 
LVL 28

Expert Comment

by:Ryan McCauley
ID: 38854819
You can still use SQLCE in newer versions of Windows, and though VS2012 still supports it, the ability to browse it uisng the integrated functionality has been removed. However, it's still a viable option:

http://msdn.microsoft.com/en-us/library/vstudio/aa983341.aspx

Also, there's a codeplex project you might be interested in:

http://sqlcetoolbox.codeplex.com/

It basically adds the functionality back to VS as a third-party add-in and lets you browse and work easily with SQLCE databases in versions of VS that don't have the native tools.
0
 

Accepted Solution

by:
milkwood earned 0 total points
ID: 38866567
OneNote and similiar isn't anywhere near what I want and the 'Cloud' is not an option.

I need to be able selectively sync as I can now.

It looks like I will have continue with what I have designed already. Microsoft have a weird way of 'improving' their products
0
 
LVL 28

Expert Comment

by:Ryan McCauley
ID: 38868127
Why can't you continue to use SQL Compact? if you're using Windows Mobile devices, v3.5 works fine, and you can move to v4 if you're only using x86 devices (as there's no ARM build).
0
 

Author Closing Comment

by:milkwood
ID: 38933235
I have answered my own question
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now