1683385 - SQL Server: Manually exporting and importing DB tables | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1683385 - SQL Server: Manually exporting and importing DB tables

Symptom

  • You want to export a single table from a Microsoft SQL Server database for test purposes
  • You want to export a single table from a Microsoft SQL Server database and then import it again into another database for test 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 support explicitly instructs you to do so.


Read more...

Environment

Microsoft SQL Server

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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