Need advices for mimicking SQL table in folder structure

Vote count:

0

I am working on the implementation of a software that consists in a product database (based MS SQL Express 2012) and sales proposal tool. This software is proprietary, does not offer any API but I can directly access the SQL product database. For all item of my product table, I would like to create a folder with specific structure (datasheet, manual...) on our file server (MS Server 2012).

I intend therefore to use xp_cmdshell in a trigger with a script that would create the corresponding folder structure on the fly (named as per added item).

My knowledge in database and Microsoft tech is limited. Does that seem like a correct way to achieve my goal? Any other way I should consider?

Thanks!

asked 41 secs ago

Gruzlor

1

Need advices for mimicking SQL table in folder structure