Avatar of Peterson50
Flag for United States of America

asked on 

Moving SQl Server SBS 2003 to SQL Server 2014

We have a client who has refused until now to update his server and software.  The vertical application is no longer supported by the vendor and is a custom application.  So the option we have is to move the sql databases which are currently hosted on a SBS 2003 server.  We are installing a test server 2012 running SQL 2014 and will try to run the client app in a VM.
What is the easiest and best way to export the sql data from the old sql to the new.  All of the sql backup apps that run on sbs 2003 will not run on Server 2012, that we have tried.

I'm not a sql expert so need some walking through it.
Windows Server 2012Microsoft SQL ServerWindows Server 2003

Avatar of undefined
Last Comment
Jonathan Kelly

8/22/2022 - Mon