By David Wiseman (Administrator)Created 09 Nov 2011, Modified 19 May 2012
My Rating:
Vote
Rating:
Not Rated
Views:6665
Downloads:12
Source:

Create SQL Compare Snapshot of all user databases

Language:  PowerShell

Compatibility

Windows XP Unknown Windows 2003 Yes
Windows 2000 No Windows NT No
Vista Unknown Windows 2008 Unknown
Description

Create a RedGate SQL Compare snapshot of all user databases on a given database instance.


Notes
Requires RedGate SQL Snapper Tool.  Download
 
Snapshot files created will work with Red Gate SQL Compare. 
 
Code

Line Numbers: On  Off      Plain Text
# Path to RedGate snapper tool (http://labs.red-gate.com/Tools/Details/RedGateSnapper)
$command= "C:\RedGate.SQLSnapper\RedGate.SQLSnapper.exe";
# Root path for snapshots.  Format is [RootPath]\[DatabaseName]\[YEAR-MONTH]\[DatabaseName]_[YEAR][MONTH][DAY]_[HOUR][MIN][SEC].snp
$path="C:\SQL Compare Snapshots\";
# SQL Server instance name. A RedGate schema snapshot is created for all user databases on this instance
$instance="LOCALHOST"

[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")
$sqlServer = new-object ("Microsoft.SqlServer.Management.Smo.Server") $instance
foreach($sqlDatabase in $sqlServer.databases) {
    # System databases, offline databases and snapshot databases are excluded
    If (-not $sqlDatabase.IsSystemObject -and $sqlDatabase.IsAccessible -and -not $sqlDatabase.IsDatabaseSnapshot)
    {
    $db=$sqlDatabase.Name;
    $fileName=$db + "_" + (Get-Date).ToString("yyyyMMdd_HHmm") + ".snp";
    $fullPath=[io.path]::Combine($path,$db);
    $fullPath=[io.path]::Combine($fullPath,(Get-Date).ToString("yyyy-MM"));
    
    [io.directory]::CreateDirectory($fullPath);
    $fullPath=[io.path]::Combine($fullPath,"$filename");

    [Array]$args="/server:$instance","/database:$db","/makesnapshot:$fullPath";

    & $command $args;

    }
}

 


Got a useful script? Click here to upload!


 

  Post Comment
Order By:  
User Comments
      

Posted On: 9/4/2018 1:01:42 AM

hogan gucci shoes softball bats new balance calvin klein outlet boy london clothing hermes bags nike air max 2017 kevin durant jersey wedding dress oakley sunglasses omega watches jordan 14 michael jordan tommy hilfiger converse all stars abercrombie clarisonic mia kenzo clothing basketball jersey montre homme nike blazer polo lacoste pas cher nike air zoom pegasus adidas outlet armani handbags nike roshe nike outlet cartier sunglasses ralph lauren outlet ferragamo belt dior sunglasses nike pas cher mont blanc pens rolex watches air max 2018 chrome hearts jewelry nike free cheap wedding dresses jordan 10 vans scarpe prada sunglasses burberry outlet cheap oakley sunglasses new balance femme fossil handbags nike vapor max oakley sunglasses celine handbags michael kors outlet online dak prescott jersey nike air oakley glasses new balance trainer replica watches air max babyliss pro nano titanium christian louboutin shoes karen millen adidas outlet store basketball shoes herve leger dresses marc jacobs handbags armani sunglasses ferragamo sunglasses converse uk england world cup jersey jordan 3 new balance shoes hollister outlet nike free run spain world cup jersey christian louboutin gentle monster sunglasses dolce & gabbana saint laurent handbags longchamp pas cher vans pas cher polo ralph lauren adidas zx flux mont blanc pens bcbg max azria g-star jeans arcteryx jackets coach purse coach outlet miu miu shoes mizuno running shoes adidas outlet store jordan 8 tory burch nike outlet online oakley pas cher nike shoes polo ralph lauren instyler pandora uk bose headphones true religion jeans chopard jewelry adidas crazy giuseppe zanotti outlet timberland boots mizuno true religion isabel marant shoes kate spade uk kobe bryant shoes nike air max 97 chloe handbags hogan shoes argentina world cup jersey lululemon outlet bally shoes insanity workout adidas running shoes ralph lauren lunette ray ban ralph lauren outlet new balance shoes polo ralph lauren kevin durant shoes swarovski jewelry supra shoes jordan xx9 givenchy jewelry 10 deep clothing kobe 11 air force 1 dansko outlet hermes nike shoes jordan 3 iphone x case jordan 4 ray ban sunglasses jordan 2 pandora bracciali chanel outlet beats headphones givenchy handbags nike air max antonio brown jersey timberland pas cher kobe 9 elite jordan 12 furla handbags nike clothing softball bats karen millen fitflops oakley vault lacoste jeans skechers sneakers beats by dre adidas shoes montre pas cher jimmy choo sunglasses oakley uk ghd hair straighteners longchamp outlet germany world cup jersey new balance soldes tommy hilfiger pandora jewelry kd 9 ray ban nike uk michael kors true religion christian louboutin lebron shoes jordan nike air max 90 vans outlet puma shoes france world cup jersey michael kors uk cheap jerseys michael kors outlet polo ralph lauren tory burch outlet nike air max mizuno nike air max jordan 1 bathing ape clarks shoes barbour nike mercurial nike outlet jordan 32 ray ban pas cher basket nike polo ralph lauren air force one mac cosmetics online adidas outlet store cartier bracelet mac cosmetics kates pade outlet online roshe run hermes birkin jordan pandora charms kyrie 4 tods shoes chloe handbags tn pas cher nike outlet nike air max alife clothing kids jordans jordan 7 soccer jerseys parajumpers fitflops insanity workout christian louboutin pas cher cheap oakley sunglasses guess handbags nike air max jordan pas cher jordan 6 sac longchamp salomon shoes giannis antetokounmpo jersey nike roshe run christian louboutin mulberry longchamp handbags nike free swarovski gioielli timberland boots brazil world cup jersey air max 95 converse jordan replica watches ralph lauren bulgari jewelry nike air force 1 aaron rodgers jersey rolex watches kevin durant shoes james harden jersey huf clothing nike huarache nike canada ray ban sunglasses gucci outlet jordan 6 coach outlet online air max guess air jordan true religion outlet nike blazer prada pandora jewelry goyard handbags nike air max 2017 curry 4 guess factory champion clothing burberry sunglasses cheap jerseys harry winston jewelry chloe sunglasses lebron 11 designer sunglasses michael kors uk abercrombie bcbg dresses christian louboutin yeezy shoes reebok outlet jordan 9 nike air max 95 prada outlet dyson hair dryer tory burch nfl jerseys dolce & gabbana orologi rolex converse outlet store supra shoes insanity adidas superstar bottega veneta sunglasses nike roshe gucci handbags converse shoes fendi sunglasses balenciaga sneakers true religion outlet burberry sale lululemon outlet nike air max ray ban sunglasses burberry beats headphones nike air max hermes bags nike blazer nike mercurial nike roshe run adidas trainers uk bottega veneta iphone cases lebron shoes cheap jordans toms outlet abercrombie adidas slides keen sandals nike outlet store guess canada burberry abercrombie and fitch carrera sunglasses michael kors outlet sac michael kors portugal world cup jersey fitflops outlet oakley sunglasses ai max ray ban sunglasses michael jordan nike mercurial superfly adidas soccer air max 90 occhiali oakley jordan 4 ferragamo lacoste shoes replica watches red bottom shoes prada handbags adidas soccer cleats chrome hearts jewelry michael kors outlet tiffany jewelry converse chuck taylor nfl jerseys asics gel adidas outlet store nike roshe jordan 5 chaussure nike longchamp bottega veneta coach factory outlet dsquared2 jeans salvatore ferragamo chi flat iron jordan shoes toms shoes ed hardy ferragamo marc jacobs handbags dolce & gabbana sunglasses michael kors canada gucci outlet sac vanessa bruno jordan lunette oakley kristaps porzingis jersey reebok shoes ghd flat iron barbour jackets cheap jordan shoes scarpe hogan chanel handbags belgium world cup jerseys manolo blahnik shoes swarovski crystal nike foamposite alexander mcqueen handbags air max 90 jimmy choo furla handbags hollister air more uptempo kate spade dansko shoes cheap wedding dresses nike free ray ban sunglasses dsquared2 outlet kyrie irving jersey michael kors handbags freshjive clothing golden goose sneakers nike roshe run air max plus ray ban occhiali prom dresses kd 10 longchamp handbags vibram fivefingers ferragamo shoes louboutin pas cher michael kors handbags carson wentz jersey dolce & gabbana adidas originals tommy hilfiger pas cher nike free run diesel jeans burberry outlet versace handbags converse curry 3 ray ban jordan clothing hermes jewelry bvlgari sunglasses armani jeans nike free run reebok shoes flip flops asics gel vans outlet chanel outlet true religion jeans curry 5 nike factory ferragamo shoes dior bags nike air max 90 valentino fendi handbags calvin klein jeans asics running shoes gucci belt nike store kobe 12 jordan 31 ai max adidas flip-flops beats pill links of london uk burberry clothing pandora bijoux oakley sunglasses marc jacobs handbags air max 90 adidas superstar stuart weitzman shoes nike kyrie 2 michael kors asics trainers jordan 13 mac makeup air jordan nike shoes curry 2 jbl headphones ghd fendi basket store louboutin outlet stuart weitzman jimmy choo shoes jordan 11 sac michael kors burberry handbags kobe 10 balmain jeans montres pandora charms bape clothing jordans mac makeup michael jordan adidas clothing longchamp outlet bijoux swarovski michael kors outlet michael kors 2018.9.4xukaimin


Posted On: 9/18/2018 2:17:08 AM

jinyi918 asics shoes nike shoes true religion jeans outlet kate spade coach handbags pandora charms nhl jersey manolo blahnik ralph lauren uk ugg boots ultra boost 3.0 ralph lauren polo pandora charms canada goose outlet coach outlet canadian goose coach outlet golden goose adidas nmd jordan shoes pandora outlet christian louboutin air max 90 ugg outlet coach outlet champion clothing christian louboutin outlet canada goose jacket christian louboutin longchamp outlet nike shoes canada goose outlet kate spade outlet true religion jeans nike huarache salomon shoes ugg outlet red bottom shoes coach outlet online coach outlet longchamp outlet basketballl shoes golden goose true religion hermes belt giuseppe zanotti christian louboutin north face true religion adidas outlet nike shoes ugg outlet clearance adidas yeezy canada goose outlet ralph lauren polo prada handbags coach outlet clarks outlet ralph lauren polo coach outlet pandora charms kate spade outlet michael kors outlet canada goose outlet canada goose outlet jordan 4 fitflops clearance ralph lauren ralph lauren polo coach outlet ugg boots ray ban sunglasses tory burch outlet coach outlet online dsquared2 adidas shoes louboutin shoes pandora jewelry moncler outlet ralph lauren polo nike outlet factory hugo boss canada goose jackets red bottom shoes michael kors outlet nike shoes red bottom shoes bottega veneta nike tn coach outlet factory coach outlet golden goose true religion jeans michael kors outlet jordan uk superdry uk supreme clothing canada goose outlet christian louboutin outlet ray ban sunglasses fitflops clearance ugg boots clearance hermes belt ralph lauren uk clarks outlet christian louboutin outlet clarks shoes converse trainer mbt shoes off white outlet coach outlet canada goose outlet coach outlet tod's outlet salomon shoes nike blazers coach outlet moncler outlet jordan shoes north face true religion jeans champion sportswear ecco shoes ugg boots clearance ugg boots off white clothing christian louboutin outlet ed hardy uk nike air max canada goose outlet ugg outlet boots coach outlet skechers shoes christian louboutin outlet christian louboutin shoes mbt shoes off white jordan pandora outlet moncler jackets reebok outlet ralph lauren polo moncler outlet jordans coach factory outlet longchamp moncler outlet moncler jacket jordan shoes nike outlet kate spade outlet kate spade handbags coach outlet hugo boss soccer shoes mlb jerseys clarks shoes prada shoes pandora jewelry off white shoes ralph lauren uk coach outlet online moncler outlet kate spade outlet ferragamo shoes lacoste polo ray ban sunglasses coach factory outlet pandora outlet louboutin shoes ugg outlet golden goose christian louboutin outlet michael kors outlet ecco shoes ugg outlet christian louboutin jordan shoes jordans valentino shoes supreme michael kors outlet kate spade outlet canada goose adidas yeezy coach factory outlet canada goose outlet fitflops clearance vibram five fingers coach outlet canada goose coach outlet online nike shoes canada goose canada goose outlet louboutin shoes coach outlet ralph lauren polo ray ban sunglasses ray ban sunglasses moncler jackets adidas superstar pandora charms pandora supreme clothing coach factory outlet nike shoes outlet oakley sunglasses christian louboutin shoes dsquared2 jordan 8 ferragamo belt true religion jeans outlet ugg boots outlet fitflops clearance ralph lauren polo issey miyake pandora jewelry yeezy boots 350 air max 90

daisyjane2018
Posted On: 11/9/2018 1:28:35 AM

The league announced the news this morning, writing in a press release that,cheap authentic jerseys "Beginning Friday, November 9, NFL team 'outfits' will be available in the cheap nfl jerseys Shop. This unique opportunity will give Fortnite players the ability to purchase and customize up to eight outfits representing their favorite NFL teams."cheap jerseysWe're just getting started, though! There will also be "football-themed emotes, harvesting tools, gliders, and even a referee outfit." cheap sports jerseys Even a referee outfit! cheap jerseys from chinaSo there you have it, Fortniters (Fortnitees?). Your prayers have been answered. Everyone gets their favorite team's football jersey,wholesale jerseys and themed emotes, and harvesting tools, and gliders. Click here to choose the new cheap authentic jerseys from china and wholesale nfl jerseys! Receive comprehensive coverage of the Bears and stream the ‘Football Aftershow’ easily on your device.click here cheap authentic nfl jerseys.It's not a giant surprise,custom cowboys jersey but it's still impressive to see. Fortnite is hugely popular among professional athletes, and it's football season,discount jerseys after all. Epic Games just announced an official partnership with the NFL to bring licensed jerseys to the popular battle royale game, letting players don the jerseys of their favorite teams as they blast each other into oblivion.discount nfl jerseys cheap nfl jerseys cheap jerseys cheap jerseys from china wholesale jerseys cheap nfl jerseys from china china jerseys nfl jerseys china wholesale nfl jerseys cheap authentic nfl jerseys cheap jerseys online cheap authentic jerseys cheap sports jerseys cheap wholesale jerseys china wholesale jerseys discount nfl jerseys cheap authentic jerseys from china discount jerseys custom cowboys jersey Click here GOOGLE FACKBOOK Amazon nfl jerseys cheap cheap college football jerseys cheap nfl jerseys china cheap football jerseys custom jerseys cheap cheap nfl gear cheap nfl authentic jerseys cheap jerseys nfl nfl football jerseys cheap cheap nfl football jerseys cheap nfl jerseys free shipping cheap nfl nike jerseys custom nfl jerseys cheap nfl cheap jerseys