Blog
Azure SQL | Migratie naar Azure
Azure SQL | Migratie naar Azure

Oracle migration to Azure SQL database – Part 1

Is Azure the flavour of the month, or is Microsoft busy playing catch-up? We’ve been approached by two clients in recent months to help them transition legacy Oracle systems to the Azure platform. We’ve been developing modern tiered database solutions for many years, with Front-end web applications calling Java-based services that use Oracle databases for storage. Just how easy is it to migrate these applications to Azure?

Tiered web applications

We’ve developed many custom web applications using Oracle at their core. We try to avoid embedding database-specific code in front-end JavaScript/HTML, so we work with a tiered architecture.

The front-end

The front-end web application focuses on user interaction, creating responsive, easy-to-use web interfaces. Wherever possible, we shield our web developers from “where” data is stored, and how. When the web interface needs data or wants to save information, it uses simple API calls based on JSON or SOAP.

API (web-services)

We create the JSON/SOAP services that communicate between the database (Oracle, Sybase, MySQL…) and the front-end. These web services are often developed using Java, but sometimes PHP. These services also don’t need to know much more about the database details, just where it can be found. We try and encapsulate the application behaviour using functional API methods. For example, “Save User Profile” or “Read User Profile.” Wherever possible, we avoid the API having to know much about the database structure. It just needs to “know” what information is saved in (following our example) a “User Profile.” Perhaps a user name, phone number, profile photo, and address. So far, so good!

Business Logic (Data model, Stored Procedures, Triggers, and Constraints)

We place the Business Logic in the database, using triggers, constraints, and stored procedures linked to a Data Model which stores the business data. Constraints and Triggers linked to the data model are simple but effective, as they can – returning to our user profile – automatically ensure that a new username is unique. Or check that there is a telephone number for each user. We can accomplish this without the need for our web developers to know anything about the data model or even the type of database. Stored procedures are even more useful, as they can contain intelligent functions and code. So they can perform a sequence of actions on many different database tables if necessary. They are built around the data model. When the data model changes – perhaps in later releases, we can automatically identify inconsistencies, making it very easy to maintain the code.

Easy to maintain

These techniques make it extraordinarily straightforward for BSL to maintain and update our web applications. We can completely change a data model, business rules and stored procedures without any impact on the front-end web application. And our web developers can make interface changes without ever needing to know where or how data is stored. It sometimes brings tears to our eyes when we take over web applications from other developers and find endless “SQL code” buried amongst JavaScript or PHP code. It’s almost impossible to maintain – which means higher costs for the client!

How does this impact Oracle Migration to Azure SQL?

We’re familiar with Oracle SQL programming (PL/SQL), MySQL Stored Procedures (limited in comparison with Oracle), and Azure SQL programming (Transact SQL). We’ve used Transact SQL for many years, even before Microsoft adopted it for their SQL Server. This SQL dialect comes from Sybase – another database we’ve used.

Our chosen architecture means that we can minimise the impact on front-end software. Technically, we can take Oracle out from a web application created by BSL and replace it with MySQL, PostgreSQL, or Azure SQL Server without the need for front-end changes. Naturally, our API developers will need to update the API services so that they “know” about the new location of the data. However, our database libraries can support many different databases from the same code base. So we can quickly migrate from one database system to another, and very few API code changes are needed.

Oracle Migration to Azure SQL

We’re in the middle of a complex migration right now, migrating a critical banking solution from Oracle 12 to Azure. At the end of this migration, their database will no longer run on a server they manage. Instead, their data will reside in an Azure Cloud. As a result, they will reduce their management costs, availability, scalability will improve, and the system will be available for global access by authorised users.

It’s a significant project, as we need to translate over 20,000 lines of PL/SQL code used in more than 200 stored procedures. The applications use data types that don’t exist in SQL Server, which presents a few more challenges for our developers. Still, what’s life without a challenge or two!

The good news: we’re on schedule right now. We expect to complete the project within eight weeks. In our next blog, we’ll tell you more about how we are accomplishing this and which tools we are using to help us.

Next week: Part 2 of this blog.

Get in touch

Have you got plans to migrate your in house system to Azure or any other databases mentioned in this article? Talk to us. Perhaps we can help. You are welcome to contact our relations manager at any time. She can set up an online call.

Progressive Web Apps in EU undermined by Apple?

Progressive Web Apps in EU undermined by Apple?

If you aren’t familiar with mobile app development, you may not know that Apple has recently thrown a rather large spanner into the iOS ecosystem. Since the early betas of iOS 17.4 were made available, developers noted that so-called “Progressive Web Apps” (PWAs) were no longer functional in the EU. Our blog explains more.

The role of AI in Business Intelligence for multinationals

The role of AI in Business Intelligence for multinationals

