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