{"id":83,"date":"2008-08-08T12:13:11","date_gmt":"2008-08-08T12:13:11","guid":{"rendered":""},"modified":"2008-08-08T14:33:29","modified_gmt":"2008-08-08T14:33:29","slug":"sql_server_2008_arrives","status":"publish","type":"post","link":"https:\/\/blogs.ncl.ac.uk\/isg\/?p=83","title":{"rendered":"SQL Server 2008 arrives"},"content":{"rendered":"<p>At the moment WIT run a collection of SQL 2000 and 2005 servers that host around a hundred databases of varying size and importance to the institution. The lion&#8217;s share of those databases are currently on the older SQL Server 2000, so several months ago, with the <a href=\"http:\/\/support.microsoft.com\/lifecycle\/search\/?sort=PN&amp;alpha=SQL\">end of mainstream support<\/a> for that product approaching, we started making plans for migration.<\/p>\n<p>We&#8217;ve been keeping a close eye on the development of the latest version, <a href=\"http:\/\/www.microsoft.com\/sqlserver\/2008\/\">SQL Server 2008<\/a>, since it was announced, and trialing pre-release versions. SQL Server 2008 offers a number of advantages over previous versions and the migration path from SQL 2000 to 2005 or 2008 is much the same, so we&#8217;ve opted to take those databases that are currently on SQL 2000 straight to 2008, rather than moving them twice.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/wit.ncl.ac.uk\/blog_files\/jonathan\/sql2008.jpg\" alt=\"SQL Server 2008\" title=\"\" \/><\/p>\n<p>Last week, we were fortunate to have Microsoft&#8217;s <a href=\"http:\/\/blogs.technet.com\/andrew\/\">Andrew Fryer<\/a> spending a day with us, discussing our migration plans. Since none of our databases do anything especially odd (not that some of them aren&#8217;t complex), SQL Server 2008&#8217;s comprehensive <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms144256(SQL.100).aspx\">Upgrade Advisor<\/a> was able to tell us that we didn&#8217;t need to make any changes to the databases before moving them to the new version.<\/p>\n<p>There are some things that Upgrade Advisor suggests for after the migration, such as re-writing DTS packages using the SSIS technology that replaced DTS in SQL Server 2005, but existing <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/bb500440(SQL.100).aspx\">DTS packages will work in SQL Server 2008<\/a>, so our advice is that the time to migrate from DTS to SSIS is when you need to alter a package.<\/p>\n<p>This week <a href=\"http:\/\/blogs.technet.com\/andrew\/archive\/2008\/08\/06\/sql-server-2008-released.aspx\">SQL Server 2008 has been released<\/a> to manufacture, so we&#8217;ll be moving forward with building production and test systems with the finished code. We&#8217;ve planned a setup which provides higher availability and better disaster recovery than we&#8217;ve previously implemented, and we&#8217;re looking forward to taking advantage of some of the new features (I&#8217;m especially looking forward to working with the <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/cc281954(SQL.100).aspx\">SQL Server PowerShell<\/a> functionality!).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>At the moment WIT run a collection of SQL 2000 and 2005 servers that host around a hundred databases of varying size and importance to the institution. The lion&#8217;s share of those databases are currently on the older SQL Server &hellip; <a href=\"https:\/\/blogs.ncl.ac.uk\/isg\/?p=83\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":4741,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,3],"tags":[],"class_list":["post-83","post","type-post","status-publish","format-standard","hentry","category-powershell","category-sql"],"_links":{"self":[{"href":"https:\/\/blogs.ncl.ac.uk\/isg\/index.php?rest_route=\/wp\/v2\/posts\/83","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ncl.ac.uk\/isg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.ncl.ac.uk\/isg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/isg\/index.php?rest_route=\/wp\/v2\/users\/4741"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/isg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=83"}],"version-history":[{"count":0,"href":"https:\/\/blogs.ncl.ac.uk\/isg\/index.php?rest_route=\/wp\/v2\/posts\/83\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.ncl.ac.uk\/isg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=83"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/isg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=83"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/isg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=83"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}