Friday, February 26, 2010

Have you ever used a Virtual Database?

During the last decades, The concept of Virtualization covered most of the fields/ elements  of the IT field, starting from virtual hardware devices, operation systems and software simulation.
But, Have you ever used a VIRTUAL DATABASE?

I found a nice article demonstrating a Virtual Database tool. The company called Idera produced a tool that attach a backup file to the SQL Server and it appears as a normal database. You can run queries, run any third Party tools directly against this database.You can do all these steps in less than 3 minutes.

But, Why I need to use a tool like this?
The big advantage of a tool like this is Save your time (Time is money).
If you are working in a project and you have a production database backup, with a size 15 GB, and you want to synchronize the latest changes from the development instance.
Here is the traditional steps to do this.
1- Create a new database.
2- Restore the production database backup on the new database.
3- Synchronize the changes between the two databases.
4- Save the synchronization SQL Script.

But with a third party tool like this:
1- Attach the backup file directly to the SQL server.
2- Synchronize the changes between the two databases.
3- Save the SQL Script.

You could say, I only saved one step out of 4.
I can tell you, from my experience, the longest step in all these 4 steps is step number 2.
So you removed the longest step, which usually takes about 10 minutes and my be more for the large size databases.
 There are many tools in the market doing this job. One of the greatest companies is Red Gate.
I am using the tools from Red Gate since 2 years, which solve all my hard SQL situations easily and in short time.

Any comments would be appreciated.

No comments:

Post a Comment