Solved

Occassionally connected replacemenr in Visual Studio 2012

Posted on 2013-02-02
5
212 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

919 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

22 Experts available now in Live!

Get 1:1 Help Now