Not Sure If I Can Use SQLCompact Edition

[paulthepaddy]

i was reading a post and i dont remember where exactly it was, but the guy was talking about using the Sync Framework and the local Db Caching.

But JMC then continued to say 4GB Database As Local Caching I Think NOT(or something very simlar)

i am guessing this is a big no no, so was looking about google and found out about SQL Lite, BUT i cant find much on using SQLLite and Syncing it to MSSQLServer2012 :S is this impossable or do i just have to dig deeper to find the info ?

 

[jmcilhinney]

I don't recall the comment you're talking about but I will admit that I have never actually used the Sync Framework so I don't know all the details and implications. If you're going to cache locally then you need as much data as you need so it doesn't really matter which database you use from that point of view. If I was thinking of using the Sync Framework myself then I would do an appropriate amount of reading beforehand and I suggest that you do the same. It probably wouldn't take long for you to have greater knowledge on the subject than me.