I want to move meta data between two copies of the same database running
on different machines. I do most of my work on one machine, but
sometimes have to work on a slow laptop. If I need to migrate metadata
(updated or new Stored Procedures and tables) from one machine to my
laptop, or back, is there a way I can automate the process? Is there
some way to say: hey sync this stored procedure definition in one
instance of SQL server with that in another instance?

Another way of asking the same question, but in more specific terms, is
whether there is a good way of backing up the metadata for a Stored
procedure or Table to a text file that can be placed in a source control
tool such as StarTeam or CVS? I know I can click on this and select that
and save the metadata, and then load that in on the other machine by
clicking on that and selecting this. But I want to get away from all
that laborious clicking and just run a script that automates the
process. For instance, how can I script the process of right clicking on
a table and then selecting "All Tasks | Generate SQL Script".

Thanks for your help or any hints you can offer.

- Charlie

For a tool check out Redgates SQL Compare
http://www.red-gate.com/SQL_Compare.htm
which can be automated using
http://www.red-gate.com/sql_comparis...on_toolkit.htm

You can use SQLDMO to script your objects. Check out SQLDMO in BOL (Building
SQL Server Applications>SQL-DMO)

--
HTH

Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"Charlie Calvert" <charlie_NO_CAPS_INCLUDED (AT) elvenware (DOT) com> wrote

check out www.dbghost.com for comparison, updating
straight from your source code.

Hi,

Try dbMaestro. It's a product that allows comparison, migration and archiving of database schema and data.

You can find it here:

http://www.extreme.co.il





"mark baekdal" wrote: