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

Content with tag Migration Rss

   Items 1 to 20 of 29    Older >>
 

Migrating SQL Server Databases to Windows Azure by Leveraging BACPAC Files

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.  Read more...
By Additional Articles 2014/01/21 | Source: Database Journal | Category: migration
Rating: (not yet rated)  Rate this |   Briefcase | 3,281 reads

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

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.   Read more...
By Additional Articles 2014/01/08 | Source: TechNet Blogs | Category: migration
Rating: (not yet rated)  Rate this |   Briefcase | 1,761 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,406 reads

Migrating SQL Server Database to Windows Azure - Deploying SQL Database

There are a few challenges associated with deployments of data services in Windows Azure, focusing in particular on SQL Database. In this article we turn our attention to an actual deployment and migration of locally stored data to SQL Database.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,112 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,539 reads

Migrating SQL Server Database to Windows Azure - Resolving Incompatibility Issues

In this series on implementing data services in Azure, Marcin Policht turns his attention to the remediation of incompatibilities resulting from of limitations inherent to Platform as a Service (PaaS) based deployments, which will need to be addressed as part of the migration process.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,516 reads

Identifying Incompatibility Issues When Migrating SQL Server Database to Windows Azure

In this article, Marcin Policht looks at migrating existing SQL Server databases to Windows Azure, starting with identifying obstacles associated with such migrations.  Read more...
By Additional Articles 2013/10/22 | Source: Database Journal | Category: migration
Rating: (not yet rated)  Rate this |   Briefcase | 3,274 reads

SQL Server Cloud Migration Part I

A SQL Server migration with minimal business impact while synchronizing schema and data.  Read more...
By Edward Polley 2013/09/23 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 3,251 reads

Migrating Databases Checklist Part1

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.  Read more...
By Additional Articles 2013/06/12 | Source: SQL Server Performance | Category: migration
Rating: (not yet rated)  Rate this |   Briefcase | 4,406 reads

How to move a SQL Server Log Shipped Secondary Database to Different SQL Server

This tip I will explains a step-by-step method to perform the SQL Server Log Shipping migration.  Read more...
By Additional Articles 2013/03/04 | Source: MSSQLTips.com | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 1,858 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,406 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 | 917 reads

20 tips on converting MySQL views to MS SQL

This article gives 20 tips how to modify MySQL views to make it compatible with Microsoft SQL Server.   Read more...
By Andrew Kuprianov 2012/05/02 | Source: SQLServerCentral.com | Category: mysql
Rating: |  Discuss |   Briefcase | 2,998 reads

Migrating SQL Reporting Services to a new server

I need to move all the objects off the 2005 Reporting Server to the 2008 Reporting Server. Is there an easy way to do this without saving each report file (edit report and save .rdl) then uploading the report to the new server? This would also mean recreating the data sources and subscriptions.  Read more...
By Additional Articles 2012/04/16 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating:  Rate this |   Briefcase | 3,719 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,406 reads

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

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  Read more...
By Additional Articles 2011/07/25 | Source: SQL Server Performance | Category: migration
Rating: (not yet rated)  Rate this |   Briefcase | 2,429 reads

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

It is a fact of life: SQL Server databases change homes. They move from one instance to another, from one version to the next, from old servers to new ones. They move around as an organisation’s data grows, applications are enhanced or new versions of the database software are released.  Read more...
By Additional Articles 2011/07/18 | Source: SQL Server Performance | Category: migration
Rating: (not yet rated)  Rate this |   Briefcase | 3,379 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,999 reads

Oracle to SQL Server, Crossing the Great Divide, Part 3

We soon learn, in SQL Server, that heaps are a bad thing, without necessarily understanding how or why. Jonathan Lewis is an Oracle expert who doesn't like to take such strictures for granted, especially when they don't apply to Oracle. Jonathan discovers much about how SQL Server places data, and concludes from his experiments that heaps perform badly in SQL Server because you cannot specify a fill factor for them.  Read more...
By Additional Articles 2010/07/23 | Source: SimpleTalk | Category: migration
Rating:  Rate this |   Briefcase | 2,889 reads

Turn on CHECKSUM after an upgrade

When reloading or attaching a SQL 2000 database to SQL 2005 or 2008, the database objects are upgraded automatically. Some database options don't change, though. PAGE_VERIFY is one of them.  Read more...
By David Baffaleuf 2010/07/20 | Source: SQLServerCentral.com | Category: page_verfify
Rating: |  Discuss |   Briefcase | 6,873 reads
   Items 1 to 20 of 29    Older >>
 
Tags
azure (4)    
windows azure sql database (4)    
administration (2)    
reporting services (ssrs) (2)    
sql azure (2)    
analysis services (ssas) (1)    
backup (1)    
bacpac (1)    
blogs (1)    
change password (1)    
change sa (1)    
checksum (1)    
data (1)    
database maintenance (1)    
database mirroring (1)    
default (1)    
delete (1)    
domain (1)    
generate (1)    
insert (1)    
log shipping (1)    
login (1)    
logins (1)    
lookup (1)    
merge (1)    
mirroring (1)    
mysql (1)    
oracle (1)    
paas (1)    
page_verfify (1)    
password (1)    
powershell (1)    
proclarity (1)    
reference (1)    
rules (1)    
sa (1)    
server roles (1)    
sp_bindefault (1)    
sp_bindrule (1)    
sp_unbindefault (1)    
sp_unbindrule (1)    
sql server (1)    
static (1)    
synchronization (1)    
torn_page_detection (1)    
update (1)    
users (1)    
vm (1)