Results 1 to 4 of 4

Thread: Sql Dmo

  1. #1
    Join Date
    Nov 2003
    Location
    florida
    Posts
    2

    Unanswered: Sql Dmo

    I am using SQL DMo with C#.
    Is there a detailed help on SQL DMO objects and functions.?

    I want to copy a Database from a server to another server. How can I do it using SQL-DMO and C#

    Thanks
    Sheetal.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Check out the following - this should jumpstart your project:

    link

  3. #3
    Join Date
    Nov 2003
    Location
    florida
    Posts
    2
    Originally posted by rnealejr
    Check out the following - this should jumpstart your project:

    link
    Thanks for the quick response. I referred that site before.
    I am trying to do the following:
    //get the source database from source server
    Database srcdb = SourceServer. Databases.Item("master",null);
    //add it to the destination server
    destServer.Databases.Add(srcdb);

    This gives me an error saying that the object already exists in a collection. So is there a way to copy a database form one server to another.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Can you provide the code before this code ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •