1

I just want to export SQL Query of the SmartLists for backing up and transfer to other system. Is any way to do so?

Richard Sayakanit
  • 695
  • 6
  • 12
  • What version of GP? If I am not mistaken, some of the newer releases have an Import/Export feature for SL. In older versions, IIRC they are in the DYNAMICS database under ASI tables. They may not be easy to migrate through SQL though. – Jacob H Nov 20 '17 at 20:12
  • I have GP 2016 Version. I see that Export/Import to XML. It looks like exporting data but I want "SELECT * FROM ..." statement. Thanks. – Richard Sayakanit Jan 18 '18 at 18:15

1 Answers1

0

In GP2018, you can select a given SmartList and then select "Options - Display SQL...". From there, you can just copy/paste the SQL to wherever you need it to be.

I'm also trying to reverse engineer SQL from the Dynamics tables, but I haven't got far on that endeavor yet.

ManoDestra
  • 6,325
  • 6
  • 26
  • 50