So, you want to migrate SSIS(DB)?

Excellent! I wanted to, and after few trials and errors I finally did! And it’s pretty easy (as with all things you know when you learn it). For a start I will warn you a bit – SSISDB isn’t the database you just backup on one server and restore on another. There are some more steps to do. The same procedure will work for migrations from version 2012 to 2017 or 2016 to 2017, I didn’t check (yet) 2014 to 2017. I also tested the migration of 2012 to 2016 version but had some problems with this when it came to upgrading database part. Will investigate it later (probably some

Share
Continue reading »

Connect to SQL Server on Ubuntu Linux VirtualBox machine

For my everyday tests with SQL Server I use VirtualBox. SQL Server 2017 is/will be a huge thing – mostly because it will be available on Linux. If so – I should get comfortable with using it on Linux. I start with Ubuntu Server (because of the name – I used Ubuntu Desktop in the past), Installation of VM on VirtualBox comes down to adding ISO image as the CD-ROM (DVD-ROM?) and selecting almost only the default options. I don’t want to build a cluster or do sophisticated things – I just want the Linux Server to be up and running.

Share
Continue reading »