How To
How To Configure Oracle Instant Client
This article is a step-by-step instruction for configuring Oracle Instant Client so that our tools for Oracle could work with it.
1. Download Oracle Instant...
Table-per-Type vs Table-per-Hierarchy Inheritance
In this article we will compare the performance of both most used inheritance types - Table-per-Hierarchy (TPH) and Table-per-Type (TPT), supported by LinqConnect starting...
Entity Framework: SQL Generation Enhancements for IN Clause
Introduction
Collection with unique elements
Two and more collections with the repeated elements
Optimization of the query without obvious collection
Oracle-specific SQL
The...
Refreshing Objects of SQL Server Databases
This article describes how to update the metadata for non-schema-bound objects of a SQL Server database: views, DML triggers, procedures, functions, or DDL triggers.
Entity Framework: Tips and Tricks, part 3
This article continues series of publications about non-trivial Entity Framework situations encountered by our users.
We consider the following questions in this article:
Why Oracle...
Loading Oracle LOB Data – Code Samples
Recently we were working over the release of the version 2.0 of dbForge Data Compare for Oracle. One of the main features added to...
How To: Create a MySQL Database Diagram Using a Sketch Image
With Database Designer database can be created from a sketch without using any external image-viewers. Database Designer tool available in dbForge Studio for MySQL serves for creating database diagrams visually.
Oracle DBMS_COMPARISON package overview
This article describes how to set up table data comparison by help of Oracle package and synchronize data in case of differences.
10 Ways to Synchronize Oracle Table Data
The article describes such ways of data synchronization of Oracle databases as Advanced Replication, Oracle Streams, GoldenGate. Also it gives a brief comparison of shortcomings and benefits of each way for data comparison and synchronization tasks when developing and testing databases.
How To: Disable All Foreign Keys in Oracle Scheme
When you perform data maintenance operations, sometimes, it's necessary to disable or enable all foreign keys in the user schema.
Here is the script that...
