Re-applying column constraints

5 pts.
Tags:
SQL Server 2005
SQL Server database
I have a 100+ db that was hacked. The column level constraints/defaults were removed. I'd like to know how I can reapply the constraints/defaults while keeping the data intact. I do have an identical database with no data in it.

Answer Wiki

Thanks. We'll let you know when a new response is added.

If the database was hacked, it is also possible that the data had been altered, but if you have confirmed this didn’t happen, reapplying the constraints should be no problem, because all of the data stored in the db was checked/validated by the constraints when it was entered/updated, so I think the only thing that could pose a problem would be having a tool/script that lets you export/generate the constraint creation scripts from your other database.

I don’t know if such a thing exists for SQL Server, but I hope someone else can help with this.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following