Copy SQL Server '05 DB to another PC
Posted on 2010-11-29
I have a 2005 SQL Server DB on Computer A (Windows XP) that I need to copy onto new Computer B (Windows 7, also SQL Server 2005.)
I thought I might be lucky enough to just copy the whole folder within SQL Server directory on Computer A and paste into AQL Server program directory on Computer B, but alas, this does not work. I've searched some of the solutions for this task and they all seem to involve some degree of scripting and/or SQL. I can follow these procedures if they're simple enough and spelled out in painstaking detail, but I'm more of a GUI / Wizard / Point-and-click type of person. Can anyone provide this type of solution for this task? Thanks!