Data Migration Survey - Service Provider Questionnaire

1. NB: your personal details and answers will be kept strictly confidential and only used with your explicit permission to contact you in the context of this TM Forum study and iPod Touch prize.

NB: your personal details and answers will be kept strictly confidential and only used with your explicit permission to contact you in the context of this TM Forum study and iPod Touch prize. Name:
Company:
Title:
Email Address:

2. Which of the following factors do you feel make the biggest contribution to success of data migration projects in your company? Please rank your top 3 items.

	1	2	3
Business engagement	Which of the following factors do you feel make the biggest contribution to success of data migration projects in your company? Please rank your top 3 items. Business engagement 1	2	3
Technical expertise in data migration	Technical expertise in data migration 1	2	3
Choice of strategy	Choice of strategy 1	2	3
Knowledge of our data	Knowledge of our data 1	2	3
Data quality	Data quality 1	2	3
Scope change control	Scope change control 1	2	3
Program governance	Program governance 1	2	3
Migration method	Migration method 1	2	3
Migration technology	Migration technology 1	2	3

Other (please specify)

3. Which of the following factors do you feel make the biggest contribution to failure of data migration projects in your company? Please rank your top 3 items.

	1	2	3
Business engagement	Which of the following factors do you feel make the biggest contribution to failure of data migration projects in your company? Please rank your top 3 items. Business engagement 1	2	3
Technical expertise in data migration	Technical expertise in data migration 1	2	3
Choice of strategy	Choice of strategy 1	2	3
Knowledge of our data	Knowledge of our data 1	2	3
Data quality	Data quality 1	2	3
Scope change control	Scope change control 1	2	3
Program governance	Program governance 1	2	3
Migration method	Migration method 1	2	3
Migration technology	Migration technology 1	2	3

Other (please specify)

4. Data migration expertise – how much data migration expertise do you have in your business?

Data migration expertise – how much data migration expertise do you have in your business? None, we use a systems integrator

None, we hire contract staff as required

Some, but we mainly rely on a systems integrator / contract staff

Quite a lot, but we also use a systems integrator / contract staff

A lot, we deliver our own projects

5. Data migration method – your business

Data migration method – your business Does not use a formal method for data migration

Has a method, but does not always use it

Has a method and usually uses it

Always uses a formal method for data migration

6. Service disruption – in general, how important is maintaining your services throughout the duration of a data migration?

Service disruption – in general, how important is maintaining your services throughout the duration of a data migration? Not very - a multi-day outage is acceptable

Quite important - we can only afford some downtime, overnight and weekends

Very important – we can only afford downtime during short periods overnight

Essential / business critical – we cannot afford any downtime - our service is 24/7

7. Please characterize your company’s experience with application data migrations.

	Never	Sometimes	Often	Always
Deliver within the original project timescale	Please characterize your company’s experience with application data migrations. Deliver within the original project timescale Never	Sometimes	Often	Always
Are delivered within budget	Are delivered within budget Never	Sometimes	Often	Always
Deliver the intended business benefits	Deliver the intended business benefits Never	Sometimes	Often	Always

8. For current applications data migrations do you mostly:

For current applications data migrations do you mostly: Use internal development resources to generate migration scripts

Use a 3rd party ETL (Extract, Transform, Load) tool

Use a specialist Real-time data migration software platform

9. Migration approach – when considering a data migration, which of the following strategies has your company employed?

	Have used	Plan to use	Indicate most common approach	Indicate most successful approach
Don’t migrate (Greenfield build)	Migration approach – when considering a data migration, which of the following strategies has your company employed? Don’t migrate (Greenfield build) Have used	Plan to use	Indicate most common approach	Indicate most successful approach
Big bang	Big bang Have used	Plan to use	Indicate most common approach	Indicate most successful approach
Incremental (by business process)	Incremental (by business process) Have used	Plan to use	Indicate most common approach	Indicate most successful approach
Parallel running trickle (zero downtime)	Parallel running trickle (zero downtime) Have used	Plan to use	Indicate most common approach	Indicate most successful approach
Phased migration (by Line of Business/Business Unit or similar)	Phased migration (by Line of Business/Business Unit or similar) Have used	Plan to use	Indicate most common approach	Indicate most successful approach
Initial big-bang plus deltas	Initial big-bang plus deltas Have used	Plan to use	Indicate most common approach	Indicate most successful approach
Other	Other Have used	Plan to use	Indicate most common approach	Indicate most successful approach

10. Migration activities – when running a data migration, please prioritize the following in order of importance to you:

	irrelevant 0	helpful 1	important 2	critical 3
