OK,I got a question if the following is possible or improvable.
Currently we have a job that transfers out the entire object setup of a database (not the data) from our staging environment to our dev environment,about once every 2 months.
Now the job clunky & failure prone,so my department head I had a look & wanted me to look if its possible to use an
ssis package instead.
OK so I found out Transfer SQL Server Object Task can do that & I tested that works like a charm,now comes the fun part,only objects that have changed or have been created should be transferred over,now that next transfer isn't planned for another 6 weeks,but I'm putting this here on day 1 so I have somewhere to look as well + put potential solutions I find