More from our Blog
Developing a worldwide lost and found platform
PerdidoOnline, a Puerto Rico based startup came up with an idea to help the unfortunate among us who lose our belongings wherever we go. Our client wanted to develop a locator and tracking solution t that will substitute the lost and found offices all over the world and save the users from worrying about losing their property. Read more to learn how our team turned this idea into reality.
Andrii Koval
Car Auction Marketplace: From concept to release in record time
Speed is everything in the highly competitive domain of e-commerce. Digital marketplaces of varied sizes appear at an ever-increasing rate and it becomes more challenging to stand out among the competition. According to estimates, a 6-months delay in a software product release can cut its profitability by at least 30%. These numbers had been relevant […]
Michael Virych, Roman Muzyka
An overview of the remote migration from Oracle to SQL Server with SSIS
One of our clients, a large financial software company, wanted to migrate their billing solution from Oracle to SQL Server. They needed to initiate this project because the migration was required by one of their strategic partners. The customer decided to implement SQL Server Integration Services (SSIS) for this migration. Additionally, they needed to do […]
Andrey Khudyakov, Roman Muzyka
Migrating from SAS to Big Data for a global retailer
When a global retailer in the beauty industry needed a new and cost-effective data processing solution, they knew the search would require a high level of expertise. That is why they decided to seek advice from ABCloudz. The company had a massive amount of data and utilized SAS software for data processing, both powerful but […]
Andrey Khudyakov (DB architect), Roman Muzyka (writer)
Oracle to SQL Server migration with SSMA: Converting interval literals
Oracle enables you to use specific interval literals for indicating a certain period of time. Unfortunately, there is no direct analog for such literals in SQL Server. As a result, when you apply SQL Server Migration Assistant (SSMA) for converting Oracle code with interval literals, you receive an error O2SS0086. The term ‘interval literals’ refers to a fixed data value, […]
Andrey Khudyakov, Roman Muzyka
Oracle to SQL Server migration with SSMA: Converting interval expressions
Oracle databases have many specific functions and features. For example, it stores a period of time with specific interval expressions. This may cause issues during the database migration from Oracle to SQL Server. When you use SQL Server Migration Assistant (SSMA) for converting Oracle with interval expressions, you will observe the O2SS0006 error message. This may happen because that SSMA does not […]
Andrey Khudyakov, Roman Muzyka
Migrating to Azure SQL Managed Instance: Reasons and implications
Azure SQL Managed Instance (MI) is a highly-efficient Azure service that allows combining the broadest SQL Server database compatibility with numerous benefits of a fully managed PaaS (Platform as a Service). MI provides a much higher degree of capability than Azure SQL Database DTU and vCore service levels. Read this blog post to know the […]
Roman Muzyka, Andrey Khudyakov
Access modernization roadmap for a highly-outdated environment
One of our clients, a major health company, was operating a data system. Over the years, it had expanded dramatically. However, the client had never developed a comprehensive modernization strategy for their product. As a result, they ended up with a highly outdated and inefficient environment overloaded with thousands of Microsoft Access and SQL Server […]
Roman Muzyka, Andrey Khudyakov
Ready to start the conversation?
ABCloudz emerged from the world of data and established itself as a go-to partner for any IT needs. Our professionals are ready to help. Drop us a line today!