Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Migration Rss

Search for any content tagged migration

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 6 of 6   
 

Script Login Differences

Compare the logins and users on two instances and generate a TSQL script to make them the same.  Read more...
By Richard Fryar 2013/11/26 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 1,505 reads

sa_help_rev.erse.sa.login

A script to generate a recovery script for setting your sa account back to the password it is using at the time of running this script.  Read more...
By James Marsh 2012/05/14 | Source: SQLServerCentral.com | Category: sa
Rating: |  Discuss |   Briefcase | 915 reads

Generate MERGE statements with Table data

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...
By Daniel Nolan 2014/01/07 | Source: SQLServerCentral.com | Category: generate
Rating: |  Discuss |   Briefcase | 4,294 reads

Script Server Roles

Script Server Roles in case of migration or documentation  Read more...
By Rasmus Glibstrup 2010/08/27 | Source: SQLServerCentral.com | Category: migration
Rating: |  Discuss |   Briefcase | 2,988 reads

Conversion of rule objects to column check constraints

This script can convert the usage of bound rule objects in tables to column check constraints  Read more...
By Michael S√łndergaard 2010/01/28 | Source: SQLServerCentral.com | Category: sp_bindrule
Rating: (not yet rated) |  Discuss |   Briefcase | 479 reads

Conversion of default objects to column defaults

This script can convert the usage of bound default objects in tables to column defaults  Read more...
Rating: |  Discuss |   Briefcase | 368 reads
   Items 1 to 6 of 6