SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Check the configuration and deployment settings for SSIS, SSRS and SSAS


Check the configuration and deployment settings for SSIS, SSRS and SSAS

Author
Message
Benki Chendu
Benki Chendu
SSCertifiable
SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)

Group: General Forum Members
Points: 7173 Visits: 547
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 Smile

It would help immensely if these scripts can help me in giving a thought in the Azure implementation of these services.

Sue_H
Sue_H
SSC Guru
SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)

Group: General Forum Members
Points: 69789 Visits: 14511
Benki Chendu - Wednesday, March 7, 2018 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 Smile

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



sgmunson
sgmunson
SSC Guru
SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)

Group: General Forum Members
Points: 89991 Visits: 6932
Sue_H - Wednesday, March 7, 2018 2:38 PM
Benki Chendu - Wednesday, March 7, 2018 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 Smile

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)
Smile Smile Smile
Health & Nutrition
Benki Chendu
Benki Chendu
SSCertifiable
SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)

Group: General Forum Members
Points: 7173 Visits: 547
sgmunson - Thursday, March 8, 2018 8:09 AM
Sue_H - Wednesday, March 7, 2018 2:38 PM
Benki Chendu - Wednesday, March 7, 2018 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 Smile

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
sgmunson
sgmunson
SSC Guru
SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)

Group: General Forum Members
Points: 89991 Visits: 6932
Benki Chendu - Thursday, March 8, 2018 8:28 AM
sgmunson - Thursday, March 8, 2018 8:09 AM
Sue_H - Wednesday, March 7, 2018 2:38 PM
Benki Chendu - Wednesday, March 7, 2018 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 Smile

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)
Smile Smile Smile
Health & Nutrition
Sue_H
Sue_H
SSC Guru
SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)

Group: General Forum Members
Points: 69789 Visits: 14511
Benki Chendu - Thursday, March 8, 2018 8:28 AM


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


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



Benki Chendu
Benki Chendu
SSCertifiable
SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)

Group: General Forum Members
Points: 7173 Visits: 547
Sue_H - Thursday, March 8, 2018 11:56 AM
Benki Chendu - Thursday, March 8, 2018 8:28 AM


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


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


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
Sue_H
Sue_H
SSC Guru
SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)SSC Guru (69K reputation)

Group: General Forum Members
Points: 69789 Visits: 14511
Benki Chendu - Thursday, March 8, 2018 12:09 PM
Sue_H - Thursday, March 8, 2018 11:56 AM
Benki Chendu - Thursday, March 8, 2018 8:28 AM


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


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


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



Benki Chendu
Benki Chendu
SSCertifiable
SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)

Group: General Forum Members
Points: 7173 Visits: 547
Thanks a lot Sue..
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search