SQL Data

Posted on 2005-05-10
Medium Priority
Last Modified: 2010-03-19
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!
Question by:classnet

Expert Comment

ID: 13974483
you can make a backup of your database compress and email. After, they can restore it
LVL 32

Accepted Solution

Brendt Hess earned 2000 total points
ID: 13974509
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.

Author Comment

ID: 13974692

Thank you very much!

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question