THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Migration   (RSS)
  • My World Tour

    I just finished my last stop on my “World Tour”.  The cities included Toronto, Johannesburg, Hong Kong, Sydney, Milan, and Singapore. I missed South America and Antarctica on this “tour”, but I hit the other continents.  I was part of a global team assembled from Microsoft and DB Best to train partners on how to migrate customers ...
    Posted to Rick Heiges (Weblog) by RickHeiges on March 16, 2017
  • SQL Server Migration Roll-Up

    There are so many great tools out there for data professionals using Microsoft SQL Server.  I really like to see all of these great tools made free to the public.  On the other hand, I'm bummed that the tools are cast about in a very decentralized fashion. If you haven't done migrations before, you might want to start with these ...
    Posted to Kevin Kline (Weblog) by KKline on May 2, 2011
  • Downgrading a database : "You can't get there from here!"

    I see this question a lot: ''I have a SQL Server 2008 R2 database.  Can I attach it to a SQL Server 2008 SP2 instance?'' Part of this stems from the confusion over exactly what 2008 R2 is in the first place.  It is not a service pack to SQL Server 2008; it is its own, full-fledged version.  A lot of people don't fully realize this ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 21, 2011
  • MySQL Migration Assistant Now Available

      Microsoft just announced the availability of a utility to allow you to migrate from MySQL to SQL Server. I know I have been asked about this for some time so there should be some happy people out there :). More details can be found ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on August 12, 2010
  • Server Migration Checklist II

    Easy Breezy Login Audit for your Ol’ 2000 Server In the last post on this topic I put up the preparatory steps I’ve been using for server migrations. Here I am posting some code that has worked well for us to trace who/what is connecting to our older SQL Server 2000 machines. It’s a simple audit of login events, tracing the login name, host name, ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on April 23, 2010
  • Server Migration Checklist

    During the past six months or so I have had to manage quite a lot of SQL Server migration/consolidation, and with each effort I’ve refined a checklist to try to make things go more smoothly. I just hate getting that call after a migration where something unexpected is broken :-). What follows is imperfect, but I thought I’d throw it up here ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on April 9, 2010
Privacy Statement