I am splitting 10 existing tables statewise. Each such split table will have
a distinct name. Eg: In case of Family table, it will have the name of the
Tables as, Family Karnataka, FamilyAndhrapradesh etc. I have opened 25 new /
different Databases with the respective names of the states - such as
Karnataka, Andhra Pradesh etc.

Now, I want to copy these split tables to the respective databases. Such as
FamilyKarnataka to the database of Karnataka and FamilyAndhraPradesh to the
database Andhra Pradesh.

Please duide me...

S Haresha Babu
Sr Manager (IT)
Syndicate Bank
Head Office
MANIPAL - 576104
KARNATAKA
INDIA

What is your rationale for spliting?

--
Build a little, test a little.


"Bobharis" wrote:

> I am splitting 10 existing tables statewise. Each such split table will have
> a distinct name. Eg: In case of Family table, it will have the name of the
> Tables as, Family Karnataka, FamilyAndhrapradesh etc. I have opened 25 new /
> different Databases with the respective names of the states - such as
> Karnataka, Andhra Pradesh etc.
>
> Now, I want to copy these split tables to the respective databases. Such as
> FamilyKarnataka to the database of Karnataka and FamilyAndhraPradesh to the
> database Andhra Pradesh.
>
> Please duide me...
>
> S Haresha Babu
> Sr Manager (IT)
> Syndicate Bank
> Head Office
> MANIPAL - 576104
> KARNATAKA
> INDIA