Restore to SQL Server 6.5 and Migrate to SQL Server 2014 -

Restore to SQL Server 6.5 and Migrate to SQL Server 2014 -

i have database backup file sql server 6.5. file size 52gb.

how can restore database file?

how can migrate sql server 2014?

if have access backup file, without using 3rd party tools (if any) requires move version version, of course of study means have have access servers running 3 different versions, , unless have installation media @ to the lowest degree sql server 2000 hard hold on.

if have access server backup originated might improve off trying export info format later versions can use.

if take restore backup route path should work this:

6.5 -> 2000 2000 (sp4) -> 2008 2008 -> 2014

a couple relevant of technet articles:

migration sql server 2000 sql server 2012

copying databases sql server 7.0 or earlier

there might other , potentially improve ways this, , consider asking on database administrators.

sql-server