oracle

New Versions of ODBC Drivers: Oracle, PostgreSQL, QuickBooks, xBase

New versions of ODBC drivers for Oracle, PostgreSQL, QuickBooks were released with improved compatibility with Power Pivot, Visual Basic, and RStudio.

(more…)

Migrating data from Oracle to PostgreSQL database

There are several reasons you may want to migrate your databases from Oracle to PostgreSQL:

1. Oracle can be very expensive, with some important features requiring additional investments on top of that.

(more…)

Data migration from MySQL to Oracle server

Data migration is a tiresome task requiring a great deal of manual activity. In this article, we will examine how to migrate MySQL data to the Oracle server, using Data Export feature built-in dbForge for MySQL products. In the given worked example, we will move data from the actor table and the query result from the sakila database that exist on MySQL server to the SCOTT schema on Oracle server.

(more…)

New Features in dotConnect for Oracle 9.11

Devart is glad to announce the new version of our ADO.NET provider for Oracle with advanced ORM support – dotConnect for Oracle 9.11. The new release contains a huge set of new features, Direct mode improvements, and Oracle-specific technologies support: support for Oracle Sharding, Query Result Change Notification, OracleCredential class to specify password as a SecureString, SSL/TLS support in the Direct mode, .NET Standard/.NET Core support improvements, and many more.

(more…)

Entity Framework 6.3 and .NET Core 3 Support

.NET Core 3

.NET Core was presented by Microsoft in 2016, but its 1.x versions had limited set of features comparing to Full .NET Framework. Since then .NET Core has been drastically improved. .NET Core 2.0 has a significant part of Full .NET Framework features and includes new functionality and significant performance optimizations.
(more…)

Generating subscription statistics data in Oracle Data Generator

When you need to fill your databases with data for testing purposes, it’s usually quite handy to also have this data follow dynamic patterns like in real life. In such situations, records should both look realistic on their own and form a life-like overall picture. For example, if you want to fill your table with test data for an online service with a subscription model, the records would have to be dynamic from day to day. (more…)

How to Connect Oracle Autonomous with Oracle Client

Oracle Autonomous Database is a powerful technology that provides data processing and management in the cloud for self-driving, self-securing and self-repairing databases which can operate with no human intervention. So, it’s quite unsurprising that many want to know how to establish a connection between Oracle Client and Oracle Autonomous. Let’s take a look at how this can be achieved. (more…)

Achieve Enterprise-level Productivity with dbForge Studio for Oracle!

We are thrilled to inform our Oracle users that dbForge Studio for Oracle got a really massive update that took database development and presentation of the development results to a new level! By popular request of our users of the Professional edition of dbForge Studio for Oracle, we have developed the advanced features and implemented them in the Enterprise edition of brand new dbForge Studio for Oracle, v4.0. (more…)

New Look and Feel of Compare Bundle for Oracle

We are glad to announce the release of the updated dbForge Compare Bundle for Oracle. The tools of the Bundle, dbForge Schema Compare for Oracle and dbForge Data Compare for Oracle,  have been improved in-and-out. Besides the great new visual style, the tools include a bunch of new features and options that will definitely make your data and schema diffs management more smooth and convenient. (more…)

Create Unique Generators with dbForge Data Generator 2.0!

We are glad to notify our users that a new version of the Devart Oracle data generation tool has been released – dbForge Data Generator for Oracle, v2.0. The new version allows creating and saving your personal data generators, generating data to tables already filled with data, run data generation in a single click and much more! (more…)