CODEWITHSUNDEEP
sql-servermicrosoft-sync-framework
Harshil Sheth
Harshil Sheth

Reputation: 1

Microsoft Sync Framework 2.1 Invalid Column Name Error

I have developed an application to sync mssql database. It was working properly until my server database schema changed. after that i am having "Invalid Column Name" SqlException error. If i delete both client and server database than sync application works properly.

So please guide me to solve this issue.

Thank you.

Upvotes: 0

Views: 776

Answers (2)

Pepedou
Pepedou

Reputation: 829

You have to deprovision your database and provision it again with the new schema.

Upvotes: 0

JuneT
JuneT

Reputation: 7860

Sync Framework doesn't handle schema changes automatically. if you used the GetDescriptionForTable to provision, it takes the column definition at that point in time. if you alter the schema, then the scope definition is out of sync with the actual table schema.

Upvotes: 1

Related Questions