Sql Express to Sql Compact Query
Posted on 2007-10-15
Hello, I'm looking to see if this is possible, and if it is... What the syntax for it is...
I'm syncing between Sql Compact and Sql Express. It is a very simple syncing scenario... Very Very Simple!!!
But what I want is something like this displayed in pseudo:
Update [Sql Compact Database.Table]
Set col1 = ExpressTable.col1,
col2 = ExpressTable.col2,
col3 = ExpressTable.col3
Where ExpressTable.LastModified > SqlCompact.LastModified
As you can see, I have no idea about how to make the connections, and the update statement is no where near syntactically right. I think you can understand what I'm trying to do though.
I want to update all rows on the sql compact side that have been modified on the sql express side.
I think the example for this is probably only about 10 lines of sql long if you know how to do it. I just need to find someone who knows how to do it, and I bet someone here does.