August 2012
Intermediate to advanced
1416 pages
33h 39m
English
book
Microsoft SQL Server 2012 Bible
by Adam Jorgensen, Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, Aaron Nelson
Content preview from Microsoft SQL Server 2012 Bible
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Copy Database Wizard
The Copy Database Wizard generates a SQL Server Integration Services (SSIS) package that can copy or move one or more databases from one server to another. If the database is moved to a server on the same network server, this is the premiere method. This method won't work to copy a database from SQL Server 2012 to an older version of SQL Server. In addition, destination server must have the SQL Server Agent running. If the destination server's SQL Server Agent is not running, the wizard will prompt you to start it. The Copy Database Wizard offers the most flexibility and capability. The wizard offers you one of two choices: The detach and attach method or the SQL Management Object (SMO) method.
Warning
The detach and attach method may be faster but requires the database to go offline because the database is being removed from the existing instance. You should be extremely careful with this method for upgrade purposes because this method is a “one-way” process. If you detach a database from a lower version of SQL Server ( e.g. 2008 R2) and attach it to a higher level such as SQL Server 2012, upon attachment to the new instance, the database gets internally upgraded to be compatible with the new version. Due to this automatic upgrade process, the database files can no longer be attached to a lower-level version. Before you complete any upgrade or migration process make sure you get good full backups of your databases so you can roll back in case there are ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.