Home ›
ASP.NET Forums » General ASP.NET » FAQ - Frequently Asked Questions » How to move databases between computers that are running SQL Server

How to move databases between computers that are running SQL Server

Rate It (2)

Last post 10-25-2009 1:34 PM by ajitsatpathy. 19 replies.

Sort Posts:

  • Re: How to move databases between computers that are running SQL Server

    05-20-2009, 12:56 PM
    • Member
      223 point Member
    • Grayson@MS
    • Member since 11-10-2005, 8:45 PM
    • Posts 34
    • Moderator

    You might want to look at the new deployment features in Visual Studio 2010 beta 1 that was just released. We've got some powerful tools to make it much easier to move a database with a Web application project for either hosted or self-hosted sites.

    Deploying Databases with Web Application Projects Overview Pasted from <http://msdn.microsoft.com/en-us/library/dd465340(VS.100).aspx>  Walkthrough: Deploying a Database with a Web Package Pasted from <http://msdn.microsoft.com/en-us/library/dd483479(VS.100).aspx>  Walkthrough: Deploying a Database using Web Publish Pasted from <http://msdn.microsoft.com/en-us/library/dd579608(VS.100).aspx>  How to: Include Custom Scripts with a Database in a Web Package Pasted from <http://msdn.microsoft.com/en-us/library/dd465343(VS.100).aspx>

    HTH,

    Grayson

  • Re: How to move databases between computers that are running SQL Server

    10-23-2009, 12:55 PM
    • Member
      4 point Member
    • jerrios
    • Member since 10-23-2009, 4:34 PM
    • Posts 2

    Hello,

    I'm a new user to this tools and am building a web project using visual web developer express 2008. I tried transfering all my project files to another computer but i can't get the database to connect. I've read that you have to attach detach, copy paste etc lots of way to transfer the file. What i did before was just copy the project folder and transfer with usb but it kinda lost the database connection. How do i transfer the db as well? Hope you guys can help. I'm new so i don't get the term you guys using. I found the attach method but i wanna know the other methods as well as a back up since the other computer is kinda far away and i wanna make sure i get it right this time. Please help. Thank you =)

  • Re: How to move databases between computers that are running SQL Server

    10-23-2009, 1:48 PM
    • Member
      190 point Member
    • ajitsatpathy
    • Member since 06-12-2008, 2:46 AM
    • New Delhi
    • Posts 61

    Right click on your database. Go to Tasks->Backup. It'll show a location where to save. Take backup by clicking OK. Just go to that location & copy that file. Then go to second computer where you want to restore. Open SQL Server. Right click on "Databases". Go to "Restore Database". Select "from device" option. Click on the right side button. Then click "Add". select that backup file & click OK. Then click "To database" dropdown list. You can see your database name. Select it & click OK.

    Tell m if any problem.

    Ajita Kumar Satpathy

  • Re: How to move databases between computers that are running SQL Server

    10-25-2009, 11:29 AM
    • Member
      4 point Member
    • jerrios
    • Member since 10-23-2009, 4:34 PM
    • Posts 2

    Right click on database as in in database explorer? is it in visual web developer express 2008? And plus everytime i choose to 'view in browser' my .aspx page it says asp.net developement server.

  • Re: How to move databases between computers that are running SQL Server

    10-25-2009, 1:34 PM
    • Member
      190 point Member
    • ajitsatpathy
    • Member since 06-12-2008, 2:46 AM
    • New Delhi
    • Posts 61

    U need to open it from SQL management studio.

    Ajita Kumar Satpathy
Page 2 of 2 (20 items) < Previous 1 2
RSS Available

Contact | Advertise | Ads by BanManPro | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.