October 17, 2018 at 3:47 am
I'm looking for a script that is as simple as possible but will allow subsequent reimport to the same (but downgraded) box, ie EE 2012 to Dev 2012. Presumably will have to save to file as MSDB will be overwritten in the downgrade.
TIA
October 17, 2018 at 3:57 am
Not sure what you mean here at all, what you've stated doesn't really make sense. Surely, however, you have all of your SSIS packages in a project in SSDT, and that project in source control; so why not simply redeploy them to your new server?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 17, 2018 at 6:23 am
Thom A - Wednesday, October 17, 2018 3:57 AMNot sure what you mean here at all, what you've stated doesn't really make sense. Surely, however, you have all of your SSIS packages in a project in SSDT, and that project in source control; so why not simply redeploy them to your new server?
The requirement is finished now BUT I will take your suggestion in consideration in future.
October 17, 2018 at 2:55 pm
JackCarrington - Wednesday, October 17, 2018 6:23 AMThom A - Wednesday, October 17, 2018 3:57 AMNot sure what you mean here at all, what you've stated doesn't really make sense. Surely, however, you have all of your SSIS packages in a project in SSDT, and that project in source control; so why not simply redeploy them to your new server?The requirement is finished now BUT I will take your suggestion in consideration in future.
It sounds like you are deploying your packages to MSDB - instead of implementing Integration Services Catalog. I would highly recommend that you make the switch to project deployment to the integration services catalog.
You will find that this works much better and has a lot more features and capabilities than your current method.
You can access the catalog through powershell - and create a script that will export all projects from the catalog as well as a script to import the projects to a new destination.
But - most important is the fact that you can restore the SSISDB to the downgraded instance and have everything available.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply