One of the largest US educational organizations has been running their data handling system in Oracle environment. They wished to reduce maintenance costs due to expensive Oracle licensing model, which includes an additional fee for the partitioning feature. We provided the solution of migrating the customer’s database to SQL Server. Reconstruction of the original partitioning system in SQL Server allowed us to save extra money in addition to significantly lower SQL Server maintenance cost compared to Oracle. Check how we performed the […]
Talks on Managing Data and Applications Anywhere
Staying on the cutting edge of modern technologies, DB Best application development team constantly strive to offer the best solutions for our customers. Simply watch the following video to see the examples of some cool features we can add to your business app be it a cinema house, a shopping mall or any other place, crowded with people. Let’s take a look at the impressive list of technologies that made the creation of this mobile application possible.
One of the largest life insurance companies in the United States supported a reporting application. Their system included Java based web app and Informatica data management solution connected to DB2 database. To provide a web interface for reporting needs they employed a WebSphere server for hosting Java application. With this interface, a small circle of users could create reports using data imported from Informatica application. Our customer wanted to reduce the maintenance costs and increase the application functionality. We came up with […]
A global financial software provider contacted us to migrate their billing solution from Oracle to SQL Server using SSIS for one of their strategic clients located at the other end of the world. They also needed to transfer data from Oracle to SQL Server using SSIS. The actual migration had to be performed by the remote team. In order to do so, our customer was looking for an automated solution with detailed step by step instructions. To meet the customer’s […]
We’re excited to bring you the latest release of Database Compare Suite. The new version 4.8 brings support for IBM Netezza versions 7.2.1 and higher along with some other improvements. Covering All Major Database Platforms With the support of IBM Netezza, the total count of available database platforms in the Database Compare Suite reached the amazing total of 11. You can see the full list of supported database dialects on the image below. They include Amazon Redshift, Azure SQL Database, […]
When migrating to Amazon Redshift, you need a way to convert functions and other capabilities that Oracle, Teradata, Greenplum, Netezza support that Redshift does not natively support. The AWS Schema Conversion Tool Extension Pack for Data Warehouses provides Python based libraries to provide the same functionally with Redshift. In this post, we will show how the AWS Schema Conversion Tool (SCT) generates the extension packs to help in your migration effort. You will have to upload the extension pack for your source […]
A large European company decided to migrate their Oracle database system to SQL Server. Of course, they wanted to outmaneuver the performance of their original system. The original customer’s system included a huge bunch of over 700 reports, built in deprecated Oracle forms technology. We offered a solution on the new SQL Server Reporting Services platform. This solution satisfied the rigid performance demands of the customer. We used the previously developed internal tool to automate the Oracle Forms conversion process, but […]
Oracle allows you to create a query with aggregate functions referring to a remote table. For example, if your query includes two tables: one from the local schema and another from the remote database. You can simply use a database link in Oracle to create that construction. Previously, we already talked about converting database links using a linked server. But the problem is that SQL Server Migration Assistant (SSMA) for Oracle doesn’t convert queries that refer to the remote objects through the database link. So, when you try […]
Oracle uses database links to access objects on another database. In SQL Server you can use linked server or an OPENQUERY function to emulate that functionality. The problem is that SQL Server Migration Assistant (SSMA) for Oracle doesn’t automatically convert database links. Instead, when you try to convert a query that refers to the remote objects through the database link, SSMA will generate an error O2SS0083.
A major bank in Europe that we’ve been working with over the years requested our help in upgrading SQL Server 2008 to 2016. Since we performed the migration process originally from DB2 to SQL Server we had a deep knowledge of the customer’s data. Because of the need to have a highly available system and they could not afford to be down. Our client needed a way to downgrade to the old database system in case something bad happens to the upgraded system. […]