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 8 of 8   
 

Dynamic Script to Generate RESTORE DATABASE Script

Use this script to generate RESTORE DATABASE scripts for all .BAK backup files from backup location during Instance or Database migration.  Read more...
By Ajay Dwivedi 2014/12/10 | Source: SQLServerCentral.com | Category: migration
Rating: (not yet rated) |  Discuss |   Briefcase | 131 reads

Dynamic Script to Generate Backup Script

Use this script to generate BACKUP DATABASE scripts for selective or all databases during Instance or Database migration.  Read more...
By Ajay Dwivedi 2014/12/10 | Source: SQLServerCentral.com | Category: dynamic script
Rating: (not yet rated) |  Discuss |   Briefcase | 71 reads

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,568 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 | 918 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,536 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 | 3,020 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 | 481 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 | 370 reads
   Items 1 to 8 of 8