Tool

Before discussing features of SQL Server database diagrams, it would be better to clarify a couple of messages that you may face while working with SQL Server database diagrams. Confirmation message while working with database diagrams in SSMS The first time you click on the Database Diagrams folder…

This documentation is archived and is not being maintained. SQL Server 2012 Microsoft SQL Server provides two different environments for building, deploying, and managing Analysis Services solutions: SQL Server Data Tools (SSDT) and SQL Server Management Studio. Both of these environments implement a…

From a remote shell to your device or from your host machine, you can use the sqlite3 command-line program to manage SQLite databases created by Android applications. The sqlite3 tool includes many useful commands, such as .dump to print out the contents of a table and .schema to print the SQL CREATE…

Many people would like to know the Principles of blockchain technology . But what is a blockchain? The Blockchain is a public database of transactions in the Bitcoin system. With its help each user can know how many Bitcoins were in a particular place in a particular period. The Blockchain can be used…

Guest post This is a guest post from Phil Factor. Phil Factor (real name withheld to protect the guilty), aka Database Mole, has 30 years of experience with database-intensive applications. Despite having once been shouted at by a furious Bill Gates at an exhibition in the early 1980s, he has remained…

In fact, bitcoin is a standard computer program. It is not located only on a particular computer or server, it is located on millions of computers which directly communicate with each other through this program. Torrents work on the same principle. You install the program, and someone else does the same…

In a previous post, we looked at the limitations of native audit, the free tool often used by database administrators (DBAs) for logging database activity. While it has its appeal—it’s already part of the database server and does not require additional cost for third-party appliances or software—native…

Posted by Bill Ramos | On January 27th, 2017 | In Database Migration, Database Upgrades | Tags: data migration, Database Compare Suite, database migration, DB2, MySQL, Netezza, oracle, PostgreSQL, Redshift, sql server, sybase, Teradata Many of us regularly use Database Compare Suite — a tool developed…

Select the database(s) you want to move or copy from the source server to the destination server. See at the top of topic. Move Move the database to the destination server. Copy Copy the database to the destination server. Source Displays the databases that exist on the source server. Status Displays…

For those of you who attended last week’s webinar, Marketing Automation and CRMs: Terrible Twosome or Dynamic Duo? , you may remember a short discussion of the importance of keeping your database clean. It may seem like common sense, but many marketers overlook the benefits of a clean database, like…

After that you should choose Source Connection and Target Connection from the existing connections. Also you can choose object types to compare during this step. Available object types are Tables, Views, Indexes, Package Spec, Package Body, Procedure, Functions, Triggers, Types, Sequence, Materialized…

Cbattlegear is correct - the process is not yet integrated into a single tool. Currently the Split/Merge tool only handles the data movement operations. However there is a Powershell example of orchestrating the entire process - including provisioning the target databases, adding it to the shard map…

We are excited to announce the availability of an in-browser query tool that provides you an efficient way to execute queries on your Azure SQL Databases and SQL Data Warehouses without leaving the Azure Portal. This SQL Database Query Editor is now in public preview in the Azure Portal. With this editor…

Schema Comparison Tool Schema Comparison Tool allows you to compare tables, views, functions, sequences, packages, stored procedures and other database objects between two schemas/databases. It will report any discrepancies between schemas such as missing or mismatching stored procedures, tables, triggers…

The RazorSQL ODBC database query tool provides the ability to connect to databases via ODBC for Windows machines. Users can set up user, system, or file dsn ODBC datasources on their machine via the Windows ODBC datasource control panel. After the datasources are set up, RazorSQL can make an ODBC connection…

How many times it happens that the code changes have been deployed to the production server, but schema changes are not rolled out and it has resulted in chaos? How many times you could not reproduce the scenarios on test servers that is producible on production servers? How many times do your applications…

Today during the Visual Studio launch event, we announced that we’ve partnered with Redgate to include Redgate Data Tools in Visual Studio 2017. Redgate Data Tools includes three components that extend DevOps practices to SQL Server and Azure SQL databases and increase your productivity while doing database…

One of the coolest hidden tools in SQL Server 2005 Express is Database Diagrams, a database-design tool that lets you visually lay out your database tables and their relationships. When you save your diagram, the tool generates all the database objects that you included. You can use the tool to create…

For all Mac users running Pro Tools, PT Prefs Helper is an application you should not be without. It enables you to keep copies of all kinds of Avid related files so that when Pro Tools starts misbehaving and you need to trash the Preferences etc, you can then also restore a good set, rather than having…