We help IT Professionals succeed at work.

How to Restore MS SQL database without data

604 Views
Last Modified: 2012-05-06
I'm just wondering is it possible to restore old database with new "version" of same database? I just want new fields, views and procedures from new version to old version and same time keeping data in old version.

Help needed, thanks!
Comment
Watch Question

Commented:
I don't think there's any way to pick and choose what it'll restore.  When you restore the file (let's say it's called MIRCCISDATA), change the name by modifying the name in the To database field.  Then, copy the views and procedures from the new version to the old version (I've only got Express to practice on right now so I have to copy the script from the view to the new view in the other dB, but I think there's a way to copy the views and procedures in full-blown SQL--right-click the view and check it out).
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Luan JubicaProject Manager

Commented:
Hi,
You can modify the model database to make it(via scripts ) as your template, then every new database u create will be like your template.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.