How to Backup Querys

[Former Member]

Hi Experts

I will thankfull if somebody tell me how can I made a backup of querys (there are more than 500)

Thank you in advance

[Former Member · Accepted solution]

There is no standard process for query back up. If you are doing a conversion from 3.X to 2004s the queries can be backed up as per OSS note 949330.

WHy do you need to back up queries>?

[Former Member · Accepted solution]

Is not an Upgrade.

Now we are in a 'model re-design' fase, and the querys are being changed.

They are complex query, and we are very afraid about lost the original query, because this is the only one ok.

How can I do?

[Former Member]

closed

[Former Member]

Hi,

you can export your queries definitions in an XML export. You'll have to test this with one query.

another alternative is to collect your queries in a transport with a grouping mode of system copy. Release this transport before changing your queries. Test this scenario as well.

Anyway, if you pack all your queries in ONE tp, you won't be able to reimport only one...

The best would be to move them to another system. You could even think of a system copy if you really want to keep a safe backup...

hope this helps,

Olivier

[Former Member]

I don't think we have such feature. You can take back up of Web Template not Bex Queries.

I'm not sure about it. You need to make a copy of it. and work on it. I know it's really tough job.

Nagesh Ganisetti.

[Former Member]

Or, transport them to some other system till the new model if tested and rolled off.

Ravi Thothadri

[Former Member]

You can copy these queries and save them in different name. Once the new design is tested and rolled off, you can delete these queries.

Ravi Thothadri