milkwood
asked on
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
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
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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).
ASKER
I have answered my own question
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