{"id":12413,"date":"2019-05-03T09:34:17","date_gmt":"2019-05-03T07:34:17","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/"},"modified":"2019-05-03T09:34:17","modified_gmt":"2019-05-03T07:34:17","slug":"how-to-migrate-from-on-premise-to-an-azure-sql-database","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/","title":{"rendered":"How to migrate from on-premise to an Azure SQL Database"},"content":{"rendered":"

As a SQL Server DBA we have the habit to migrate databases from an instance to another one or to a new environment.
\nBut migrate a database from on-premise to the Azure Cloud is an operation that we don\u2019t deal with every day.<\/p>\n

As a reminder, Azure SQL Database is a relational database-as-a-service (DBaaS) which gives the ability to manage your databases directly from the Cloud with the performance of your choose, reliability, security and in the same time get rid of relying infrastructure.<\/p>\n

In this blog, I will show you some possibilities of database migration from on-premise to an Azure SQL Database.<\/p>\n

 <\/p>\n

Via SSMS<\/h1>\n

The first one is directly from your SQL environment via SQL Server Management Studio.
\nClick on a database and select \u201cDeploy Database to Microsoft Azure SQL Database\u201d:<\/p>\n

\"\"<\/a><\/p>\n

Once done we have to specify the Microsoft Azure SQL Database Server where our database will be migrated:<\/p>\n

\"\"<\/a><\/p>\n

Click on Connect and enter the server name you have already created in the Azure Cloud with the server admin login:<\/p>\n

\"\"<\/a><\/p>\n

Once connected we have to select the Azure SQL Database settings. It means the service tiers we want to select for our database. This is in fact the business continuity, storage, and performance requirements we want for our database. I will choose a small one with a Standard Edition of Microsoft Azure SQL Database, a maximum database size of 1 GB and a service objective S0 (10 DTUs).
\nClick Next:<\/p>\n

\"\"<\/a><\/p>\n

Review the specified settings and click Finish to start the deployment of our on-premise database to an Azure SQL Database.<\/p>\n

\"\"<\/a><\/p>\n

Exporting tasks are running:<\/p>\n

\"\"<\/a><\/p>\n

Export is finished:<\/p>\n

\"\"<\/a><\/p>\n

The database is Online in our Azure dashboard:<\/p>\n

\"\"<\/a><\/h1>\n

And also connectable via SSMS:<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

Import via a BACPAC file<\/h1>\n

On Management Studio select the database you want to migrate, right click on it and select \u201cExport Data-tier application\u201d:<\/p>\n

\"\"<\/a><\/p>\n

Save the bacpac file locally and click Next:<\/p>\n

\"\"<\/a><\/p>\n

Verify the export settings and click Finish to create the bacpac file:<\/p>\n

\"\"<\/a><\/p>\n

Process is running:<\/p>\n

\"\"<\/a><\/p>\n

Exporting database in a bacpac file has succeeded:<\/p>\n

\"\"<\/a><\/p>\n

Now to import the bacpac file in Azure and create an Azure SQL Database, we have to connect to our Azure server via SSMS. In the Object Explorer pane, right-click on the Databases folder and select \u201cImport Data-tier Application\u201d:<\/p>\n

\"\"<\/a><\/p>\n

Once done, browse the local disk to find the bacpac file and click Next:<\/p>\n

\"\"<\/a><\/p>\n

Select a new name for the database and give settings for our new Azure SQL Database (we keep the same database settings):<\/p>\n

\"\"<\/a><\/p>\n

Review the settings and click Finish to start the import process:<\/p>\n

\"\"<\/a><\/p>\n

Once finished I have a succeed message:<\/p>\n

\"\"<\/a><\/p>\n

I can see my new database in SSMS and in my Azure dashboard:<\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

Database Migration Assistant<\/h1>\n

Database migration assistant can create an assessment to know if a specific database can be easily exported to an Azure SQL Database and during a second step migrates the database.
\nLet see how it\u2019s working.<\/p>\n

Open Database Migration Assistant, click on the \u201cNew\u201d Menu and select Assessment as Project type. Enter a project name and click the \u201cCreate\u201d button:<\/p>\n

\"\"<\/a><\/p>\n

Keep the selected report type, this will check the database compatibility and check feature parity and click Next:<\/p>\n

\"\"<\/a><\/p>\n

Connect to a server, select one or multiple databases and add it\/them to the project:<\/p>\n

\"\"<\/a><\/p>\n

Start the assessment:<\/p>\n

\"\"<\/a><\/p>\n

Once done we have a list of Unsupported and partially-supported features for SQL Server parity.
\nWe have for Compatibility issues: migration blockers, behavior changes, deprecated features and information issues.
\nAll those issues have to be taken into consideration before the migration.
\nMigration can be done without any changes but the database will not be 100% usable.<\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

Despite the assessment which shows that our database is not 100% compatible with Azure SQL Database let\u2019s continue and try a migration project.
\nSelect Migration as Project type and add a project name.
\nClick the \u201cCreate\u201d button:<\/p>\n

\"\"<\/a><\/p>\n

Connect to the source server and select the database to migrate. Click the \u201cNext\u201d button:<\/p>\n

\"\"<\/a><\/p>\n

Connect to the target server located in the Cloud (the one we created here) and select the Azure SQL Database we created empty during my previous blog:<\/p>\n

\"\"<\/a><\/p>\n

In this screen we can select schema objects that we want to migrate to Azure SQL Database. We can see that we have some validation issues as shown before by the assessment.
\nClick on the \u201cGenerate SQL Script\u201d button:
\nAs written I will migrate all objects as blockers can be fixed later.<\/p>\n

\"\"<\/a><\/p>\n

The script for the select schema objects has been generated, click the \u201cDeploy schema\u201d button to deploy the schema to the Azure SQL Database:<\/p>\n

\"\"<\/a><\/p>\n

We can now migrate the data by clicking the \u201cMigrate Data\u201d button:<\/p>\n

\"\"<\/a><\/p>\n

Let all tables selected and click \u201cStart data migration\u201d:<\/p>\n

\"\"<\/a><\/p>\n

Data for the 3 tables have been migrated successfully:<\/p>\n

\"\"<\/a><\/p>\n

I can now browse my Azure SQL database in my Management Studio on-premise. All my objects are available and my tables are filled with my data:<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

It was 3 possibilities to migrate an on-premise database to an Azure SQL Database.
\nI hope it can help 😉<\/p>\n","protected":false},"excerpt":{"rendered":"

As a SQL Server DBA we have the habit to migrate databases from an instance to another one or to a new environment. But migrate a database from on-premise to the Azure Cloud is an operation that we don\u2019t deal with every day. As a reminder, Azure SQL Database is a relational database-as-a-service (DBaaS) which […]<\/p>\n","protected":false},"author":21,"featured_media":12448,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[955,198],"tags":[1338,1616,1613,1617,15],"type_dbi":[],"class_list":["post-12413","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud","category-database-management","tag-azure","tag-azure-migration","tag-azure-sql-database","tag-data-migration-assistant","tag-migration"],"acf":[],"yoast_head":"\nHow to migrate from on-premise to an Azure SQL Database - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to migrate from on-premise to an Azure SQL Database\" \/>\n<meta property=\"og:description\" content=\"As a SQL Server DBA we have the habit to migrate databases from an instance to another one or to a new environment. But migrate a database from on-premise to the Azure Cloud is an operation that we don\u2019t deal with every day. As a reminder, Azure SQL Database is a relational database-as-a-service (DBaaS) which […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-03T07:34:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Azure_ImportDB3-14.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1817\" \/>\n\t<meta property=\"og:image:height\" content=\"951\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Savorgnano\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Savorgnano\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/\"},\"author\":{\"name\":\"St\u00e9phane Savorgnano\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"headline\":\"How to migrate from on-premise to an Azure SQL Database\",\"datePublished\":\"2019-05-03T07:34:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/\"},\"wordCount\":840,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Azure_ImportDB3-14.jpg\",\"keywords\":[\"Azure\",\"Azure Migration\",\"Azure SQL Database\",\"Data Migration Assistant\",\"Migration\"],\"articleSection\":[\"Cloud\",\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/\",\"name\":\"How to migrate from on-premise to an Azure SQL Database - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Azure_ImportDB3-14.jpg\",\"datePublished\":\"2019-05-03T07:34:17+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Azure_ImportDB3-14.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Azure_ImportDB3-14.jpg\",\"width\":1817,\"height\":951},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to migrate from on-premise to an Azure SQL Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\",\"name\":\"St\u00e9phane Savorgnano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Savorgnano\"},\"description\":\"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals & Pharmaceuticals, etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to migrate from on-premise to an Azure SQL Database - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/","og_locale":"en_US","og_type":"article","og_title":"How to migrate from on-premise to an Azure SQL Database","og_description":"As a SQL Server DBA we have the habit to migrate databases from an instance to another one or to a new environment. But migrate a database from on-premise to the Azure Cloud is an operation that we don\u2019t deal with every day. As a reminder, Azure SQL Database is a relational database-as-a-service (DBaaS) which […]","og_url":"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/","og_site_name":"dbi Blog","article_published_time":"2019-05-03T07:34:17+00:00","og_image":[{"width":1817,"height":951,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Azure_ImportDB3-14.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Savorgnano","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Savorgnano","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/"},"author":{"name":"St\u00e9phane Savorgnano","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"headline":"How to migrate from on-premise to an Azure SQL Database","datePublished":"2019-05-03T07:34:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/"},"wordCount":840,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Azure_ImportDB3-14.jpg","keywords":["Azure","Azure Migration","Azure SQL Database","Data Migration Assistant","Migration"],"articleSection":["Cloud","Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/","url":"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/","name":"How to migrate from on-premise to an Azure SQL Database - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Azure_ImportDB3-14.jpg","datePublished":"2019-05-03T07:34:17+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Azure_ImportDB3-14.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Azure_ImportDB3-14.jpg","width":1817,"height":951},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/how-to-migrate-from-on-premise-to-an-azure-sql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to migrate from on-premise to an Azure SQL Database"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c","name":"St\u00e9phane Savorgnano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","caption":"St\u00e9phane Savorgnano"},"description":"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals & Pharmaceuticals, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12413","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=12413"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12413\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/12448"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=12413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=12413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=12413"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=12413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}