Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 10 of 10   
 

Fix Orphan Users for Instance Migration

Use provided script to fix orphan users for all databases after Instance Migration. Tested on SQL 2014.  Read more...
By Ajay Dwivedi 2016/01/04 | Source: SQLServerCentral.com | Category: migration
Rating: |  Discuss |   Briefcase | 1,198 reads

Script to configure Log File Size for Large DBs

Use this script to set recommended Log files size growth for larger DBs. For more, please refer article: http://sqlmag.com/blog/choosing-default-sizes-your-data-and-log-files  Read more...
By Ajay Dwivedi 2015/12/15 | Source: SQLServerCentral.com | Category: database configuration
Rating: |  Discuss |   Briefcase | 1,100 reads

Generate RESTORE DATABASE Script without Using CMDSHELL

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 2016/04/07 | Source: SQLServerCentral.com | Category: migration
Rating: |  Discuss |   Briefcase | 2,333 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/31 | Source: SQLServerCentral.com | Category: dynamic script
Rating: |  Discuss |   Briefcase | 1,065 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 2015/02/26 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 2,555 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 | 947 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 | 5,048 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,126 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 | 506 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 | 382 reads
   Items 1 to 10 of 10