We have a normalized SQL Server 2008 database designed using common tables. Thus, instead of a separate table for each object (for example, Products, Orders, OrderItems, etc.), we have common tables (Entities, Instances, Relationships, Attributes, etc.).
We decided to create a separate denormalized database for quick data extraction. Could you advise me on different technologies for synchronizing these two databases, assuming that they have different schemes?
Cheers, Mosh
, , . SQL Server : SSIS Replication, script .
. , , . . , "" , 4 . , . , , .
SSIS , . , . , . , , ( ). , Product, Product related Attribute, .
, , .
, , , . , , , . .
, SQL Server 2008, , .
Source: https://habr.com/ru/post/1754360/More articles:Troubleshoot locking issues while calling multiple methods in a WCF service from Silverlight - asp.netHow to remove the close button in a dialog box? - jquery-uiExtract address / contact information from text block with name and address? - javaCQRS: Writing and Reading Databases Synchronization - cqrshow can we run a python script (which uses nltk and scrapy) from java - javaWhat version of Ruby for Watir on Windows? - windowsHow to format comments in C ++? - c ++Subdirectory on another host - redirectShredding MySQL strings - mysqlUsing MKMapView with kml files - iphoneAll Articles