Improve company productivity with a Business Account.Sign Up

x
?
Solved

Occassionally connected replacemenr in Visual Studio 2012

Posted on 2013-02-02
5
Medium Priority
?
229 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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

585 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