| Author |
Data porting from ASE to IQ
|
|
|
| We are having a db of 20GB in ASE 12.5.1
we are building a new iq 12.5 and would like to port all the data of the 20GB db
in to the iq.
is there any tool available to copy the schema so that we can bcp and use the
load table statement to put in iq?
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
| |
|
| > We are having a db of 20GB in ASE 12.5.1
>
> we are building a new iq 12.5 and would like to port all
> the data of the 20GB db in to the iq.
>
> is there any tool available to copy the schema so that we
> can bcp and use the load table statement to put in iq?
>
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp
power designer worked well for me
| |
| Frik Lubbe 2005-03-30, 7:08 pm |
| amir wrote:
>
>
> power designer worked well for me
Yes, use Sybase Power Designer to reverse engineer the ASE and then
forward engineer it to Sybase IQ. Use the INSERT INTO...LOCATION
statement to extract the data from ASE and insert it to IQ without BCP
and LOAD.
FRIK
| |
|
| Frik,
I did these and it seems to be fine. But to get a double confirmation, pls find
below what i did.
1. created necessary tables in iq server as in ase server
2. create server server entry in iq
---CREATE SERVER ASE CLASS 'asejdbc' USING 'host:port/ASEDB'
3. create external login in iq
---CREATE EXTERNLOGIN <iqlogin> TO ASEREMOTE LOGIN <aselogin> IDENTIFIED BY
<aseloginpwd>
4. create existing table entry in iq
---CREATE EXISTING TABLE <asetable> AT '<ASE.ASEDB.ASEtable'
5. now insert command in iq
---insert into <iqtable> location 'ASE.ASEDB'(select * from asetable)
the above steps worked fine for me even for millions of rows in quick time, just
wanted to re-confirm these are the correct steps.
thanks
On 23 Mar 2005 22:01:05 -0800,
in sybase.public.iq
Frik Lubbe <frik@nospam.sybase.co.za> wrote:
>amir wrote:
>
>Yes, use Sybase Power Designer to reverse engineer the ASE and then
>forward engineer it to Sybase IQ. Use the INSERT INTO...LOCATION
>statement to extract the data from ASE and insert it to IQ without BCP
>and LOAD.
>
>FRIK
| |
| Jeff Tallman 2005-03-30, 7:08 pm |
|
Steps 2-4 are unnecessary if using insert/location - they are only used
if needing to use proxy access.
CPN wrote:[color=darkred
]
> Frik,
>
> I did these and it seems to be fine. But to get a double confirmation, pls find
> below what i did.
>
> 1. created necessary tables in iq server as in ase server
> 2. create server server entry in iq
> ---CREATE SERVER ASE CLASS 'asejdbc' USING 'host:port/ASEDB'
> 3. create external login in iq
> ---CREATE EXTERNLOGIN <iqlogin> TO ASEREMOTE LOGIN <aselogin> IDENTIFIED BY
> <aseloginpwd>
> 4. create existing table entry in iq
> ---CREATE EXISTING TABLE <asetable> AT '<ASE.ASEDB.ASEtable'
> 5. now insert command in iq
> ---insert into <iqtable> location 'ASE.ASEDB'(select * from asetable)
>
> the above steps worked fine for me even for millions of rows in quick time, just
> wanted to re-confirm these are the correct steps.
>
> thanks
>
> On 23 Mar 2005 22:01:05 -0800,
> in sybase.public.iq
> Frik Lubbe <frik@nospam.sybase.co.za> wrote:
>
|
|
|
|