I have two schema in user database, How can i dump the user database schema name?

[hitgon]

Respected, gurus

I'm working on ASE 15.0.2 DB.
I have two separate user schema in my ACUTE database
1. EASY_BANK :It store normal master and treansaction table
2. EASY_BANK_LOB :It store images and photos

when i dump the acute database then dump file contain all the
object(two schema easy_bank and easy_bank_lob) in the acute database

My problem :

I want to dump the ACUTE db which is contain object resides only in
EASY_BANK_LOB.

I also want to dump the ACUTE db which is contain object resides only
in EASY_BANK.

same way ,
can i restore the data which is only in EASY_BANK_LOB schema in ACUTE
db ?
can i restore the data which is only in EASY_BANK schema in ACUTE db ?

--
Regards,
Gondalia Hitesh (D.B.A.)
Acute Softwares Pvt. Ltd.
Ahmedabad
www.acutesoftwares.in

[Manish Negandhi]

Post by hitgon
can i restore the data which is only in EASY_BANK_LOB schema in ACUTE
db ?
can i restore the data which is only in EASY_BANK schema in ACUTE db ?

You can use bcp out to export data and bcp in to import data, have a
look at bcp syntax in ASE manuals

HTH
Manish Negandhi
[TeamSybase]

[[e-mail]]

Post by Manish Negandhi

Post by hitgon
can i restore the data which is only in EASY_BANK_LOB schema in ACUTE
db ?
can i restore the data which is only in EASY_BANK schema in ACUTE db ?

You can use bcp out to export data and bcp in to import data, have a
look at bcp syntax in ASE manuals
HTH
Manish Negandhi
[TeamSybase]

Or use the archive database feature of 12.5.4/15.0.2.

This allows you to open a database dump as a read-only database, and
then extract the data you need via normal SELECT statements.

Michael