Symptom
- You want to export a single table from a Microsoft SQL Server database for testing purpose.
- You want to export a single table from a Microsoft SQL Server database and then import it again into another database for testing purpose.
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 database 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 Technical support explicitly instructs the customers 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."
Read more...
Environment
SAP NetWeaver on Microsoft SQL Server
Keywords
manually, export, import, single table, test, supported, another system, inconsistency, inconsistent data, application entries, bcp, instancename, schema, source, target, overwrite, bulk copy program utility (bcp) , 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.