|
An Easy way to Restore a DB
|
Email
|
| Submitted on: |
7/31/2003 10:31:58 AM |
| By: |
marisol gonzalez
|
| Level: |
Advanced |
| User Rating: |
By 1 Users |
| Compatibility: |
SQL Server 2000, SQL Server 7.0 |
| Views: |
14232 |
|
|
|
|
|
Restore any Data Base from ver 7.0 to 2K and viceversa
|
| |
|
code:
Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!
Terms of Agreement:
By using this code, you agree to the following terms...
- You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
- You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
- You may link to this code from another website, but ONLY if it is not wrapped in a frame.
- You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
|
--**************************************
-- Name: An Easy way to Restore a DB
-- Description:Restore any Data Base from ver 7.0 to 2K and viceversa
-- By: marisol gonzalez
--
-- Assumes:On Source Server:
1. Create the script for objects ONLY (tables, indexes, triggers, etc)
On Target Server:
1. Create a New Data Base
On Source Server:
2. Create a dts for export tables and data to target server and New Data Base and DONT RUN !!! just save it
--
--This code is copyrighted and has-- limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=733&lngWId=5--for details.--**************************************
On Target Server:
1.Open Query Analyzer and select your New Data Base
2. run the script and create the objects.
3. Copy and run this sps one by one not at same time:
--desactivate triggers & contrains
sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
sp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER all"
On Source Server:
4.--run dts for export tables and data and wait until it finish !!!
On Target Server:
5.Copy and run this sps one by one not at same time:
--activate triggers & contrains
sp_msforeachtable @command1="print '?'", @command2="ALTER TABLE ? CHECK CONSTRAINT all"
sp_msforeachtable @command1="print '?'", @command2="ALTER TABLE ? ENABLE TRIGGER all"
6. thatīs all
|
|
Other 3 submission(s) by this author
|
|
Report Bad Submission
|
Your Vote
|
| |
Other User Comments
|
There are no comments on this submission.
|
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
To post feedback, first please login.
|
