SAP Knowledge Base Article - Preview

1683385 - SQL Server: Manually exporting and importing DB tables


  • You want to export a single table from a Microsoft SQL Server database for testing purposes.
  • You want to export a single table from a Microsoft SQL Server database and then import it again into another database for testing purposes.

Please note that it is not supported by SAP to export a table from the database of one SAP system and import it into the database of another SAP system to rule out certain problems like e.g. inconsistencies. As the entries of a table are in almost all cases related to entries of other tables, exporting and importing a single table will very likely lead to inconsistent data from the application point of view! For this reason such an action must not be carried out unless SAP Product support explicitly instructs you to do so.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."



Microsoft SQL Server


manually, export, import, single table, test, supported, another system, inconsistency, inconsistent data, application entries, bcp, instancename, schema, source, target, overwrite , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.