Consolidation

  • Does any body give me some ideas how to combine multiple databases into a single database rather than recreating the objects on the new one ?

  • If you want multiple databases on a single server, you create a new database on that server or restore a backup for that database to the server.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Confused with your question, what do you mean by combining multiple databases into a single, you mean to transfer the tables and other objects form different databases to single?

    Nag

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

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

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