In dbForge Studio for MySQL you can find Data Compare, a tool which allows you to compare and analyze tables data in databases, for example, to check that data in the synchronized databases are identical. Besides, it allows synchronizing the data differences to get identical databases. The following picture illustrates comparison and synchronization of two MySQL databases.
Users often ask us how to use Oracle stored routines, returning REF CURSORs, in Entity Framework models with dotConnect for Oracle. So, we decided to post here a walkthrough, that describes how to create Entity Framework model with stored procedures in Entity Developer and EDM Designer. It tells how to create methods, based on Oracle stored procedures and functions, returning REF CURSOR parameters, and how to use the stored procedures for mapping insert, delete, and update operations.
In order to complete this walkthrough, you will need access to the Oracle database server 188.8.131.52 or higher. You also need dotConnect for Oracle Professional Edition 5.25 or higher. Microsoft Visual Studio 2008 SP1 or Visual Studio 2010 is also required.
Devart has released today the updated version 3.50 of dbForge Fusion for MySQL – a powerful add-in for Microsoft Visual Studio or CodeGear RAD Studio, designed to simplify MySQL database development and enhance data management.
Up to 100 usability improvements have been implemented, so you get better insight and satisfaction as well as a total control over performed tasks through the modernized UI of dbForge Fusion for MySQL.
Striving to speed up performed tasks, dbForge Fusion offers compression to reduce traffic, while exchanging data with MySQL server, and makes the exchange quicker.
The new features of dbForge Fusion for MySQL 3.50 include:
Recently, we were updating our own database used for dbForge Data Compare for MySQL testing. I wanted to add several tables with data, using a dump file of one of the tables.
But how to drop a millisecond part in every pasted string, I mean a date like ‘2006-12-24 15:35:19.658′ should be replaced with ’2006-12-24 15:35:19′ one?
Any simple Find and Replace functionality won’t help, as I don’t know what to find and with what to replace.