Search results for 'sectionid:198' matching tag 'DBA'

Re: generate sql server all databases script

Cvakumar — Mon, 26 Nov 2012 06:00:00 GMT

Hi,

To genereate sql(2008) db script for all databases(Single Instance) using powershell script.

Regards,

Sivakumar.T

SQL_DBA

generate sql server all databases script

Cvakumar — Sat, 24 Nov 2012 06:00:00 GMT

Hi,

We need generate sql serve all databases script using powershell. Because every day we have changed database procedures,tables we will change.

Now we manually taken databases scripts.

We want sheduled job for generate all databases scirpts using powershell.

Please reply.

How to get the "Analysis Server Properties"

Nik — Thu, 02 Aug 2012 05:00:00 GMT

Hi All i have to collect the SSAS properties ("Analysis Server Properties") into a SQL table , i can not find any DMV to get the "Analysis Server Properties" but i am assuming it can be done with PowerShell, can anyone help?

I also need the "SSAS Database Properties".

bottom line i will be using SSIS to collect the data.

SafeToSQL utility in a powershell script

miklaw2 — Wed, 31 Aug 2011 05:00:00 GMT

We have Idera's SQLSafe product and we want to run their SafeToSQL utilty to change the Safe file into a .bak file

I can run the command from the command prompt fine.. but it doesnt work from powershell I am unsure what cmdlet I would use to get it going. I have tried:

invoke-expression and invoke-item and I am not sure that they will work or not but right now its a not....

Here is my script

$tool= 'C:\Program Files\Idera\SafeToSQL\SafeToSQL.exe'

$cmdLine = 'V:\SQL\QA\TMW3\Backup\Current\AtlasENewsQARecent.safe'

##invoke-expression -command "$tool $cmdLine"

invoke-item "$tool $cmdLine"

any help or direction you can provide would be awesome. Thanks

Query Oracle database with PowerShell

ByteBlock — Sat, 05 Feb 2011 06:00:00 GMT

Dears,

please could anyone help me with the following? As usually when asking on forums - I'm desperate unable finding a solution :-)

I simply need to access and retrieve any data from an Oracle Database.

I downloaded Oracle express edition and Oracle client - both the most recent versions. There is a default database with some default tables. I configured the users and am able to access the data via default web interface.

I tried about at least 50 different ways to connect to Oracle from PowerShell. Tried to use different providers, either OLE DB, Oracle .NET provider and others with no avail.

Basically I'm getting the error about resolving TNS names (I googled for this and followed the steps to troubleshoot - didn't help). I reinstalled Oracle several times just to make sure it's clean installation, tried to install it on some virtual machines - always the same result.

I also tried milion connection string combinations for different providers. I guess I'm missing something very basic, but as I don't have much experience in DB access, I'm not able to figure it out.

I will appreciate any working solution which doesn't need to install a lot of 3rd party software - some powerpacks are ok, but I can't install some advanced Oracle troubleshooting/managing/diagnostic tools. Besides that I believe the DB itself is ok.

One note - I'm using PowerGui if it could affect the functionality somehow (it did happen to me in the past, so I rather mention it here too).

The only "progress" I made is that now I'm getting the error message "Connection not open" instead of the problem with TNS names. Here is the very basic part of the script:

[System.Reflection.Assembly]::LoadWithPartialName("System.Data.OracleClient")

$connectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=ono-sendai)(Port=1521)))(CONNECT_DATA=(SID=xexdb)));User ID=sys;Password=abc"

$connection = New-Object System.Data.OracleClient.OracleConnection($connectionString)

$queryString = "SELECT COUNT(LAST_NAME) FROM EMPLOYEES"

$command = new-Object System.Data.OracleClient.OracleCommand($queryString, $connection)

$connection.Open()

$employeesNames = $command.ExecuteScalar()

write-host "Number of employees: "$employeesNames

$connection.Close()

$Error[0] | fl -Force

Infinite grace and many thanks to anyone able to help me :-)

Martin

TSQL Formatter

elephant_shoes — Mon, 29 Nov 2010 06:00:00 GMT

I am in the process of converting all my usual monitoring to powershell when I got thinking about how easy it may be to write something to reformat tsql queries based on my development standards. I have used a few different products in the past, but none are flexible enough to exactly conform to the standards we have here. Might make someone's job easier if they could run a query through a powershell script and just do a blanket refractoring...

Anyone start anything like this yet?

Re: Failed job steps in SQL Server

realgnomidad — Wed, 10 Nov 2010 06:00:00 GMT

I second this question, it would be helpful for me as well. I'm also interested in learning how leverage SQL Central Management Server and Powershell.

Write to SQL Database

whitehs — Wed, 10 Nov 2010 06:00:00 GMT

I am creating a powershell script to check a random set of SQL Server database backups, so that I can confirm that the backups are successful. Process is retrieve list of last nights backups from a central database, then copy the backup file to a dev machine, restore the database to the server and run a DBCC CHECKDB command on the restored database. I have the results of the DBCC CHECKDB command stored in a datatable, but I cannot get it to write these details back to my central database.

What's the best way to do this? I was trying to use Chad Miller's Write-DataTable.ps1. Any help would be appreciated.

Re: Change service applicaiton account

Donabel Santos — Thu, 21 Oct 2010 05:00:00 GMT

In a nutshell, this may be what you are looking for:

$servicename = "SQL Server";
$serviceaccount="domain\username";
$password="password";
$filter = "Name='" + $servicename + "' ";

$sqlservice=Get-WMIObject win32_service -filter $filter
#if service is running, stop it
if($sqlservice.State -eq "Running" -or $sqlservice.State -eq "Started")
{
   $sqlservice.StopService();
}

#change service account, then restart service
#note quite a few $null parameters, this is because you can change other service properties 
#(for ex, Start Mode, Display Name)
#when you use the Change() method
$sqlservice.change($null,$null,$null,$null,$null,$null, `
                             $serviceaccount,$password,$null,$null,$null);
$sqlservice.StartService();

Have a look at the Change-ServiceAccount script posted by Brian Hagerty in PowerShell.com's script library:
http://powershell.com/cs/media/p/3846.aspx