Updating a production database with back up of development database

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

Sorry, Nate. I can't read the entire title of your post. Would you put some more detail in the body of your post?

Thanks,

Greg

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 2

Red Gate SQL Compare works wonders!

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

-=JLK=- SSCertifiable Points: 5315 More actions · Answer 3

This is a pretty vague request. Do you simply want to over write the current production database? If so then a simple restore of a backup:

--Backup the development database

backup database DevDB to DISK='C:\backups\DevDB.bak' with format

go

--Use the following to get the file list of the backup set

RESTORE FILELISTONLY FROM

DISK='c:\backups\devDB.bak'

--Use this or something similiar to restore the file on the new machine

RESTORE DATABASE [ProdDB]

FROM DISK='c:\backups\DevDb.bak'

WITH

REPLACE,

MOVE 'DevDB_Primary' TO 'C:\SQLData\ProdDB_Primary.MDF',

MOVE 'DevDB_Log01' TO 'C:\SQLData\ProdDB_Log01.LDF'

go

--You could also do a sp_detach_db from one server, copy the data to the other server and sp_attach_db it back

--I guess it depends on what exactly you want to do.

Normally I've gone the other direction, copy of Production to Development, I can't remember a time of going the other way