4

More specific my db is hosted at appharbor and I want to copy that db to my local SQL Server Express 2012. Up until now I have used Management Studio to export the data and later used the schema compare feature in Visual Studio 2012, but I guess there must be an easier way

1

1 Answer 1

6

You should talk to your support team at appharbor. Presumably there is a way to take a backup of your database, store it on the file system somewhere, and then download the .BAK file (through http or, more likely, ftp). This should be a lot less work than your current process, but it depends on your host providing the facility to do so. This also assumes that your backup file would be < 10 GB (since this is the maximum supported by Express) and that it doesn't use any features not supported in Express Edition (such as Data Compression, SQL Server Agent, etc.).

You can do this using just Management Studio, e.g. you can right-click your database, Tasks > Generate Scripts and select all objects and on the Scripting Options tab make sure to go into advanced and select the option to script both schema and data. This will generate a humongous script that you can run on your local machine after you've created an empty database. Personally I find a backup / restore much more reliable and a lot less hassle.

But asking here isn't going to be much help - unless you happen to come across someone who has done this specific thing at that specific host using the specific hosting plan you have, there is little chance any of us knows what options you have - appharbor is going to be able to help you answer that question a lot more accurately than any of us.

4
  • Since I can access both db's through management studio and easily can export tables and data I can't understand why I can't get sp.'s, indexes and the alike the same way. Using just management studio.
    – TT.
    Commented Jul 11, 2012 at 19:31
  • 4
    You can, but a backup is much more reliable and much less work. Commented Jul 11, 2012 at 19:32
  • Thx for the answer Aaron. A possibility to create a backup to my local computer would be ideal. Hassling the guys over at Appharbor every time I need a backup seems a bit to much
    – terjetyl
    Commented Jul 11, 2012 at 19:47
  • 3
    I'm not suggesting you ask appharbor: "hey guys, can you make me a backup?" I'm suggesting you ask them: "hey guys, can you tell me how I can create a backup of my database periodically, so that I can download it and develop locally?" Commented Jul 11, 2012 at 19:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.