BSL delivers Business Intelligence solutions to multinational organisations, integrating content from thousands of publications worldwide and delivering daily themed news alerts and briefings to business users. Recently, we’ve introduced AI technologies to these services, and our latest blog post highlights some of the benefits.

Whiteboards and the Canon of the Netherlands app

Whiteboards and the Canon of the Netherlands app

Recently, a digital whiteboard supplier called CTOUCH reached out to BSL, requesting permission to include the Canon of the Netherlands app in their store for use on their digital whiteboards in classrooms. We liked the idea and recently created a special version of our app designed specifically for the big screen.

Google Looker Studio: Making sense of big data

Google Looker Studio: Making sense of big data

In today’s fast-paced world, making quick and well-informed decisions is crucial. Google Looker Studio is a free tool that can give you a significant advantage. It can help you transform your vast amount of Analytics data into informative, easy-to-read dashboards and reports that are completely customizable.

Let BSL take care of your website maintenance updates

Let BSL take care of your website maintenance updates

We understand the importance of regular website maintenance updates for WordPress and Drupal. Hackers sometimes target popular open-source products, so keeping your CMS and any plugins up-to-date is essential. Trust BSL to keep your website up-to-date and secure while you focus on crafting persuasive content for your audience.

BSL Summer event on the water

BSL Summer event on the water

It was time for our annual summer event with the whole company. This year, Diana arranged a boat trip in a salon boat along the Vecht towards Loenen and Vreeland. After the boat trip, the summer event continued in the restaurant of Bistrotel ‘t Amsterdammertje, where everyone enjoyed a delicious dinner.

Adobe Firefly and Photoshop Beta with generative fill

Adobe Firefly and Photoshop Beta with generative fill

After the success of ChatGPT and Midjourney AI – both already in use at BSL – Adobe didn’t want to be left behind and made public their Beta releases of Adobe Firefly and Photoshop AI. With the arrival of the Adobe Betas, we’ve turned our attention to the new kids on the block, comparing them with Midjourney.

Midjourney prompts – Describing your perfect image

Midjourney prompts – Describing your perfect image

In an earlier blog, we introduced Midjourney as a tool we use within BSL when designing websites and banners for blogs. To direct Midjourney to create the image you have in mind, you need to write a prompt describing the image. This new blog discusses Midjourney prompts and some of the commands and parameters you can use.

Drupal 9 development using Tailwind CSS

Drupal 9 development using Tailwind CSS

Using Drupal, BSL has developed an extensive Intranet site to which we all have access. We’re developing a new version of the site, and in this blog, one of our developers talks about some of the tools we are using, including Twig templates, the Entity and Form APIs and Tailwind CSS.

Midjourney AI – Turning your ideas into images

Midjourney AI – Turning your ideas into images

Over the past few weeks, BSL has been exploring the many possibilities offered by Artificial Intelligence. This latest blog describes the use of Midjourney AI, a web service that generates images based on natural language descriptions (“prompts”). The results are impressive. Read our blog to find out more.

The benefits of long-term partnerships

The benefits of long-term partnerships

NBD Biblion offers personalised book and media title recommendations to schools and libraries, and supplies their clients with the titles they select. BSL has had a long-term partnership with NBD Biblion for more than twenty years, delivering development teams, technical advice, and support.

ChatGPT for business information analysis

ChatGPT for business information analysis

After the initial enthusiastic response to the introduction of ChatGPT and AI, attention switched to the unreliability of many ChatGPT answers. However, using Azure OpenAI (ChatGPT) and Cognitive Search with reliable data, we can deliver reliable, high-quality business information in response to natural language queries.

Browser engine wars – Part 2 – The impact of Apple’s iOS monopoly

Browser engine wars – Part 2 – The impact of Apple’s iOS monopoly

The Apple iOS monopoly means that every app on iOS – including browsers from Apple’s competitors – must use WebKit to display web content. While it’s not uncommon for browser developers to use a third-party engine, they can usually control which engine features they use in their browser and – if needed – add custom features.

Browser engine wars – Part 1 – How did we get here?

Browser engine wars – Part 1 – How did we get here?

The Register recently reported that Google is working on an iOS version of Chromium. A few days later, a second article claimed that Mozilla is working on an iOS version of Gecko, Firefox’s browser engine. Both reports suggest that the Apple browser engine on iOS, WebKit, is in danger of losing its monopoly.

Donation on behalf of earthquake victims in Turkey and Syria

Donation on behalf of earthquake victims in Turkey and Syria

On Monday, 6 February, several powerful earthquakes and aftershocks hit Turkey and Syria. This disaster affects as many as 23 million people, including many who are already in desperate need due to the conflict in Syria. If possible, please join us in making a donation on the Giro555 website.

WordPress and page-builders such as Divi and Elementor

WordPress and page-builders such as Divi and Elementor

