deployment file system Vs server

Question

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Mike John SSCertifiable Points: 7216 More actions · Answer 1

Can you elaborate a little? Specifically WHAT are you deploying.

You could be refering to pros/cons of storing images in SQL server or file system, or SSIS packages, or I suspect manyother things.

Mike

prudhivi9 Say Hey Kid Points: 678 More actions · Answer 2

Mike,

I am having so many packages in my system like sales_report.dtsx, purchase_report.dtsx... like that

i am having nearly 20 packages. some of them are in server side i.e msdb level.

some of them are in file system.

so my lead wanted to move all the packages to one of them either file system or msdb level.

so we need to know all the advantages and disadvantages , if we move packages to msdb level or file system.

Thanks,

pcsb

Mr. Holio Hall of Fame Points: 3328 More actions · Answer 3

__________________________
Allzu viel ist ungesund...