Database Integration

[Migration User]

I want to attempt to integrate two seperate Microsoft SQL Server databases but I got a little lost on the process of achieving this and any insight will be greatly appreciated. I have two database that has our vendor information, the basics (companyID, company name, address, phone etc). I want to have design a solution that reads the information our of one database and place it the other database at some time interval. I understand how to generate the intergration componets but actually putting it together is causing a mental mind block because i don't want to display the information in a form before it integrates as some of the swat training shows. Thanks in advance for any help.

[Migration User]

The simplest scenario could be:

1. Read the data from the source DB using integration components to a primary variable (of the data type corresponding to the source DB).
2. Map/transform the data from primary variable to secondary variable (of the data type corresponding to destination DB) using Single or Multiple Mapping Value components (watch for Match To Existing Value option). These components are flexible and allow for mapping fields using a models and string merging.
3. Store the data from secondary variable to the destination DB using integration components.

 

[Migration User]

Thank you for taking the time out

[Migration User]

And if you do not want to show the data, use a Moitoring Type Project. This is a project that has no user or web components, just processing ones. It works like any other project, it just has no way to display anyting on the screen.

 

Rob