In this video, will talk about how to manage database changes with help of dbForge Source Control for SQL Server and Git repository that is being hosted by Microsoft Visual Studio Team Services. This is an entry-level demo that would be suitable for anyone who doesn’t currently using a version control system, or using it for the application only, and not the database
Devart was a sponsor of SQLSaturday#660 held on August 19, 2017, in Lviv, Ukraine. We were very glad to take part in this event, talk to users of our products, make new acquaintances and support our Ukrainian SQL Server community. We would like to thank the organizers of the event: Sergey Lunyakin, Andrey Zrobok, Oleg […]
Very often, there is a need to compare or synchronize data between two databases on the same server. To detect differences, you can simply use dbForge Data Compare for PostgreSQL, which allows you to perform this process with a few clicks. However, what if we need to compare data of multiple target and source databases […]
Devart company provides solutions for SQL Server: - dbForge Tools - an ultimate set of products for SQL Server development, management, and administration https://www.devart.com/dbforge/sql/#sqltools - SSMS add-ins include tools for version-controlling and unit-testing SQL databases, importing and exporting data, analyzing and fixing index fragmentation and searching for SQL objects and data i...
There are a number of challenges while collaborating on database development. When someone in a team changes database objects in a shared database, another team member may overwrite those changes. This will lead to the data loss. The best way to resolve such challenges is to start using database version control. This video demonstrates how to start source controlling your SQL Server databases. Lea...
Devart company provides solutions for SQL Server databases: - dbForge Tools - an ultimate set of products includes applications and IDE add-ins for performing database development, management, and administration tasks https://www.devart.com/dbforge/sql/ - SSMS add-ins include tools for version-controlling and unit-testing SQL databases, importing and exporting data, analyzing and fixing index fr...
While developing a web application, you need to make sure you are testing it under conditions that closely simulate production environment. Without meaningful test data in test environment, it is quite impossible to predict the way the application will behave after the release. During this session, we will talk about how to generate real test data to be used in the test environment.
In this post, we are going to explore the way of how to import a .csv file through the command line in dbForge Studio for MySQL. You will not have to waste your valuable time on manually specifying properties each time you need to create a new MySQL table. With this option, you can forget […]
SQL Saturday #616 was the biggest training event for SQL Server professionals and those wanting to learn about SQL Server in Ukraine. The event was held on May 20, 2017, in Kiev, Ukraine. We would like to thank the organizers of the event – Denis Reznik, Eugene Polonichko, Eugen Niedaszkowski, Alesya Zhuk, Nick Pobyivovk, Oksana […]
The Devart company released UniDAC with support for Linux 64-bit platform. UniDAC makes application development and maintenance easier and simpler because the use of the Direct mode in a custom application does not require the installation of client libraries, additional drivers, etc. This helps to avoid the overhead when accessing a DBMS, hence increasing performance. […]
Custom relational management is very important once you run a business. It helps to improve marketing strategy, sales and customer service. Today there are many systems providing Cloud-based CRM services on the market. The main benefits of using these systems are scalability, costs, and integration with commonly used office applications (e.g. MS Excel, Access and […]