<div>
Is this a 1 time thing or is this to happen on a regular basis?
</div>


Is this a 1 time thing or is this to happen on a regular basis?

<div>
Can you create one or more views in the original database that select the desired data?<br />
<br />
If so, you can use the Import/Export wizard to import the data from the <u>views</u> into your target database.
</div>


Can you create one or more views in the original database that select the desired data?

If so, you can use the Import/Export wizard to import the data from the views into your target database.

<div>
So we need to create 15 views right?
</div>


<div>
I've requested that this question be deleted for the following reason:<br />
<br />
Didn't get the answer so closing the ticket
</div>


I've requested that this question be deleted for the following reason:

Didn't get the answer so closing the ticket

<div>
<div class="content wysiwyg-content">
My problem:<br />
<br />
I have 10 database which holds 15 tables,<br />
One table has application Name and will be linked across 15 tables through Foreign Key or with application name itself.<br />
There are multiple applications present in one database.<br />
Now I want copy only few application's along with all it's relevant data from each of the database and like to club it all together in one database.<br />
<br />
How to do it?
</div>
</div>


My problem:

I have 10 database which holds 15 tables,
One table has application Name and will be linked across 15 tables through Foreign Key or with application name itself.
There are multiple applications present in one database.
Now I want copy only few application's along with all it's relevant data from each of the database and like to club it all together in one database.

How to do it?

Need a sample SSIS package

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.