Post reply

Managing Sql 2000 with VS.NET 2003

  • August 3, 2006 at 9:26 am

    #173534

    Hi, i need to manage a sql server istance with VS.NET 2003 like i used to do in VB6 with SQL-DMO.

    Is It Possible?

    More specific i need to backup a remote db e restore it over a local db.

    Ho dow i?

    Thanks

    Paolo

  • August 3, 2006 at 10:13 am

    #653159

    Just like VB6: set a reference to the SQL-DMO COM library.  COM-Interop will take care of the plumbing.  You may even be able to upgrade much of your VB6 project directly from VS.Net 2003.

    -Eddie

    Eddie Wuerch
    MCM: SQL

  • August 4, 2006 at 3:07 am

    #653273

    Yes, but i hoped there was a .NET object similar to SQL-DMO.

    SQL-DMO is not so easy to deploy.

    Thanks

    Paolo

  • August 4, 2006 at 4:04 am

    #653285

    Check out Microsoft KB article 326613. It tells you which DLLs from SQL Server to package up into an MSI for distribution.

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply