You can use DSA to copy partial data from a table or view using a source staging table. Specify where to create the source staging table by specifying a source staging database.
Staging Database Name | Staging Database Name Result |
---|---|
Not provided at the table or database level | Created in the source database of the source tables. |
Provided at the database level | Created under the specified staging database on the source system, unless overridden at the table level. |
Provided at the table level | Are created under the specified staging database on the source system, even if a different staging database name is provided. |