Sybase BULK COPY
Posted: Mon Jun 29, 2009 5:24 am
All,
I need to move PROD data into DEV & QA on every night. There are around 8 tables which i need to move.
Each of them have around 600000 records.
I used sybase OC to move data to DEV & QA.
I used 'clear table then insert rows' option, it is nothing but, 'Truncate and then insert' which will fill the transaction log. It also took around 1 hr to complete the execution.
So i have been asked to use sybase BCP stage. Since i am not aware of this stage, i got struck to use this.
I created the job as below.
sybase OC---> Tranformer --> sybase BCP
Prod server ---------------------> DEV server
when i execute the above job,
BCP..Sybase_BCP_Load_1: Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does not exist or network access denied.
BCP..Sybase_BCP_Load_1: Login failed
Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does not exist or network access denied.
i got the above error messages
I need to move PROD data into DEV & QA on every night. There are around 8 tables which i need to move.
Each of them have around 600000 records.
I used sybase OC to move data to DEV & QA.
I used 'clear table then insert rows' option, it is nothing but, 'Truncate and then insert' which will fill the transaction log. It also took around 1 hr to complete the execution.
So i have been asked to use sybase BCP stage. Since i am not aware of this stage, i got struck to use this.
I created the job as below.
sybase OC---> Tranformer --> sybase BCP
Prod server ---------------------> DEV server
when i execute the above job,
BCP..Sybase_BCP_Load_1: Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does not exist or network access denied.
BCP..Sybase_BCP_Load_1: Login failed
Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does not exist or network access denied.
i got the above error messages