Home Forums SQL Server 2005 Development How to Copy a MSSQL db using Detach-Attach between 2 servers using a script (vbs, perl or any ...) RE: How to Copy a MSSQL db using Detach-Attach between 2 servers using a script (vbs, perl or any ...)

  • March 3, 2009 at 5:55 am

    #952353

    You really need to show what's been done so far, even if you haven't done much.

    What language are you using for the scripting? Are you doing everything through T-SQL and plan to run it through sqlcmd? Is it a .NET language? Have you considered PowerShell?

    Do you have the detach/attach scripts done & tested? I'd start there to be sure I had that in hand, because after that it's just copying files around.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning