• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 189
  • Last Modified:

SQL Data

I have a SQL Server with 30+ databases that each contain several tables, views and stored procedures.

Is there any way I can produce the properties/schema/code in a format that I could, say, email to someone?  That someone has no problem re-creating the databases/tables/views/store procedures... they just need to know the structures/code.

In other words... I need to replicate several databases and "replication" is out.


PS... I gots until Thursday!
Sheldon Livingston
Sheldon Livingston
1 Solution
you can make a backup of your database compress and email. After, they can restore it
Brendt HessSenior DBACommented:
You can Script the entire database out.

In Enterprise Manager, Right-Click on a database, and choose All Tasks/Generate SQL Script...

When the Generate SQL Scripts window pops up, click the SHOW ALL button, then select the items you want to script - Tables, Sprocs, Views, Rules, UDFs, whatever (or just choose Script All Objects).  Don't forget to check all three tabs for all of the options that apply.

Now that you have your script, compress it, attach it, and send it.  Voila.  And, since it doesn't contain the data, it will be significantly smaller than the Backup/Restore method.
Sheldon LivingstonConsultantAuthor Commented:

Thank you very much!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now