The MSS database driver creates the stored procedure as part of the create table scripts. At this moment there is no straight forward way to just generate the scripts for creating the stored procedures. You therefore have to use option 2: "generate the entire DB creation scripts, and then edit out the table creates".
There might be a way to automate the edit out of the table creates: if you generate two create table script files, one with procs:on and one with procs:off then you could create a patch file with a compare tool like e.g. WinMerge and delete the extra markup like described here. Just an idea.
I hope this helps.
Regards,
Daniel
------------------------------
Daniel Iseli
Rocket Internal - All Brands
Geneva Switzerland
------------------------------
Original Message:
Sent: 10-20-2021 10:18
From: Iain Sharp
Subject: Switching to procs:on
#uniface-10
So, if I have a mature database, and I want to look at using the procs:on setting in the driver (MSS), is there any way of generating just the procs creation scripts? Or do I have to generate the entire DB creation scripts, and then edit out the table creates?
Regards,
Iain
------------------------------
Iain Sharp
Head of Technical Services
Pci Systems Ltd
Sheffield United Kingdom
------------------------------