Deleting schemas in MSSQl 2005

[Former Member]

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

[Former Member]

Dear all,

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

Regards

Vijay

[JPReyes]

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

[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.