Automatically migratring metadata between instances of SQL Server 2000

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: mark baekdal (anonymous_at_discussions.microsoft.com)
Date: 06/12/04

  • Next message: Hari: "Re: bcp out and bcp in don't give the same number of rows" 
    Date: Sat, 12 Jun 2004 08:56:10 -0700

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

    >-----Original Message-----
    >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
    >.
    >

  • Next message: Hari: "Re: bcp out and bcp in don't give the same number of rows"

    Relevant Pages

    • RE: Automatically migratring metadata between instances of SQL Server
      ... It's a product that allows comparison, migration and archiving of database schema and data. ... > straight from your source code. ... >>whether there is a good way of backing up the metadata ... how can I script the process of ...
      (microsoft.public.sqlserver.tools)
    • RE: Automatically migratring metadata between instances of SQL Server
      ... It's a product that allows comparison, migration and archiving of database schema and data. ... > straight from your source code. ... >>whether there is a good way of backing up the metadata ... how can I script the process of ...
      (microsoft.public.sqlserver.tools)
    • Re: How to call stored procedure using DBIx?
      ... The arbitrary-sql approach won't help since it writes sql statements in ... source code to act as stored procedures. ... Yet I don't know how to call my stored procedures directly using ...
      (comp.lang.perl.misc)
    • Re: Help needed to apply Source Control to Stored Procedures
      ... Where is the source code for the stored procedures? ... VS.NET to a database server (via a database project)? ... to enable source control for stroed procedures is greyed out and I cannot ...
      (microsoft.public.vsnet.setup)
    • Re: Extending HTML Elements
      ... The drawback to this is that it separates ... two parts of the "source code" from each other. ... Separating the metadata from its associated HTML code does make the program that manipulates all of this more complicated. ... If the OP chooses the SPAN method, in addition to using CSS to hide the span, it's probably also possible to make the metadata look "appropriate" in case the CSS is not available, e.g.: ...
      (comp.infosystems.www.authoring.html)