Sql-server – How is the SQL Server Folder “C:\Program Files\Microsoft SQL Server\” organized

Have you considered using SSIS yet?

SSIS does the transofrmation of the data BEFORE loading it into the target system, hence avoiding a lot of read/write on the target system.

You can generate a SSIS package via sript or .NET code also.

Get started here: http://msdn.microsoft.com/en-us/library/ms141026.aspx

While you could do this with a SQL Script, this is one of those cases where it's easier to use the management console.

Start the SQL Server 2008 Management Studio and connect to your server as a user with the sysadmin server role. Navigate to your database, right-click and select Tasks -> Detach..., click OK. Now you can move your database files to their new location. Finally, right-click the Databases folder and select Attach..., select the appropriate files and click OK. Your database will now be online using the files in their new location.