SQL Server Toolkit 5-1 for MSSQL, the review

Hi Guys,

Have a good week first of all!

In this post, I want to introduce you to a toolkit called Stellar Toolkit for MS SQL. This toolkit contains 5 software that are useful in many critical situations, such as:

To repair corrupted SQL Server database
To extract database from corrupted backup
To convert data from database to Access, SQLite, or SQL Anywhere
To inspect the SQL Log file
To reset the password of MS SQL Server  

Enjoy the reading!


Installation of the Toolkit


Like other Stellar products, installation of this toolkit is simple. You just need to download the software from here. The size of the file is small.




Once the .exe file is downloaded, just double-click it to open the setup wizard.

 



Then, click on the Next Button.


 
You must accept the license agreement and press the Next button.


 
Now, if needed, you can change the default location. Then, press the Next button.

 


You can select a location to create program shortcut or let it create in the Start Menu folder. Then, press Next.

 




Finally, press the install button.

 


After some seconds, the installation will be complete.


 

Review of Stellar 5-1 Toolkit


I must admit that while reviewing a product, especially when it comes to giving judgment, I always find myself in a bit of trouble because a product is always the result of work of many people (programmers like me). Also, the judgment can only be a bit subjective.

In this case, I must say that the task was easier than usual because the software provides only useful and well distinct functions. In addition, the operation is intuitive.

I like clear interfaces just like the one in this software. The software’s main interface provides 5 buttons for 5 functions. Therefore, making mistake is not possible.


 
Now, let's see these 5 features one-by-one.

1. Repair MS SQL Database


This is undoubtedly the main and important function of this software. This same function (with the same interface) is also present in a separate stand-alone product that I have already reviewed on my blog here.

Clicking the button on the left of the main window allows you to execute the “repair a corrupted SQL Server database” function. To do this, the software does not rely on SQL Server (which may not necessarily be present) but parses the database (mdf) file.

Recovery takes place in two stages. First, all the data is read and stored. In the second stage, the data is saved. You can save the data in a new MS SQL Server database or even in other formats.

A little more detail.

As soon as the program starts, it asks you to indicate the path where the corrupt mdf file is located.

Obviously, the file must not be in use. 


When you press the Repair button, the mdf file is parsed and every MS SQL Server object is read.
On the left panel, you will have a tree structure where you will see the list of the objects retrieved (tables, views, etc.).

 


Pressing the Save button saves the data. You can save the data in a new SQL Server database or in other formats.


2. Extract from MS SQL Backup


This tool allows you to read data directly from a MS SQL Server database backup. The good thing is that the software reads the data from a corrupt backup file. This is great!

You will have already understood how this toolkit works. Just click the Browse button and choose the backup file to process.


Two scan modes are present - Standard and Advanced.



Choose the scan mode according to your requirements (I chose the Advanced Scan option) and press the OK button.

 


The process will begin when you hit the Next button. A message will appear when the process is complete. 




Click the Save button to save the data. 




I must report only small cons in case of compresses databases. In fact, compressed files are not supported. If you try to process a compressed file, you get this message. 




3. Converter for Database


The converter for database tool allows you to easily copy data from different formats. The interface is clear as usual.

You can choose to read data from an MS SQL Server database, either from mdf file or read it directly from the database (live mode).




If you choose live mode, you just have to specify the server name, the authentication mode, and then choose an existing database.




When you press the Scan button, the program will start reading the system structure.
 


 

Select which table to convert and press the Convert button to start the conversion.
 




4. Log Analyzer for MS SQL

This software is used to show the content of log file of an MS SQL database. Just click the Select LDF button and choose an ldf file to inspect. The file must not be in use.

 



Simply click the Analyze button to start the process.


Finally, press the Save button.


5. Recover MS SQL Password


This is the latest feature of this toolkit. It helps you to change a user's password.


By clicking the Browse button, you can choose a master.mdf file. Then, a list of users will be displayed.



Simply choose a user and click the Change Password button.


Conclusion

From my point of view, if you work with MS SQL Server, this is definitely an indispensable tool at hand.

You can recover or repair MS SQL Server database. You can also read data directly from MS SQL backup or export data in various formats. And finally, you can restore passwords. Furthermore, it is clear and easy-to-use.


For these reasons, this software deserves my personal 5-star badge.




That's all for today friends and stay tuned for the next post!
If you ejoyed this post please follow me on linkedin.

Thank you,
Luca








Previous post: SQL Server, the Row Count Spool (explained in a simple way)





 

Comments

Post a Comment

I Post più popolari

SQL Server, execution plan and the lazy spool (clearly explained)

Image
Hi Guys, Welcome back! In one of the last posts we talked about Table Spool . We had explained what Spool are for by telling the somewhat curious story of the halloween problem . Here we specifically talked about a type of spool called Eager Spool   You can look to the execution plan below where the eager Spool is used to avoid the halloween problem in classic query of the "salary increase".. i suggest Well, if the story of the eager spool intrigued you, today instead we will speak about another type of Spool, the Lazy Spool . The Lazy spool Let's take a small step back. So, what is a Spool operation?  As we have already understood a spool operation is simply a temporary storage of data . Data are read from a source table and stored inside a worktable in the Tempdb database . While an Eager Spool is used to prevent the Halloween problem, the Lazy Spool is instead used to store data that will later be needed again when running a query . So, when a Lazy spool is used?  ...
Read more

SQL Server, datetime vs. datetime2

Image
Hi guys, This time, in this post we will speak about datetime and datetime2 datatypes. We will talk about the pros and cons. We will talk about all the differences between the two types of data. Write me in the comments which type of data do you prefer between the two. Enjoy the reading!     Datetime Vs. Datetime2 First of all, it must be said that the datatype datetime is certainly the best known native format for storing a date in SQL Server. However, Microsoft has also been introducing a new type of data for many years now, also used to manage dates. It is in fact from SQL server 2008 that it is present in datetime2 data type. This "new" type of data was born primarily to have higher accuracy . Let's in fact talk about ... precision ! Datetime Certainly the datetime data type is not very precise and certainly there are many cases in which its precision is simply not sufficient. Let's see it with an example. Open the SQL Management studio (SSMS) and write the fo...
Read more

La clausola NOLOCK. Approfondiamo e facciamo chiarezza!

Image
Ehi ragazzi! La domanda è di quelle importanti! Siete pronti per scoprire tutto ma proprio tutto sulla clausola NOLOCK?   Se la riposta è si, allora seguitemi! Oggi ne spiegheremo il funzionamento in maniera approfondita. Faremo una introduzione al concetto di tipi di LOCK Ed infine vedremo come mai una SELECT ne può bloccare un'altra. Non vi nascondo che il motivo di questo articolo è fare chiarezza. Su questo argomento si sentono spesso affermazioni “curiose” ma tra le tante questa è la prima: “ uso la SELECT con l’opzione WITH(LOCK) così non blocco le altre tabelle ”.   Ma, è proprio vero quanto affermato? Beh oggi facciamo il punto!   Buona lettura!     La clausola NOLOCK Diciamo subito per iniziare che cos’è la NOLOCK. NOLOCK è il nome di una clausola che è possibile specificare all’interno di uno statement di tipo SELECT utilizzando la seguente sintassi: SELECT * FROM TABELLA WITH (NOLOCK) Si noti che non possiamo ...
Read more