Geek Answers Handbook

Quickly copy a production database to a development environment (SQL Server)

Often I need to pull the production database of a project to my local sql server in order to add functions, check stuff, etc.

Today, my procedure is to create a backup on a production server, somehow get it on my local computer - and then create a new database locally and restore the backup on top of it.

This is a pain, and I need more time than I like, and I would like to think that there should be a better way.

I have access to a production database through SQL Server Management Studio - is there an easier way requiring fewer manual steps?

How do you do this?

+5
source share
4 answers

It is impossible to come up with a faster way to use SQL Sever Management Studio. I would recommend SQL Compare from Red Gate to synchronize the schema, SQL Data Compare can synchronize data, but it is not fast for large Internet databases.

+2
source
  • You can use SSIS and copy objects between these environments, assuming you have a direct connection to the production server.
  • In another way, you need to make regular backups of production databases, a simple maintenance plan can make a full backup at night, for example. If so, just ask the administrators for an early backup and then install it in your environment.
  • , , , . .
+1

- . Red Gate SQL Clone - , Windocks SQL Server . , Windocks.

0

, : 1. 2. dev 3. dev.

.

: , , .

-2
source

More articles:


All Articles