Migration

SQL Migrator (Part 1)

• by Datamate Technology

• SQLServerCentral.com

• Migration

• Article

Read about a free automated Upgrade\Migration Tool for SQL Server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4 (4)

Log in or register to rate

2017-03-08

817 reads

• Discuss

Paying Attention to Estimates

• by Additional Articles

• SQLPerformance.com

• Migration

• Article

Aaron Bertrand follows up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques.

2016-08-15

3,092 reads

Fix Orphan Users for Instance Migration

• by cesar_vir

• SQLServerCentral.com

• Migration

• Script

Use provided script to fix orphan users for all databases after Instance Migration. Tested on SQL 2014.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4 (2)

Log in or register to rate

2016-01-04 (first published: 2015-12-17)

1,339 reads

• Discuss

SQL Server Migration

• by Geoff Ruble

• SQLServerCentral.com

• Migration

• Article

Some SQL migrations require keeping the server name, instance name, IP, and port number. Geoff Ruble shares some notes on his recent experience with a SQL Server migration.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.93 (30)

Log in or register to rate

2018-07-20 (first published: 2015-10-12)

6,208 reads

• Discuss

Generate RESTORE DATABASE Script without Using CMDSHELL

• by cesar_vir

• SQLServerCentral.com

• Migration

• Script

Use this script to generate RESTORE DATABASE scripts for all .BAK backup files from backup location during Instance or Database migration.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.8 (5)

Log in or register to rate

2016-08-31 (first published: 2014-12-10)

3,010 reads

• Discuss

Migrating SQL Server Databases to Windows Azure by Leveraging BACPAC Files

• by Additional Articles

• Database Journal

• Migration

• Article

Marcin Policht shows you how to migrate on-premise data that is already cloud-compliant to Windows Azure SQL Databases by converting it into a BACPAC formatted file.

2014-01-21

4,099 reads

SQL Server 2014 Hybrid Cloud Scenarios: Migrating On-Premises SQL Server to Windows Azure Virtual Machines

• by Additional Articles

• TechNet Blogs

• Migration

• Article

This article describes how to use the new wizards in SQL Server Management studio to get access to Windows Azure and then create and configure your VM.

2014-01-08

3,114 reads

Identifying Incompatibility Issues When Migrating SQL Server Database to Windows Azure

• by Additional Articles

• Database Journal

• Migration

• Article

In this article, Marcin Policht looks at migrating existing SQL Server databases to Windows Azure, starting with identifying obstacles associated with such migrations.

2013-10-22

3,910 reads

Migrating Databases Checklist Part1

• by Additional Articles

• SQL Server Performance

• Migration

• Article

SQL Server databases move around as an organisation’s data grows, applications are enhanced or new versions of the database software are released. If not anything else, servers become old and unreliable and databases eventually need to find a new home. Here's what to do when migrating your databases.

2013-06-12

4,842 reads

Migrating SQL Server Databases – The DBA’s Checklist (Part 2)

• by Additional Articles

• SQL Server Performance

• Migration

• Article

Continuing from Part 1 , our Migration Checklist continues: Step 5: Update statistics It is always a good idea to update the statistics of the database that you have just installed or migrated

2011-07-25

2,586 reads