sap data import and export

[Former Member]

Hi Experts

can we import and export the data of SAP ides system into word,excel or text format .And same can we upload it to an SQL server ?

Thanks

Shambuling Kulkarni 

[manukapur]

There are lot of ways to do that.

What exactly are you trying to do?  Let me know your requirements. Will tell you the most appropriate one.

Regards,

Manu

[Former Member]

Hi manu

Thanks for reply

i am trying to download the SAP ides system data into Excel,word or text document and upload that data into SQL server\ database.

Is this the proper way to migrate the SAP Data to SQL database or there are any other option do the same .. 

Thanks

Shambuling

[manukapur]

If its for a small amount of data and limited data, you can download the table records into excel / text files or use function modules and write abap programs.

but if it something which is huge  I suggest you use database migration techniques.

Regards,

Manu

[Former Member]

Hi Manu

Thanks for reply .

how i can perform the database migration . what are the techniques .

actually we have downloaded the sap data using R\3 load and now it is saved in the hard drive

whether we directly upload that data into SQL or we must upload that data to SAP and then we can migrate it to the SQL database .

Thanks

Shambuling

[manukapur]

Hi Sambuling,

If you have already downloaded the data in certain format, then you can use the import functionality of the SQL Server to import data onto it.

If there is a large volume of data, and you have to do more periodic, I suggest use SAP DataServices to do the Migration.

Regards,

Manu

[former_member188827]

Check Functional module "GUI_DOWNLOAD" for downloading data.

[Former Member]

This message was moderated.

[arindam_m]

Hi,

You can certainly export and import data from SAP. You can do it in programs using various FM also if you just want to download in local file you can also do that. About uploading to SQL server you might need programs in SAP or SQL clients to achieve the same. If you can be more specific I can suggest the exact ones that you can use.

Cheers,

Arindam

[Former Member]

hi Arindam

Actually we have downloaded the sap data using R\3 load and now it is saved in the hard drive

whether we directly upload that data into SQL or we must upload that data to SAP and then we can migrate it to the SQL database .

Thanks

Shambuling

[matt]

Why can you not do a system copy/database migration? The volume of data is way to high to sensibly do this task by uploading and downloading.