how to execute crexport with sql script shell

[harshitjain1]

using command EXEC master..xp_cmdshell

[mhertzfeld]

I have never tried running ninja with a sql script.

From what I am reading in the link below, it shouldn't be much different than calling through the normal command line. I would suggest getting it working through the command line then once you have a working command copy and paste it into you SQL script. Also, pay attention to the user account that will be executing the sql script and make sure that all the necessary permissions are granted.

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/xp-cmdshell-transact-sql?view=sql-server-ver15

[aj1432]

Please share example SQL Query Step by step