Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

Occassionally connected replacemenr in Visual Studio 2012

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
milkwood
Asked:
milkwood
  • 2
  • 2
1 Solution
 
Gary DavisDir Internet SvcsCommented:
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
 
Ryan McCauleyData and Analytics ManagerCommented:
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
 
milkwoodAuthor Commented:
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
 
Ryan McCauleyData and Analytics ManagerCommented:
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
 
milkwoodAuthor Commented:
I have answered my own question
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now