Idera – SQL Virtual Database working with SQL Server and PowerShell…

 

Get PowerShell V2

Get it Here!!

 

Yes, Idera has done it again! This new product may make you think of all possibilities to help you get information from any SQL backups without restoring.  Please take a look at Pinal Dave (SQL MVP) blog on “Idera Virtual database”.  It’s an excellent blog!!

Now, using the Idera “SQL Virtual database” application is very simple to use.  Here’s a quick sample using the GUI:

Perfect, I got my first SQL Virtual Database connected and accessible on SSMS.  Here’s some of the things I found out that when I created my SQL Virtual Database:

1. It will not consume any of your disk space.

2. if you don’t want to copy over a database to your local drive then you can create a SQLvdb from a network drive.

3. The SQL Virtual database can be accessible from your SQL Server Management Studio (SSMS) like a normal database.

4. If you update any records in a table, it won’t be saved when you disconnect from the virtual database.

5. And, it does provide a command-line version “SQLvdbCLI.exe”, which you can run from PowerShell.

6. It’s proven is faster to create a virtual database than to do a restore and without taking over your disk space.

Now, let see how we can use SQL Virtual Database command-line in PowerShell.  Use the “SQLvdbCLI.exe” at the console prompt  using the “-help parameter to access the text help documentation.  Again, this command-line help is only available at the prompt.

Let me give you an example in how to create a SQL Virtual Database using the command-line:

SQLvdbCLI -Create -Full Z:\Databases\backup\Developer.bak -Instance MAX-PCWIN1 -Db Developer_Virtual

 

Now, let use SQLPS to connect to our local SQL Server and confirm that we can get to our SQL Virtual Database “Developer_Virtual”:

Although, in above picture I’m doing CD “Change Directory” to show that you can navigate into my SQL Virtual Database, you can have navigate directly to the tables folder by using one-liner from the PS> prompt:

PS> CD SQLSERVER:\SQL\MAX-PCWIN1\Default\Databases\Developer_Virtual\tables

PS> Dir | Select –first 10   #- to list the first 10 tables

But, if you have use SQLPS loading the SQL Server snapins and provider from your PowerShell Console (not SQLPS.exe by itself).  Then, you can query directly to the database using the cmdlet “Invoke-SQLCmd” and get instant results:

So, as you can see this tool can be a very useful not only to the administrator but also for the developer.

Please, go ahead, download the evaluation and give it a test drive.  I’m sure you will love it too and you will find a practical way to use it with PowerShell.  I definitely GUARANTEE it’s a good match and it l save you time when automating a task.

Advertisements

About maxt2posh

I’m from Puerto Rico, have been working with computers since 1979. Throughout many years, I have worked with SQL Server Technologies, provided support to Windows Servers/Client machines, Microsoft Virtualization Technologies, and build some Visual Studio solutions. I’m a Microsoft PowerShell MVP since 2009 and MVP SAPIEN Technologies since 2010. I speak in most of the SQLSaturday, IT Pro and .NET camps events around the Florida’s State. Also founder of the Florida PowerShell User Group which meeting every 3rd Tuesday evening of the month.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s