Thread: Put old database backup into new site?

Hey there!

I need to get all of our products over to our development site and I was wondering if there is some way I can get a backup of our current database on there. I've read the manuals article about upgrading to 9.x version, but the new site is not ready to go live and I don't want to mess anything up. I just need the products and such so I can make sure everything shows up correctly.

Thanks a bunch!
-Kayla

Hi

If its just a standard database copy then you can create an exact copy of your database from SQL Management Studio.

Under Database right click then tasks and backup. Same procedure but restore on the dev site.

I'd say it's probably not that easy. Reading between the lines their prod db is v8 and their dev db maybe an old v8 upgraded to v9.

Now they've done all their changes, but want to get a fresh copy of their current prod data into dev to see how it looks.

I could be wrong - I have been before!

Unfortunately SQL Server Management Studio has no "suck and blow" facility for moving data around. Toad for SQL Server is much better at this. However, even with SSMS you could restore your prod db to your dev db server and use SQL statements to replace your data.

Tell me about it!

When upgrading from 7 to 9 we ended up with a "tribryd" storefront of various files from all three versions.

The migration from 7 to 9 was fairly painless after a few runs (and the correct upgrade scripts!).

Tuffy - What version are you on and what version is your dev site running on?

Currently V8, dev site V9

Also, Ese, that's exactly what I want to do.

I just thought of another question..
I want to change some things in the new website, such as description, extension data, etc. If I did figure out how to upload a backup of the current database and changed that stuff, would I lose it when we're ready to go live and upload the database again?

You definitely need to know a lot about SQL db programming to do it. And you always have to be aware of what you're doing, ie not deleting data you want and have only got in one place.