Category «Database»

Data Virtualization in SQL Server 2019

SQL Server 2019 CTP 2.2 has lots of enhancement in particular Data Warehouse(DW) and Big Data management. This post is not a “what’s new in…” post so after some brief explanations we’re going to create “virtual tables” in SQL Server that represent MongoDB table and will be able to query from SQL Server to data …

Database Replication with ArcServe RHA

Surely replication isn’t a HA solution by itself in DBA world and besides 3rd tools, SQL Server have lots of option for replication but these will not the issue in this post.  However, strict requirements and as transactional replication doesn’t support tables without primary key in native SQL Server replication, that’s why 3rd solutions are …

Oracle – Migrate Data from 11g to 12c Database

Oracle SQL Developer Tool has Import and Export ability to transfer data between different version of Oracle DBs. In this post you can briefly find the some details of migration data from Oracle 11g (+Express) to Oracle 12c. Connect to both 11g and 12c DB instance and click Data Pump Export Jobs in DBA section: …