Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Occassionally connected replacemenr in Visual Studio 2012

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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

971 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