X-Received: by 10.66.142.135 with SMTP id rw7mr16960073pab.20.1455551259831; Mon, 15 Feb 2016 07:47:39 -0800 (PST) X-Received: by 10.50.176.195 with SMTP id ck3mr162564igc.5.1455551259733; Mon, 15 Feb 2016 07:47:39 -0800 (PST) Path: csiph.com!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!hb3no5098828igb.0!news-out.google.com!kr2ni5508igb.0!nntp.google.com!ok5no2064706igc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: microsoft.public.sqlserver.programming Date: Mon, 15 Feb 2016 07:47:39 -0800 (PST) Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=2601:140:4000:3fe1:7198:594d:61cf:6d7d; posting-account=fNO1SwoAAAARgeF8HKn4Duw-aHSqtuTg NNTP-Posting-Host: 2601:140:4000:3fe1:7198:594d:61cf:6d7d User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: How to migrate 2008 database to 2012 plus change col header etc From: ashos.owner@gmail.com Injection-Date: Mon, 15 Feb 2016 15:47:39 +0000 Content-Type: text/plain; charset=ISO-8859-1 Lines: 10 Xref: csiph.com microsoft.public.sqlserver.programming:31286 Hello, I haven't used SQL or SQL server in three years. I have been charged to do the migration of a 2008 SQL Server database to 2012 SQL Server. In addition minor changes must be made to the 2008 database such as: column name changes, zip code format changes, and date and time format changes. How would you go about doing this, please be specific. Thanks Mike