Skip to main content

SqlDbAid DBA tool


Latest version (v2.6.1.1 - 2018-02-10) SqlDbAid.zip

SqlDbAid is an intuitive standalone application that will enable you to easily script database items and data.


SqlDbAid is free for personal and commercial usage.


Main Features
  • SQL Server 2005+ support
  • Text search inside code definition with highlitghting
  • DBA reports (missing indexes, missing foreign key indexes, indexes status, top queries, table MBytes)
  • One file per object or single file scripts (tables, views, triggers, procedures, functions, indexes...)
  • Select, Insert and Update scripts
  • Table data insert script creation
  • Table/View data export
  • Offline database compare tool

Requirements
  • .Net Framework 4.5+
For questions and suggestions write to Miken.

Comments

Popular posts from this blog

Columns Inconsintency Check

Another hopefully useful script  from my toolbox.

Recently I had to check a quite denormalized database at the end of its development phase.

Frequently data types, length and other field attributes change during development, so I wrote a simple script that highlights possible mistakes (same column name but different definition).

UPDATE: system objects skipped

;WITH cte AS (SELECT c.NAME cl_name ,Schema_name(t.schema_id) +'.'+ t.NAME tb_name ,p.NAME [type],c.max_length ,c.scale ,c.PRECISION FROM sys.tables t INNER JOIN sys.columns c ON c.object_id = t.object_id INNER JOIN sys.types p ON p.user_type_id = c.user_type_id AND p.system_type_id = c.system_type_id WHERENOT( EXISTS (SELECT1FROM sys.extended_properties EP WHERE EP.major_id = t.object_id AND EP.name ='microsoft_database_tools_support')OR t.is_ms_shipped =1))SELECT DISTINCT x.*FROM cte x INNER JOIN cte y ON y.tb_name != x.tb_name AND y.cl_name = x.cl_name AND( y.max_length != x.max_length O…

Free SQL database compare tool

Hi All, SqlDbAid now comes with a new database compare module.


The comparison uses an offline mode like the previous version,
but now you'll be able to visually analyze the differences.


All you have to do is connect to two databases, select the objects
you want to examine and then create two compare exports.


These files will be the input for the compare module.