cancel
Showing results for 
Search instead for 
Did you mean: 

Export Table in MS SQL 2005

Former Member
0 Kudos

Hello All,

I have ECC 6.0 / Windows 2008 / MS SQL 2005 DB, I am doing refresh from PRD to QAS, Please let me know how to export RFC's or how to export RFCDES table using sql command or is there any way in MS SQL to export one table. I know how to do it in Oracle.

Appreciate for your reply.

Thanks

AI-

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

One option would be to add the RFCDES table to a transport and pull that transport back in after the refresh from PRD is done.

Hope that helps.

J. Haynes

markus_doehr2
Active Contributor
0 Kudos

You can use the database independent way by using an R3trans control file:

Note 130906 - How can versions be transported?

Put in the table names you want to backup and restore.

Markus

Sriram2009
Active Contributor
0 Kudos

Hi Atul

If you want to do the PRD to QAS you have to use the heterogeneous system copy method( export & import method) during that time all the table will be export from MS Sql to QAS Oracle DB.

why you want to do the export RFC tables ?

Regards

S

Former Member
0 Kudos

Hello,

Please reply my question.

Thanks

Atul-

Former Member