--- title: Version 6.0 - SQL Server to SQLite Migration Process (Optional) description: "Note: This is not a mandatory process" --- [Skip to content](https://help.intuitivebusinessintelligence.com/v6.0-sql-server-to-sqlite-migration-process#main-content) English Show submenu for translations ![Intuitive logo RGB-1.png\]](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20RGB-1.png?height=40&name=Intuitive%20logo%20RGB-1.png) Open main navigation Close main navigation - English Show submenu for translations - [Go to weareintuitive.com](https://weareintuitive.com/) [Go to weareintuitive.com](https://weareintuitive.com/) Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Help Center](https://help.intuitivebusinessintelligence.com/?hsLang=en) 2. [Intuitive Dashboards Core Software](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en) 3. [Version History](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#version-history) # Version 6.0 - SQL Server to SQLite Migration Process (Optional) ## Note: This is not a mandatory process **Introduction** Intuitive [V6.0](https://help.intuitivebusinessintelligence.com/v6.0-due-april-2021?hsLang=en) introduces the option to install Intuitive dashboards under [SQLite](https://www.sqlite.org/index.html) rather than SQL Server. For fresh implementations, it is just a matter of selecting the preferred database at install time. For upgrades, where an existing implementation uses SQL Server most sites will continue to use SQL Server as their underlying dashboard database when they upgrade to V6.0. Some sites may choose to migrate their installation from SQL Server to SQLite. This process uses the *intuitive ETL Service* to read the existing data from the existing SQL Server dashboard database and write the data to the SQLite dashboard database. This article details the migration process that needs to be followed to achieve this. **Note**: This work should only be undertaken by your intuitive dashboard server system administrator.  The process is not destructive, so your original SQL Server dashboard database will not be removed or altered in any way, but you are still advised to take system [backups](https://help.intuitivebusinessintelligence.com/upgrading-your-system-good-practice?hsLang=en) prior to performing this process. ### Migration process: 1. Firstly, take a backup of your existing intuitive SQL Server implementation. 2. Now upgrade your existing SQL Server installation to V6.0. in the standard way (**Note**: do **not** choose the SQLite installation option). 3. Now run the V6.0 installation again, but this time select SQLite as the installation database, which will create a 'clean' SQLite database. Call the SQLite database ‘dashboard.db’ and ensure that it’s located in the intuitive dashboards folder (normally *C:\\Program Files\\Intuitive Business Intelligence\\Intuitive Dashboards*). **Note**: If another location/name is chosen then the ETL configuration file provided (See below: *ETLService.Migrate.config*) will need to be edited to reflect this. 4. Setup a System ODBC connection to the existing SQL Server dashboard database called ‘dashboard\_odbc’. This will enable the ETL process to read the existing SQL Server tables. ![](https://help.intuitivebusinessintelligence.com/hubfs/image-png-Apr-13-2021-10-35-36-00-AM.png) 5. The V6.0 installation includes an ETL configuration file 'ETLService.Migrate.config' found in  the ETL service folder (Normally *C:\\Program Files\\Intuitive Business Intelligence\\Intuitive Dashboards\\Tools\\ETL Service*)  This contains the full list of tables to 'copy' from the SQL Server database to the target SQLite database. 6. Make a backup copy of the standard 'ETLService.config' file calling it 'ETLService - Copy.config' so you can restore this file later if required. 7. Now copy/rename the *ETLService.Migrate.config* to *ETLService.config* 8. Now run the ETL Service executable to perform the data migration. To do this, in the '*C:\\Program Files\\Intuitive Business Intelligence\\Intuitive Dashboards\\Tools\\ETL Service*' folder right click on ‘*ETLService.Console.exe*’ and select *run as Administrator*. 9. This will now perform the migration of the data from SQL Server to SQLite. You should observe similar in the ETL Service console window: ![Image preview](https://attachments.office.net/owa/martin.cross%40weareintuitive.com/service.svc/s/GetAttachmentThumbnail?id=AAMkADNiNmM1ZmJjLTIzMWMtNGJhOS05MzhkLTU4NWQxOTQ5NTQ1OABGAAAAAAAZfOve6wprSIcF4bywKXFoBwCqBO0DICSYTJGYCLK3t0RzAAAAAAENAACqBO0DICSYTJGYCLK3t0RzAAcx8BtXAAABEgAQAIoMmDGkHJRJrDDi7bUVBCc%3D&thumbnailType=2&token=eyJhbGciOiJSUzI1NiIsImtpZCI6IjMwODE3OUNFNUY0QjUyRTc4QjJEQjg5NjZCQUY0RUNDMzcyN0FFRUUiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJNSUY1emw5TFV1ZUxMYmlXYTY5T3pEY25ydTQifQ.eyJvcmlnaW4iOiJodHRwczovL291dGxvb2sub2ZmaWNlLmNvbSIsInVjIjoiZjJhNzkyZTdjZjUwNGEzNzg2MWFhNWM0NjA0MDFjNDciLCJzaWduaW5fc3RhdGUiOiJbXCJrbXNpXCJdIiwidmVyIjoiRXhjaGFuZ2UuQ2FsbGJhY2suVjEiLCJhcHBjdHhzZW5kZXIiOiJPd2FEb3dubG9hZEBmMGQxMzA0OS1hOTU1LTQ5ZDAtOTQxNy0zOTk1NDE5NWNjMjgiLCJpc3NyaW5nIjoiV1ciLCJhcHBjdHgiOiJ7XCJtc2V4Y2hwcm90XCI6XCJvd2FcIixcInB1aWRcIjpcIjExNTM5MDY2NjA2OTA1MzI5NjFcIixcInNjb3BlXCI6XCJPd2FEb3dubG9hZFwiLFwib2lkXCI6XCJkNDdjMjE1MS1iOTk5LTQwYjctOGM5Ny1mZTg3NWQ0ZDQwM2JcIixcInByaW1hcnlzaWRcIjpcIlMtMS01LTIxLTEzMjI2MzgzNDYtMjMzNzAzMTA0MC0xODA1MjAyOTU0LTkwODAyN1wifSIsIm5iZiI6MTYxODMwODIwMSwiZXhwIjoxNjE4MzA4ODAxLCJpc3MiOiIwMDAwMDAwMi0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDBAZjBkMTMwNDktYTk1NS00OWQwLTk0MTctMzk5NTQxOTVjYzI4IiwiYXVkIjoiMDAwMDAwMDItMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL2F0dGFjaG1lbnRzLm9mZmljZS5uZXRAZjBkMTMwNDktYTk1NS00OWQwLTk0MTctMzk5NTQxOTVjYzI4IiwiaGFwcCI6Im93YSJ9.YPMMYXLz3rNhNzrPTVnKU0DqSgDJS7bQ9SWmhi6hwQhzfnJaxGuolYFXI_Pl8vinfPag7IC5IeAUcdcrEZKUFBmu9UhNPqGAaBKqt_lbudRiCgXeNt7dArhJvLy_9LQ2FRNePbaNVP3uXp6Ef4HT4hc0s3BcolkPa_CtoQKg2idiGuK66a3wPxoZTKvKh_cdXMQb0ynQnloK7C9s6yeOHcatsYvMtjvxyknZoq2M3pRewHuVPIuNjpwOLPgGnMmSC9kSUqoFVqMPoGtAeUhchuf1KnAwIK-sc8TXZXv18ZEgKMF2f94Imzsu9nKQkOt8gI6VMonYMGiAecW4zMYxDg&X-OWA-CANARY=AtyQEYyEeUOQqk4kpDS1OoBIv5Rj_tgYnPzLZA35tGKWD_LW0HS9Bbbu0fNByf0etWAKx57i2uE.&owa=outlook.office.com&scriptVer=20210405005.04&animation=true) **Note**: A logfile of this process '*scheduler.YYYYMMDD.txt'* will be created in the  '*C:\\Intuitive\_WorkFiles\\Logfiles*' folder. 10. Now restart the Intuitive Dashboard Service 11. The intuitive dashboard system is now running under SQLite and you can now login to the dashboard system as normal. **Note**: You may need to clear the browser cache (Ctrl-F5) at this point so the system browser picks up the new client. 12. If for any reason the migration needs to be performed again, to enable this you will need to delete the file '*.dashboard-import-done*' from the initialised folder: '*C:\\Program Files\\Intuitive Business Intelligence\\Intuitive Dashboards\\Tools\\ETL Service\\initialised\\'* 13. If required, now restore your original '*ETLService.config*' file which was backed-up in step 6. - [Intuitive Dashboards Core Software](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#main-content) - [Getting Started](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#getting-started) - [Viewing Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#viewing-dashboards) - [Interacting with dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#interacting-with-dashboards) - [Filters](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#filters) - [Connections](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#connections) - [Datafeeds](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datafeeds) - [Datasets](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datasets) - [Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#components) - [Creating Dashboards and Components - Overview](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-dashboards-and-components-overview) - [Creating Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-components) - [Creating a Dashboard](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-a-dashboard) - [Administering the System](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-the-system) - [Administering Users](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-users) - [Administering Groups](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-groups) - [Security Filters - V5.2 and earlier](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#security-filters-v5-2-and-earlier) - [Security Filters - V5.3 Onward](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#security-filters-v5-3-onward) - [Embedding Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#embedding-dashboards) - [Configuration File](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#configuration-file) - [Installation & Configuration Guide](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#installation-configuration-guide) - [Version History](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#version-history) - [Intuitive for PaperCut V2](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#main-content) - [Installing Intuitive for PaperCut](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#installing-intuitive-for-papercut) - [Viewing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#viewing-papercut-dashboards) - [Editing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#editing-papercut-dashboards) - [Intuitive for PaperCut Demonstration Videos](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#intuitive-for-papercut-demonstration-videos) - [Intuitive for PaperCut FAQs](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#intuitive-for-papercut-faqs) - [Intuitive for PaperCut MF V3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#main-content) - [Installing Intuitive for PaperCut Version 3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#installing-intuitive-for-papercut-version-3) - [Viewing the dashboards - Intuitive for PaperCut Version 3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#viewing-the-dashboards-intuitive-for-papercut-version-3) - [Editing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#editing-papercut-dashboards) - [Intuitive for PaperCut FAQs](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#intuitive-for-papercut-faqs) - [Intuitive for SAFEQ](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#main-content) - [General Help](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#general-help) - [Software Installation](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#software-installation) - [Solution Expertise](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#solution-expertise) - [Intuitive For Managed Print Services (MPS)](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#main-content) - [Intuitive for MPS - Overview](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-overview) - [Intuitive for MPS - Installation Steps](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-installation-steps) - [Intuitive for MPS - Import File Layouts](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-import-file-layouts) - [Intuitive For MPS - Loading the Data Warehouse](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-loading-the-data-warehouse) - [Intuitive Cloud Services](https://help.intuitivebusinessintelligence.com/intuitive-cloud-services?hsLang=en) - [Intuitive for PaperCut Hive V1](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-hive-v1?hsLang=en#main-content) - [Viewing the dashboards - Intuitive for PaperCut Hive](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-hive-v1?hsLang=en#viewing-the-dashboards-intuitive-for-papercut-hive) - [Intuitive for SAFEQ Cloud](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#main-content) - [Intuitive Solution Expertise](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#intuitive-solution-expertise) - [Intuitive Software Provisioning](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#intuitive-software-provisioning) - [Intuitive for Docuware](https://help.intuitivebusinessintelligence.com/intuitive-for-docuware?hsLang=en) - [Intuitive for Print Management](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#main-content) - [Solution Knowledge](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#solution-knowledge) - [Technical Information](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#technical-information) - [Intuitive for e-BRIDGE Global Print](https://help.intuitivebusinessintelligence.com/intuitive-for-e-bridge-global-print?hsLang=en) - [Intuitive for e-FOLLOW Cloud](https://help.intuitivebusinessintelligence.com/intuitive-for-e-follow-cloud?hsLang=en) - [FAQ](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#main-content) - [Connections](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#connections) - [General Enquiries](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#general-enquiries) - [Datafeeds](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#datafeeds) - [Datasets](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#datasets) - [System Compatability](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#system-compatability) - [Software Installation](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#software-installation) [![Chill listening crop-3](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20BLACK.png?width=102&height=24&name=Intuitive%20logo%20BLACK.png "Chill listening crop-3")](https://help.intuitivebusinessintelligence.com?hsLang=en) weareintuitive.com Help Center Copyright © 2026, Intuitive Business Intelligence Limited