Skip to Content
avatar image
Former Member

Deleting schemas in MSSQl 2005

Dear all,

Currently I am working in the system copy.

I will explain my scenario first then I will ask my queries.

In the source system its an MCOD database(One database three components were running i.e under ECC database , XI and BW were running)

Now we detached the database and copied the log and data files locally in to the NEW BW server.

In target system :

Installed central services instances.

Attached the database.

Ran the STM tool for the conversion.

Now BW server is up and running.

Queries. Since it is attached it also holds the data of other schema. Now in the new server i wnat only the BW schema and not other schemas.

How can i delete the other schema.Please suggest me with your valuble ideas.

Regards

Vijay Kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 10, 2009 at 03:20 PM

    I think your best shot would be to do a client export/import (BW is a single client system anyway) instead of a DB copy.

    Regards

    Juan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Juan,

      Our client requirement is only a database copy and not the client export and import.So,Could you please suggest some other way to delete the schema.

      Looking for your reply.

      Regards

      Vijay.

  • avatar image
    Former Member
    Feb 11, 2009 at 01:56 AM

    Dear all,

    I am moving this thread to the exact forum sap on sql.

    Regards

    Vijay

    Add comment
    10|10000 characters needed characters exceeded