were there changes in area sql server 2014? i’ve seen post is possible restore sql server 2008 backup in sql server 2005 , know not possible scenario 2012 -> 2008 wonder if ms made changes here 2014 version.
we evaluating 2014 version , have large database in testing. we’d restore backup of database sql server 2008 because physical machine has more space, ram,…
i’m getting standard error message when try restore backup wondering if there else in sql server 2014 might missing.
not far know here couple things can try.
third party tools: create empty database on 2008 instance , use third party tools such apexsql diff , data diff synchronize schema , tables.
just use these (or other on market such red gate, idera, dev art, there many similar) in trial mode job done.
generate scripts: go tasks -> generate scripts, select option script data , execute on 2008 instance. works fine note script order must careful about. default scripts not ordered take dependencies account.
Comments
Post a Comment