For building websites on behalf of clients, we often use WordPress together with page-builders, making it easy to prototype and develop modern, responsive websites. With page-builders such as Divi and Elementor, you can easily and quickly design and build pages to match almost any design.

2022 and the Bright Side of Life

2022 and the Bright Side of Life

Taking the time to reflect regularly on the things we are grateful for at the Bright Side can help shift our perspective to focus on the positive aspects of our work. So, here are the things for which I’m grateful in 2022.

SEO benefits, and the power of good-quality content

SEO benefits, and the power of good-quality content

Many business owners still think their websites are merely visiting cards. Their “go-to” expression is: “our clients/audience already know where to find us…”. This may be true, but optimizing your website will reach new clients and audiences.

New Keylane Careers website

New Keylane Careers website

Keylane asked BSL to help design and build a new Careers website. The main aim is to increase the number of visitors by improving the organic search performance. To achieve this, we’re introducing a new design and adding blogs.

Cloud provider migration: What are the benefits?

Cloud provider migration: What are the benefits?

The focus of Cloud computing is to improve the efficiency of IT services. By choosing a cloud-based solution, organisations can stay up-to-date with technology innovations and benefit from higher scalability, lower expenses, and enhanced security.

A new website for BoekWijzer

A new website for BoekWijzer

We’ve completely revamped the BoekWijzer website! The website was built to support the BoekWijzer app, the mobile guide to the world of Dutch literature. Using the app, you can quickly and easily stay up to date with the latest literary news.

New developer / web designer at BSL

New developer / web designer at BSL

If you have any questions about your website or web design in general, then Patrick van Bennekom is ready to help you five days a week at BSL. Patrick helps to design and create websites and apps for our customers, including the design of logos and house styles to deliver a professional end product.

Migrating to the Cloud, benefits and opportunities

Migrating to the Cloud, benefits and opportunities

Several of our clients are migrating to the Cloud, and some that aren’t yet ready for this step are reviewing their legacy systems, intending to migrate to the Cloud in the future. We’ve recently completed two migrations on behalf of multinationals, and our experience has taught us that a direct approach (simply redeploying existing databases and applications on virtual machines) is not always the best route…

Beleev: Controlled Multisensory Environments

Beleev: Controlled Multisensory Environments

Perhaps you have never heard of snoezelen, a Dutch term that describes controlled multisensory environments (MSE) that stimulate various senses within a custom environment – a so-called “Snoezel” room. On behalf of St. John the Baptist special education school in Kerkrade, we’ve created custom software to create and manage so-called “Snoezel” rooms, controlling, lights, audio, switches and a video projector.

Goodbye 2021 and COVID-19 lockdowns – It’s time to look back

Goodbye 2021 and COVID-19 lockdowns – It’s time to look back

So who, in early 2020, thought that we’d still be operating under COVID-19 lockdown measures in January 2022? Luckily, my skill set has given me a better understanding of software development and technology than catering or hospitality. As director of an IT company, I’m happy to say that Bright Side of Life has taken to remote working as a fish to water. Let me tell you about our year.

Canon of the Netherlands apps now available in stores

Canon of the Netherlands apps now available in stores

The Dutch Canon of the Netherlands (2007) tells the story of how the Netherlands was formed. Using the Canon, BSL developed the popular EnToen Nu apps for iOS and Android a few years later. In 2020, the Canon was extensively revised, so we’ve completely rewritten the Canon apps, bringing them up-to-date, making them faster and even more fun to use. They’re now available in the app stores.

Integrating powerful AI search capabilities within apps and web-services

Integrating powerful AI search capabilities within apps and web-services

Search technology is continually evolving, so we’re always ready to adopt new technologies to meet specific client needs. This blog outlines our recent experiences with Azure Cognitive Search and Cognitive Search AI services – classifying thousands of new documents each day, delivering customised briefings to subscribers. Using Machine Learning and AI we can create intelligent search prototypes in just a few weeks.

Canon of the Netherlands apps coming soon!

Canon of the Netherlands apps coming soon!

The Committee on the Development of the Dutch Canon developed the Canon of the Netherlands in 2007. BSL developed the EnToen app a few years later, and since its launch in 2013, it has been a top-rated school app. In 2020, a new Canon Committee updated the Canon. We’re now busy working on new Canon Apps, with a modern look, and using the latest technical know-how.

Drupal 9 replaces Drupal 8. Long live Drupal 7!

Drupal 9 replaces Drupal 8. Long live Drupal 7!

Drupal 9 arrived last year, and Drupal 8 is end-of-life in November 2021. Nothing strange about this. But did you know that Drupal 7’s life has been extended to November 2022? Due to the high number of active users, it will remain in use longer than Drupal 8! Nevertheless, if you’re still using Drupal 7, you’re drinking in the last chance saloon, and it’s time to plan your transition to Drupal 9.

4

Previous

5

Next

Contact BSL