March 7, 2018 at 8:20 am
I am working on a tricky project where I do not have any access to the current systems. As a matter of fact, we have Integration Services, Reporting services as well as Analysis services part of the existing system.
There are about 300+ SSIS packages, about 400+ SSRS reports and about 5 odd Multidimensional cubes.
I need to think on the lines of moving these onpremise items to the Azure. I am yet to figure out how I would do it but to even understand whats running today, are there any means/scripts to figureout how things are configured today.
Pls understand that I dont have access to the systems 🙂
It would help immensely if these scripts can help me in giving a thought in the Azure implementation of these services.
March 7, 2018 at 2:38 pm
Benki Chendu - Wednesday, March 7, 2018 8:20 AMI am working on a tricky project where I do not have any access to the current systems. As a matter of fact, we have Integration Services, Reporting services as well as Analysis services part of the existing system.
There are about 300+ SSIS packages, about 400+ SSRS reports and about 5 odd Multidimensional cubes.
I need to think on the lines of moving these onpremise items to the Azure. I am yet to figure out how I would do it but to even understand whats running today, are there any means/scripts to figureout how things are configured today.
Pls understand that I dont have access to the systems 🙂It would help immensely if these scripts can help me in giving a thought in the Azure implementation of these services.
It all sounds a bit odd but maybe I'm missing something. How are you going to run scripts if you don't have access to any of the systems? Is someone going to run them for you and if so, do you know what information you need? Are you the one who will be moving all of these or are you expected to come up with a plan to move them and deliver it to someone else? I feel bad for you already...
Sue
March 8, 2018 at 8:09 am
Sue_H - Wednesday, March 7, 2018 2:38 PMBenki Chendu - Wednesday, March 7, 2018 8:20 AMI am working on a tricky project where I do not have any access to the current systems. As a matter of fact, we have Integration Services, Reporting services as well as Analysis services part of the existing system.
There are about 300+ SSIS packages, about 400+ SSRS reports and about 5 odd Multidimensional cubes.
I need to think on the lines of moving these onpremise items to the Azure. I am yet to figure out how I would do it but to even understand whats running today, are there any means/scripts to figureout how things are configured today.
Pls understand that I dont have access to the systems 🙂It would help immensely if these scripts can help me in giving a thought in the Azure implementation of these services.
It all sounds a bit odd but maybe I'm missing something. How are you going to run scripts if you don't have access to any of the systems? Is someone going to run them for you and if so, do you know what information you need? Are you the one who will be moving all of these or are you expected to come up with a plan to move them and deliver it to someone else? I feel bad for you already...
Sue
I don;t just feel bad for them, Sue... This kind of question suggests rather strongly that they are not properly qualified to do that piece of work in the first place..
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 8, 2018 at 8:28 am
sgmunson - Thursday, March 8, 2018 8:09 AMSue_H - Wednesday, March 7, 2018 2:38 PMBenki Chendu - Wednesday, March 7, 2018 8:20 AMI am working on a tricky project where I do not have any access to the current systems. As a matter of fact, we have Integration Services, Reporting services as well as Analysis services part of the existing system.
There are about 300+ SSIS packages, about 400+ SSRS reports and about 5 odd Multidimensional cubes.
I need to think on the lines of moving these onpremise items to the Azure. I am yet to figure out how I would do it but to even understand whats running today, are there any means/scripts to figureout how things are configured today.
Pls understand that I dont have access to the systems 🙂It would help immensely if these scripts can help me in giving a thought in the Azure implementation of these services.
It all sounds a bit odd but maybe I'm missing something. How are you going to run scripts if you don't have access to any of the systems? Is someone going to run them for you and if so, do you know what information you need? Are you the one who will be moving all of these or are you expected to come up with a plan to move them and deliver it to someone else? I feel bad for you already...
Sue
I don;t just feel bad for them, Sue... This kind of question suggests rather strongly that they are not properly qualified to do that piece of work in the first place..
It all sounds a bit odd but maybe I'm missing something.
How are you going to run scripts if you don't have access to any of the systems?
Is someone going to run them for you and if so, do you know what information you need? - This is correct. Someone is going to run it.
Are you the one who will be moving all of these or are you expected to come up with a plan to move them and deliver it to someone else? I feel bad for you already... - Yes at a later point of time
March 8, 2018 at 9:02 am
Benki Chendu - Thursday, March 8, 2018 8:28 AMsgmunson - Thursday, March 8, 2018 8:09 AMSue_H - Wednesday, March 7, 2018 2:38 PMBenki Chendu - Wednesday, March 7, 2018 8:20 AMI am working on a tricky project where I do not have any access to the current systems. As a matter of fact, we have Integration Services, Reporting services as well as Analysis services part of the existing system.
There are about 300+ SSIS packages, about 400+ SSRS reports and about 5 odd Multidimensional cubes.
I need to think on the lines of moving these onpremise items to the Azure. I am yet to figure out how I would do it but to even understand whats running today, are there any means/scripts to figureout how things are configured today.
Pls understand that I dont have access to the systems 🙂It would help immensely if these scripts can help me in giving a thought in the Azure implementation of these services.
It all sounds a bit odd but maybe I'm missing something. How are you going to run scripts if you don't have access to any of the systems? Is someone going to run them for you and if so, do you know what information you need? Are you the one who will be moving all of these or are you expected to come up with a plan to move them and deliver it to someone else? I feel bad for you already...
Sue
I don;t just feel bad for them, Sue... This kind of question suggests rather strongly that they are not properly qualified to do that piece of work in the first place..
It all sounds a bit odd but maybe I'm missing something.
How are you going to run scripts if you don't have access to any of the systems?
Is someone going to run them for you and if so, do you know what information you need? - This is correct. Someone is going to run it.
Are you the one who will be moving all of these or are you expected to come up with a plan to move them and deliver it to someone else? I feel bad for you already... - Yes at a later point of time
And now I have proof...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 8, 2018 at 11:56 am
Benki Chendu - Thursday, March 8, 2018 8:28 AMIt all sounds a bit odd but maybe I'm missing something.
How are you going to run scripts if you don't have access to any of the systems?
Is someone going to run them for you and if so, do you know what information you need? - This is correct. Someone is going to run it.
Are you the one who will be moving all of these or are you expected to come up with a plan to move them and deliver it to someone else? I feel bad for you already... - Yes at a later point of time
As for how everything runs today, you would need identify what information you need that would impact migrating. It's just seems too broad at this point - unknown versions, package storage and usage, how you plan to upgrade reports, hardware/OS changes, etc.
In terms of deployment settings, that seems like something you need to figure out based upon what and how you deploy based on business needs, versions. There are hundreds of questions you need to ask the business. Maybe sit down and come up with all the questions to ask the business and come up with a list of things you need to know about each component and work on your scripts from there.
Sue
March 8, 2018 at 12:09 pm
Sue_H - Thursday, March 8, 2018 11:56 AMBenki Chendu - Thursday, March 8, 2018 8:28 AMIt all sounds a bit odd but maybe I'm missing something.
How are you going to run scripts if you don't have access to any of the systems?
Is someone going to run them for you and if so, do you know what information you need? - This is correct. Someone is going to run it.
Are you the one who will be moving all of these or are you expected to come up with a plan to move them and deliver it to someone else? I feel bad for you already... - Yes at a later point of timeAs for how everything runs today, you would need identify what information you need that would impact migrating. It's just seems too broad at this point - unknown versions, package storage and usage, how you plan to upgrade reports, hardware/OS changes, etc.
In terms of deployment settings, that seems like something you need to figure out based upon what and how you deploy based on business needs, versions. There are hundreds of questions you need to ask the business. Maybe sit down and come up with all the questions to ask the business and come up with a list of things you need to know about each component and work on your scripts from there.Sue
Thanks Sue. Is there one such checklist/List of questions?
I have tried to ask how much I could.but certainly need some help more
March 8, 2018 at 1:35 pm
Benki Chendu - Thursday, March 8, 2018 12:09 PMSue_H - Thursday, March 8, 2018 11:56 AMBenki Chendu - Thursday, March 8, 2018 8:28 AMIt all sounds a bit odd but maybe I'm missing something.
How are you going to run scripts if you don't have access to any of the systems?
Is someone going to run them for you and if so, do you know what information you need? - This is correct. Someone is going to run it.
Are you the one who will be moving all of these or are you expected to come up with a plan to move them and deliver it to someone else? I feel bad for you already... - Yes at a later point of timeAs for how everything runs today, you would need identify what information you need that would impact migrating. It's just seems too broad at this point - unknown versions, package storage and usage, how you plan to upgrade reports, hardware/OS changes, etc.
In terms of deployment settings, that seems like something you need to figure out based upon what and how you deploy based on business needs, versions. There are hundreds of questions you need to ask the business. Maybe sit down and come up with all the questions to ask the business and come up with a list of things you need to know about each component and work on your scripts from there.Sue
Thanks Sue. Is there one such checklist/List of questions?
I have tried to ask how much I could.but certainly need some help more
There are some checklists out there on blogs and such but there is no one size fits all. Every environment is different. I've had different upgrade processes when working at the same company. You need to ask for specifics on how and what different pieces are used such as asking what the different packages do. Those are more complex due to some of the dependencies. Where to get information on the packages depend on how they use SSIS in terms of storage - on disk, in msdb, ssisdb, etc. If they have any developers or source control, you can probably access rdl and dtsx files as well as various SSAS files (database, cube, ds). Those will give you some information in XML.
But you will be the one coming up with questions to ask - do you know how they store or execute packages now? What do they do with maintenance? How do they manage access control? Some ideas around checklists and links to those:
The Migration Checklist
SQL Server Migration Plan
SQL Server Database Migration Checklist
There are quite a few like that if you search on SQL Server migration checklist.
Any action item is something you need to know about so just start asking them questions related to that. For example, all the checklists will mention backups so you would want to know how they do those for all of those components - do they schedule them, do they use SQL jobs, do they use third party products, where are things backed up to, etc. So the migration checklists would drive the questions you ask them.
Sue
March 8, 2018 at 6:23 pm
Thanks a lot Sue..
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply