|
Home > Archive > SQL Anywhere database > October 2005 > Sybase Database to SQL Anywhere
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Sybase Database to SQL Anywhere
|
|
|
| I am new to SQL Anywhere. Can someone give me steps for
moving data from sybase to sql anywhere? Maybe take a data
cut and load it into sql anywhere. The sql anywhere is on my
laptop so basically i want to do remote development with out
having a remote connection.
Thanx in advance.
| |
| Greg Fenton 2005-10-28, 8:23 pm |
| ZAS wrote:
> I am new to SQL Anywhere. Can someone give me steps for
> moving data from sybase to sql anywhere?
Do you mean moving data from Sybase ASE to SQLAnywhere?
Which version of SQLAnywhere are you going to be using?
If you are using v8 or v9, then take a look at the Data Migration Wizard
in Sybase Central. Essentially you create a connection between your
SQLAnywhere database and a "remote server" (which can be just about any
ODBC, JDBC, ASA or ASE connection) and then have the Migration Wizard
copy over some or all of the schema and data from the remote server.
Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| Thanx Greg! That helps. Yes it is sybase 11 and i have sql
anywhere 9.0.2 on my laptop. But i guess my question is
still that without having to make a remote connection
(odbc), can i take a dump from syabse and then sql anywhere
can take that dump file and load/create new db. odbc
connection would be a resrtiction due to corporate boundry.
Thanx for your prompt response.
> ZAS wrote:
>
> Do you mean moving data from Sybase ASE to SQLAnywhere?
> Which version of SQLAnywhere are you going to be using?
>
> If you are using v8 or v9, then take a look at the Data
> Migration Wizard in Sybase Central. Essentially you
> create a connection between your SQLAnywhere database and
> a "remote server" (which can be just about any ODBC, JDBC
> , ASA or ASE connection) and then have the Migration
> Wizard copy over some or all of the schema and data from
> the remote server.
>
> Hope this helps,
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
| |
| Breck Carter [TeamSybase] 2005-10-28, 8:23 pm |
| The SQL Anywhere LOAD TABLE statement can be used with FORMAT BCP, so
if you use bcp to unload or dump tables from ASE you should be able to
load them into SQL Anywhere. Caution: ASE bcp is not the easiest
utility to work with :)
On 28 Oct 2005 12:44:46 -0700, ZAS wrote:
[color=darkred]
>Thanx Greg! That helps. Yes it is sybase 11 and i have sql
>anywhere 9.0.2 on my laptop. But i guess my question is
>still that without having to make a remote connection
>(odbc), can i take a dump from syabse and then sql anywhere
>can take that dump file and load/create new db. odbc
>connection would be a resrtiction due to corporate boundry.
>Thanx for your prompt response.
>
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
| Greg Fenton 2005-10-30, 3:23 am |
| ZAS wrote:
> Thanx Greg! That helps. Yes it is sybase 11 and i have sql
> anywhere 9.0.2 on my laptop. But i guess my question is
> still that without having to make a remote connection
> (odbc), can i take a dump from syabse and then sql anywhere
> can take that dump file and load/create new db. odbc
> connection would be a resrtiction due to corporate boundry.
Breck points out that BCP is one option.
But I wonder, can you not make a (brief) ODBC or JDBC connection to the
ASE database for a one time migration?
When you are using Data Migration, the ASA database is essentially just
a "client" application to the remote server (ASE in this case).
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
|
|
|
|
|