ASSURITY LTD

Fixed-Price Data Warehouse Migration to Azure

Assurity will migrate your SQL Server-based data warehouse (data and the business logic) to Azure SQL Database / Managed Instance / Elastic Pool and your SSIS packages to Azure Data Factory, for a fixed-price. We do not push SSIS packages up to ADF! We convert them to ELT.

Features

• Choose to migrate to one of three Azure SQL variants
• We convert all your SSIS packages to ELT
• Migrate existing processing loads to Azure Data Factory
• Price includes the migration of up to two live databases
• Price includes the migration of up to three static databases
• Pricing for additional static (legacy) databases is per database

Benefits

• One low, fixed-price.
• No need to retain SSIS for future package maintenance!

£49,950 a unit

Service documents

• Pricing document

  PDF

• Service definition document

  PDF

• Terms and conditions

  PDF

Request an accessible format

If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at walt@assurity-it.co.uk. Tell them what format you need. It will help if you say what assistive technology you use.

Framework

G-Cloud 14

Service ID

226996579480904

Contact

Walt Barker
07795170652
walt@assurity-it.co.uk

Planning

• Planning service: Yes
• How the planning service works: Assurity have an on-line technical questionnaire to capture details about the clients current environment and needs. The questionnaire can be requested from us at any time and should be completed by the current data warehouse technical lead. We will review your responses and adjust our template project plan accordingly.
• Planning service works with specific services: No

Training

• Training service provided: Yes
• How the training service works: Assurity will document the solution and there will be a handover where you are shown how to maintain the ADF solution and how to connect to the new warehouse from SQL Server Management Studio and other clients (e.g. Power BI). Generic Microsoft product training is for Azure SQL Database and ADF is not included.
• Training is tied to specific services: Yes
• Services the training service works with: Azure

Setup and migration

• Setup or migration service available: Yes
• How the setup or migration service works: Please see the service definition document for full details
• Setup or migration service is for specific cloud services: Yes
• List of supported services: Azure

Quality assurance and performance testing

• Quality assurance and performance testing service: Yes
• How the quality assurance and performance testing works: Assurity's service converts all the existing SSIS packages to ELT. No changes are made to existing stored procedures or views.; ; Assurity will create test scripts to check the record count for each base table in the data load and a check total for one numeric column in each base table. To validate the migration, we propose a parallel data load with the customer running the data load on SQL server and Azure running the data load on Azure and comparing all the check totals. Any additional testing is at the customer’s discretion.

Security testing

• Security services: No

Ongoing support

• Ongoing support service: Yes
• Types of service supported: Hosting or software provided by your organisation
• How the support service works: We will provide phone and email support up until the first successful parallel data load and fix any bugs in our code for 3 months thereafter.

Service scope

• Service constraints: Remote Support.

User support

• Email or online ticketing support: Email or online ticketing
• Support response times: Email support during office hours only.
• User can manage status and priority of support tickets: No
• Phone support: Yes
• Phone support availability: 9 to 5 (UK time), Monday to Friday
• Web chat support: No
• Support levels: We will provide phone and email support up until the first successful parallel data load and fix any bugs in our code for 3 months thereafter.

Resellers

• Supplier type: Not a reseller

Staff security

• Staff security clearance: Staff screening not performed
• Government security clearance: Up to Developed Vetting (DV)

Standards and certifications

• ISO/IEC 27001 certification: No
• ISO 28000:2007 certification: No
• CSA STAR certification: No
• PCI certification: No
• Cyber essentials: Yes
• Cyber essentials plus: No
• Other security certifications: No

Social Value

• Social Value:

  Social Value

  • Fighting climate change
  • Equal opportunity

  Fighting climate change

  Assurity operate a hybrid working model and provide tools for staff to work from anywhere, creating a sustainable balance between working remotely and on client sites.; ; Assurity strive to minimise paper usage, managing and storing documents electronically .; ; We use Microsoft Teams whenever possible for client meetings.; ; Wastepaper is collected separately from the main garbage and recycled.; ; We use recycled toner cartridges.; ; All toner cartridges are recycled via a charitable organisation.

  Equal opportunity

  To attract diverse candidates we commit to posting job adverts with clear qualifications and skill needs whilst avoiding language which might dissuade candidates from minority backgrounds.

Pricing

• Price: £49,950 a unit
• Discount for educational organisations: No

Service documents

• Pricing document

  PDF

• Service definition document

  PDF

• Terms and conditions

  PDF

Request an accessible format

If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at walt@assurity-it.co.uk. Tell them what format you need. It will help if you say what assistive technology you use.