Using XML configuration files does not require the opening and modification of any component package. Configuring the designation of source and destination databases can be implemented with XML configuration files. SQL Server Integration Services (SSIS) is an ideal product for performing the above-described data migrations because once packages are created that correctly populate a single destination database from its associated source database, the packages should work without modification when configured to point to a different source database and a different destination database. Virtually all well-designed databases have many such relationships. Tables which have foreign keys dependent upon primary or unique keys of other tables must be loaded after the tables upon which they are dependent. The order that tables are loaded is important. There were about one hundred tables in each of the destination databases. The sources of the data would be several databases that had their own identical schemas, but this was different than the schema of the destination databases. Recently I was assigned the task of populating several databases that have identical schemas.
0 Comments
Leave a Reply. |