IBM Support

How to copy SQL table (for example XSTAGEFACT) from source database to target (different) database



Customer would like to perform some testing (using a test database). As part of this, they would like to copy some information from their production (source) database into their test (target) database. - Specifically, they only want to copy a specific database table. Example: Customer would like to test 'import from staging tables' functionality. - For this they would like to copy over the table 'XSTAGEFACT'. How can they copy over a database table (from the source to target SQL database)?




There are many different methods to export data from source to target Controller database.

  • TIP: The most popular method is explained inside separate IBM Technote #1372672.

This Technote is specifically related to the rare scenario where only a single database table is needed.

  • Most likely, this might be for testing import from staging tables (which requires the data to reside inside the table 'XSTAGEFACT')


Microsoft SQL.

Resolving The Problem

There are many possible methods to copy data from source to target database.

  • This Technote demonstrates how to use SQL Server Management Studio to use the 'Import and Export Wizard'


The following example is based on Microsoft SQL 2016:

1. Logon to the source SQL server

2. Launch SQL Server Management Studio

3. Right-click on the 'source' database

4. Click "Tasks - Export Data":


Click Next

5. Choose "SQL Server Native Client 11.0" as your data source:

6. Ensure that your servername, authentication and database name are correct.

7. Choose destination: Flat File Destination
8. Enter a suitable file path/name, for example: C:\UTILS\Globe_XSTAGEFACT_demo.txt

9. Click Next, then Next
10. Choose the relevant table, for example: [fastnet].[xstagefact]

11. Click "Next", "Next", "Finish".

You should get a success message similar to:


12. Logon to the target SQL server

13. Launch SQL Server Management Studio

14. Right-click on the 'target' database

15. Click "Tasks - Import Data"

16. Click Next

17. Choose "Flat File Source"

  • Fill in the other relevant sections, for example:

18. Click Next.

19. Choose "SQL Server Native Client 11.0" as your destination:
20. Choose the correct destination server, authentication and database
    - For example:

21. Check that the source/destination mappings look correct, for example:

22. Click Next, Next, Finish.

You should get a success message similar to:

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number


Document Information

Modified date:
15 June 2018