Migrating SQL Server 2000 user databases to SQL server 2012

T-SQL scripts to migrate SQL server 2000 user databases to SQL server 2012    1.      Backup SQL 2000 user databases using below scripts: Please customize parts highlighted in yellow /******************************************************************************** *         Backup SQL server 2000 user databases ********************************************************************************/   use master; go   DECLARE UserDatabases_CTE_Cursor Cursor FOR   — Selecting user database names. select name…

3

T-SQL script to backup all user databases with time stamped backup file.

use master; go     DECLARE UserDatabases_CTE_Cursor Cursor FOR   — Selecting user database names. select name as DatabaseName from sys.sysdatabases where ([dbid] > 4) and ([name] not like ‘$’)   OPEN UserDatabases_CTE_Cursor DECLARE @dbName varchar(100); DECLARE @backupPath varchar(100); DECLARE @backupQuery varchar(500);   — make sure that the below path exists set @backupPath = ‘c:\SQLBackupFolder\’…

23