Program governance	Migration activities – when running a data migration, please prioritize the following in order of importance to you: Program governance irrelevant 0	helpful 1	important 2	critical 3
Migration budgeting	Migration budgeting irrelevant 0	helpful 1	important 2	critical 3
Migration planning	Migration planning irrelevant 0	helpful 1	important 2	critical 3
Program initiation	Program initiation irrelevant 0	helpful 1	important 2	critical 3
Orchestration with business processes	Orchestration with business processes irrelevant 0	helpful 1	important 2	critical 3
Data profiling	Data profiling irrelevant 0	helpful 1	important 2	critical 3
Data cleanse	Data cleanse irrelevant 0	helpful 1	important 2	critical 3
Data mapping	Data mapping irrelevant 0	helpful 1	important 2	critical 3
Migration scheduling	Migration scheduling irrelevant 0	helpful 1	important 2	critical 3
Migration dashboards and status	Migration dashboards and status irrelevant 0	helpful 1	important 2	critical 3
Stakeholder reporting	Stakeholder reporting irrelevant 0	helpful 1	important 2	critical 3
Change Data Capture (CDC)	Change Data Capture (CDC) irrelevant 0	helpful 1	important 2	critical 3
Error management	Error management irrelevant 0	helpful 1	important 2	critical 3
Audit trail	Audit trail irrelevant 0	helpful 1	important 2	critical 3
Data Migration software: Flexibility	Data Migration software: Flexibility irrelevant 0	helpful 1	important 2	critical 3
Reliability	Reliability irrelevant 0	helpful 1	important 2	critical 3
Reusability	Reusability irrelevant 0	helpful 1	important 2	critical 3

Others (please specify activity and rank)

11. How well does your current solution support this activity?

	not at all 0	poorly 1	adequately 2	well 3	completely 4
Program governance	How well does your current solution support this activity? Program governance not at all 0	poorly 1	adequately 2	well 3	completely 4
Migration budgeting	Migration budgeting not at all 0	poorly 1	adequately 2	well 3	completely 4
Migration planning	Migration planning not at all 0	poorly 1	adequately 2	well 3	completely 4
Program initiation	Program initiation not at all 0	poorly 1	adequately 2	well 3	completely 4
Orchestration with business processes	Orchestration with business processes not at all 0	poorly 1	adequately 2	well 3	completely 4
Data profiling	Data profiling not at all 0	poorly 1	adequately 2	well 3	completely 4
Data cleanse	Data cleanse not at all 0	poorly 1	adequately 2	well 3	completely 4
Data mapping	Data mapping not at all 0	poorly 1	adequately 2	well 3	completely 4
Migration scheduling	Migration scheduling not at all 0	poorly 1	adequately 2	well 3	completely 4
Migration dashboards and status	Migration dashboards and status not at all 0	poorly 1	adequately 2	well 3	completely 4
Stakeholder reporting	Stakeholder reporting not at all 0	poorly 1	adequately 2	well 3	completely 4
Change Data Capture (CDC)	Change Data Capture (CDC) not at all 0	poorly 1	adequately 2	well 3	completely 4
Error management	Error management not at all 0	poorly 1	adequately 2	well 3	completely 4
Audit trail	Audit trail not at all 0	poorly 1	adequately 2	well 3	completely 4
Data Migration software: Flexibility	Data Migration software: Flexibility not at all 0	poorly 1	adequately 2	well 3	completely 4
Reliability	Reliability not at all 0	poorly 1	adequately 2	well 3	completely 4
Reusability	Reusability not at all 0	poorly 1	adequately 2	well 3	completely 4

Others (please specify activity and rank)

12. Please estimate the number of data migration projects your company executes each year. Please include programs where data migration forms a significant part (>15%) of the total budget.

Please estimate the number of data migration projects your company executes each year. Please include programs where data migration forms a significant part (>15%) of the total budget. None

1-5

6-10

10-20

More than 20

13. What average proportion of IT project budgets would you estimate your company spends on data migration?

What average proportion of IT project budgets would you estimate your company spends on data migration? Less than 15%

15-25%

25-35%

More than 35%

14. Which TM FORUM materials/components has your company made use of in data migration projects?

	Yes	No
Business Process Framework (e-TOM)	Which TM FORUM materials/components has your company made use of in data migration projects? Business Process Framework (e-TOM) Yes	No
Information Framework (SID)	Information Framework (SID) Yes	No
Integration Framework (Business Services [NGOSS Contracts])	Integration Framework (Business Services [NGOSS Contracts]) Yes	No
Application Framework (TAM)	Application Framework (TAM) Yes	No

15. If you have further thoughts and experiences you feel would be relevant to the study, please enter them here or ask us to contact you to discuss further.

If you have further thoughts and experiences you feel would be relevant to the study, please enter them here or ask us to contact you to discuss further.

Thank you for taking the time to complete this survey.

16. Would you like to participate in the TM Forum Data Migration Community to address hot data migration issues?

Would you like to participate in the TM Forum Data Migration Community to address hot data migration issues? Yes

17. Are you happy to be contacted to discuss your answers to this survey further?

Are you happy to be contacted to discuss your answers to this survey further? Yes