Email Alerts
-
Should you upgrade to SQL Server 2012?
Are you going to upgrade to SQL Server 2012? This edition of SQL Server Insider sets out to help you decide whether the investment is worth it or not. Read this edition to learn if several IT pros are going to upgrade and why, how this release will a... E-Zine
-
Azure Cloud testing tips for SQL Server shops
As Microsoft continues to extend its reach with its most recent offerings, customers are presented with new opportunities and challenges alike. Read this edition of "SQL Server Insider" to find expert tips and insight on testing Azure Cloud, how SQL ... E-Zine
-
Selling a SQL Server 2008 R2 upgrade
When proposing an upgrade to SQL Server 2008 R2 to management, you need to focus more on ROI than its cool, new features. In the second volume of the SQL Server Insider e-zine, you’ll learn how to draft a presentation that will wow the higher ups and... E-Zine
-
Excerpt: Planning a Microsoft SQL Server install
For many DBAs, a SQL Server installation can be tough. Read this excerpt from Dusan Petkovic's book on Microsoft SQL Server 2012. Excerpt
-
The 2012 Dynamic Database Project Award
The award will recognize the most innovative, cost-saving, best database project of 2012. Enter for a chance to win an Apple iPad. Deadline is Nov. 9. guide
-
SQL Server 2012 Guide
SQL Server 2012 Guide
-
SQL Server 2012 release approaches -- what you need to know
Microsoft will soon come out with the long-awaited SQL Server 2012 release, but will your system be ready to take full advantage of the new version, also known as Microsoft Denali? Find out. Feature
-
SQL Server Denali, R2, XP: What sizzles, what doesn’t this summer
With the latest SQL Server Denali CTP out, Microsoft exec Mark Kromer discusses updates and addresses blogosphere buzz about what Denali’s not running on. Feature
-
As Microsoft's SQL Azure gains altitude, industry eyes chances of reign
As independent software vendors begin to roll out core business systems on Microsoft SQL Azure cloud service, larger enterprises are slower to migrate. Feature
-
SQL Server Denali on its way, Microsoft shares insights on upgrades
With the SQL Server Denali release date still down the road, would it do businesses any good to upgrade? Microsoft’s Mark Kromer gives advice to businesses itching to move up. Feature
-
Moving beyond SSIS: 5 third-party SQL Server tools for ETL
Sometimes an organizations data management needs surpass what SQL Server Integration Services can offer. Read on for an ETL tools comparison and find out which tool is best for your organization. Feature
-
SQL Server tutorials
SearchSQLServer.com's tutorials provide the in-depth information SQL Server database administrators and developers are seeking on Microsoft's flagship database enterprise server, SQL Server and its latest release SQL Server 2008. Our SQL Server tutor... Tutorial
-
Q&A;: SQL Server business intelligence meets the cloud
Microsoft’s Mark Kromer offers his thoughts on the current state of cloud-based BI and what technologies like SQL Azure and PowerPivot can do for organizations. SQL in Five
- See more Essential Knowledge on SQL Server Migration Strategies and Planning
-
Back up SQL Server to SQL Azure? Some have their fingers crossed
With Microsoft broadcasting the importance of its cloud computing platform, some SQL Server pros want to use the cloud database service as a backup to their on-premises SQL Server databases. News | 12 Jun 2012
-
Microsoft’s SQL Server 2012 has muscle, but database battle is fierce
One of the strongest versions Microsoft has put out in years, SQL Server 2012 first needs to accomplish a monumental task -- overcome database inertia, industry watchers say. News | 18 Apr 2012
-
Big data a big deal for SQL Server 2012, users say
SQL Server 2012 is here, and the Apache Hadoop integration is making the biggest wave, according to some users. News | 11 Apr 2012
-
SQL Server 2012 ‘virtually’ out, Microsoft talks features, licensing
With SQL Server 2012 released in a “virtual launch” this month, Microsoft data platform specialist Mark Kromer tells us what his favorite features of the new release are. News | 14 Mar 2012
-
Don’t sweat migration from Oracle, Sybase to SQL Azure
Are you considering moving your database to Azure? Concerned about complexity? Read this tip from expert Denny Cherry. Migrating to SQL Azure might be the easiest move ever. News | 12 Mar 2012
-
Microsoft SQL Server 2012 goes big -- data, that is
Microsoft database platform specialist Mark Kromer talks in this Q&A; about Microsoft SQL Server 2012 “big data” capabilities, as well as what SQL Server has in store for open source and cloud computing this year. Q&A; | 14 Feb 2012
-
SQL Server 2012, cloud, ‘big data’ driving momentum in 2012
With SQL Server 2012 coming out and the growing influence of the SQL Azure cloud and “big data,” the SQL Server landscape could see some major changes in the coming months. News | 13 Feb 2012
-
For SQL Server shops testing Azure cloud, it’s all about integrating data
With tool sets still evolving, developers face stiff challenges in integrating data in hybrid SQL Server-SQL Azure environments. News | 18 Jan 2012
-
Microsoft folds Hadoop into SQL Server 2012, Windows Azure
Microsoft said it will release SQL Server 2012, formerly Denali, next year and detailed its Hadoop-based strategy for handling the explosion of big data at the PASS 2011 conference. News | 13 Oct 2011
-
Q&A;: With SQL Azure, Microsoft eyes giant leap to the cloud
It was cloud, cloud, cloud at Microsoft TechEd 2011. Microsoft’s Mark Kromer discusses the SQL Azure, what’s new with the cloud database offering and what’s to come. News | 07 Jun 2011
- See more News on SQL Server Migration Strategies and Planning
-
Virtualizing SQL Server? What to keep in mind
Thinking about virtualizing SQL Server? Roman Rehak gives you a rundown about what you should keep in mind when planning your migration. Tip
-
In-memory SQL Server: The implications of integration
How is in-memory SQL Server different from SQL Server with a bunch of RAM? SQL Server guru Serdar Yegulalp explains what to know before you install. Tip
-
SQL Server Upgrade Advisor, Upgrade Assistant can ease transition pains
You probably think you’re ready to upgrade to the new release, but you might not be as prepared as you think. Before you upgrade, there are some tools to become familiar with, says Bob Sheldon. Tip
-
Split root table with T-SQL in SQL Azure Federations
SQL Azure Federations can help manage massive amounts of data, says Roger Jennings. In Part 2 of this two-part series, read on for instructions on splitting the federation root table. Tip
-
Tips for deploying SQL Azure Federations
Reduced SQL Azure pricing, an upgraded management portal, increased database size and the SQL Azure Federations Data Migration Wizard mean multi-tenant and “big data” projects are big possibilities. Tip
-
Is cloud-based business intelligence a safe bet?
Cloud-based business intelligence has its attractions, especially for SMBs having a hard time supporting any BI in-house. But don’t forget to ask some crucial questions. Tip
-
Microsoft SQL Server 2012 pricing, licensing packed with changes
SQL Server 2012 pricing includes some significant adjustments, including a reduction in the number of editions and the change from processor- to core-based licensing. Tip
-
Five things in SQL Server not in SQL Azure
With the excitement over the cloud, it’s easy to forget that Microsoft’s cloud database, SQL Azure, is not for everyone. Learn the five major differences between SQL Azure and SQL Server. Tip
-
Three tips for a better SQL Azure migration
A successful SQL Azure migration means picking the right migration tool and loading data into SQL Azure properly. Tip
-
Plan ahead for a smooth SQL Server migration
The thought of a SQL Server migration makes many organizations nervous, but they don’t have to be, writes consultant Don Jones. Get tips on making the switch simple. Tip
- See more Tips on SQL Server Migration Strategies and Planning
-
Upgrade databases to SQL Server 2005 after server upgrade
One upgrade method is to uninstall SQL Server 2000 and then install SQL Server 2005 and attach databases. Learn how to upgrade those databases. Ask the Expert
-
Query to search text in old DTS packages in SQL Server?
Is there a query to search text in a SQL Server DTS package? SQL Server expert Joe Toscano explains which database objects can be viewed. Ask the Expert
-
Migrating SQL Server applications after upgrade
Find how to migrate a single application to your new platform after upgrading to SQL Server 2005. Ask the Expert
-
Upgrading to SQL Server 2005 while maintaining .adp access
Maintaining .adp access while uprgrading to SQL Server 2005 could be a problem. SQL Server 2005 expert Adam Machanic advises on a course of action to take. Ask the Expert
-
How to copy databases when upgrading to SQL Server 2005
Learn how to copy databases when migrating from SQL Server 2000 to SQL Server 2005, and how to transfer logins. Ask the Expert
-
Function to determine which Service Pack is installed
SQL Server expert Adam Machanic offers a function to determine which service pack you currently have installed. Ask the Expert
-
Migrating from MS Access to SQL Server 2000
How can I migrate from MS Access 2000 to SQL Server 2000? How can I migrate the forms from Access to SQL Server? Ask the Expert
-
In-place versus side-by-side upgrade
Ask the Expert
-
Resources for upgrading from 6.5 to 7.0
Ask the Expert
-
Renaming instance after upgrade
Ask the Expert
- See more Expert Advice on SQL Server Migration Strategies and Planning
-
SQL Azure
SQL Azure is Microsoft’s cloud database service. Definition
-
Cloud efforts advance, SQL Server evolves
MVPs Brent Ozar and Kevin Kline discuss the implications of Microsoft’s latest cloud computing efforts and what they mean to SQL Server BI, virtualization and more. Podcast
-
Virtualizing SQL Server? What to keep in mind
Thinking about virtualizing SQL Server? Roman Rehak gives you a rundown about what you should keep in mind when planning your migration. Tip
-
In-memory SQL Server: The implications of integration
How is in-memory SQL Server different from SQL Server with a bunch of RAM? SQL Server guru Serdar Yegulalp explains what to know before you install. Tip
-
Excerpt: Planning a Microsoft SQL Server install
For many DBAs, a SQL Server installation can be tough. Read this excerpt from Dusan Petkovic's book on Microsoft SQL Server 2012. Excerpt
-
The 2012 Dynamic Database Project Award
The award will recognize the most innovative, cost-saving, best database project of 2012. Enter for a chance to win an Apple iPad. Deadline is Nov. 9. guide
-
Back up SQL Server to SQL Azure? Some have their fingers crossed
With Microsoft broadcasting the importance of its cloud computing platform, some SQL Server pros want to use the cloud database service as a backup to their on-premises SQL Server databases. News
-
SQL Server Upgrade Advisor, Upgrade Assistant can ease transition pains
You probably think you’re ready to upgrade to the new release, but you might not be as prepared as you think. Before you upgrade, there are some tools to become familiar with, says Bob Sheldon. Tip
-
Should you upgrade to SQL Server 2012?
Are you going to upgrade to SQL Server 2012? This edition of SQL Server Insider sets out to help you decide whether the investment is worth it or not. Read this edition to learn if several IT pros are going to upgrade and why, how this release will a... E-Zine
-
Microsoft’s SQL Server 2012 has muscle, but database battle is fierce
One of the strongest versions Microsoft has put out in years, SQL Server 2012 first needs to accomplish a monumental task -- overcome database inertia, industry watchers say. News
-
Split root table with T-SQL in SQL Azure Federations
SQL Azure Federations can help manage massive amounts of data, says Roger Jennings. In Part 2 of this two-part series, read on for instructions on splitting the federation root table. Tip
-
Big data a big deal for SQL Server 2012, users say
SQL Server 2012 is here, and the Apache Hadoop integration is making the biggest wave, according to some users. News
- See more All on SQL Server Migration Strategies and Planning
About SQL Server Migration Strategies and Planning
With the releases of Microsoft SQL Server 2005 and 2008 over the past few years, many organizations have gone through the process of upgrading their database management systems (especially those still running SQL Server 2000). Like any migration, the process can be harrowing, but fortunately, we can help. This topic page features SQL Server migration and planning advice from database professionals who have seen it all (and then some). Here you'll find the latest migration tools for upgrading Microsoft SQL Server databases, with details on developing a rock solid migration strategy. Of course, the first step to a successful SQL Server migration is plannning, so before you start, be sure to check out the resources below to help figure out if an upgrade is really necessary in the first place.