See JuneT's post:įor this particular situation, I think you'd be best served by creating Person and Address on Second DB, then creating "Customer" as a view (also on Second DB) to present the two tables in a consolidated manner. You can sync between tables with the same schema but different names using the GlobalName property of the DbSyncTableDescription. Until now I developed some examples about common scenarios, like different table names, different column names or the removing of columns.Īs far as I can tell from the documentation, the Schema's need to match for the Sync to work. How can I perform the provisioning of dbs and the synchronization? I designed these dbs for exercitation (the EQUI JOIN is between PERSON.AddressId and ADDRESS.Id): I would like to sync a single table with the result of a Join between 2 tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |