Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

migrating from SQLAnywhere to SQL Server

4 posts in Windows NT Last posting was on 1997-10-07 19:19:47.0Z
Brent Groom Posted on 1997-10-06 19:42:37.0Z
Message-ID: <34393F2D.4D02DE4E@opennet.net>
Date: Mon, 06 Oct 1997 13:42:37 -0600
From: Brent Groom <groom@opennet.net>
X-Mailer: Mozilla 4.01 [en] (WinNT; I)
MIME-Version: 1.0
Subject: migrating from SQLAnywhere to SQL Server
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 9
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5487
Article PK: 1081570

Is there any way to get my
database schema and data from
SQLAnywhere and copy it to my
SQL Server Professional
database. I noticed in the
help for SQL Central that I
should be able to drag and
drop. The only problem is
that I cannot connect to my
SQL anywhere database from SQL
Central. I also do not have
SQL Advantage for some reason.


Lance Andersen Posted on 1997-10-07 12:57:05.0Z
Message-ID: <343A31A1.411B@sybase.com>
Date: Tue, 07 Oct 1997 08:57:05 -0400
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 3.01Gold (X11; I; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: Brent Groom <groom@opennet.net>
Subject: Re: migrating from SQLAnywhere to SQL Server
References: <34393F2D.4D02DE4E@opennet.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 25
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5485
Article PK: 1081566


Brent Groom wrote:
>
> Is there any way to get my
> database schema and data from
> SQLAnywhere and copy it to my
> SQL Server Professional
> database. I noticed in the
> help for SQL Central that I
> should be able to drag and
> drop. The only problem is
> that I cannot connect to my
> SQL anywhere database from SQL
> Central. I also do not have
> SQL Advantage for some reason.

You should be able to connect to SQL Anywhere and SQL Server
from SQL Central.

Check your version of SQL Central as I believe this has to be
at least 2.0.
--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Technical Support Phone:(617) 564-6336
77 South Bedford Street Fax: (617) 564-6148
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================


Jim Moriarty Posted on 1997-10-07 19:19:47.0Z
From: "Jim Moriarty" <Jim.Moriarty@ho.tradenz.govt.nz>
Subject: Re: migrating from SQLAnywhere to SQL Server
References: <34393F2D.4D02DE4E@opennet.net> <343A31A1.411B@sybase.com>
Organization: Tradenz
Message-ID: <01bcd35f$30824990$1d01de80@moriarty>
X-Newsreader: Microsoft Internet News 4.70.1162
Newsgroups: sybase.public.sqlserver.nt
Date: Tue, 07 Oct 1997 15:19:47 -0400
Lines: 29
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5483
Article PK: 1081563


Lance Andersen <lancea@sybase.com> wrote in article
<343A31A1.411B@sybase.com>...
> Brent Groom wrote:
> >
> > Is there any way to get my
> > database schema and data from
> > SQLAnywhere and copy it to my
> > SQL Server Professional
> > database. I noticed in the
> > help for SQL Central that I
> > should be able to drag and
> > drop. The only problem is
> > that I cannot connect to my
> > SQL anywhere database from SQL
> > Central. I also do not have
> > SQL Advantage for some reason.
>
> You should be able to connect to SQL Anywhere and SQL Server
> from SQL Central.
>
> Check your version of SQL Central as I believe this has to be
> at least 2.0.

And you might need to register SQL Anywhere with SQL Central...

If you dont have the *option* to open a SQL Anywhere database then...

Select Tools->Plug Ins and click on Register..
Type in the location of the scsqlany.dll (I think, if memory serves me
right) or browse for it.
Click on OK or Close or whatever back out to SQL Central main window.
You might need to restart SQL Central ???

You should now have a SQL Anywhere section.

Jim


David Lance Wolf Posted on 1997-10-06 22:54:11.0Z
Message-ID: <34396C13.3B8A37E8@sybase.com>
Date: Mon, 06 Oct 1997 15:54:11 -0700
From: David Lance Wolf <dwolf@sybase.com>
Organization: Sybase Professional Services
X-Mailer: Mozilla 4.02 [en] (Win95; I)
MIME-Version: 1.0
Subject: Re: migrating from SQLAnywhere to SQL Server
References: <34393F2D.4D02DE4E@opennet.net>
Content-Type: multipart/mixed; boundary="------------3380DF2601976D2EB1CDD55D"
Newsgroups: sybase.public.sqlserver.nt
Lines: 36
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5486
Article PK: 1081568

PowerDesigner is good at this in so far as moving the schema. As for
the data, you could use PB's data pipeline, or unload out and BCP back
into SQL Server.

Dave Wolf
Sybase Professional Services

Brent Groom wrote:
>
> Is there any way to get my
> database schema and data from
> SQLAnywhere and copy it to my
> SQL Server Professional
> database. I noticed in the
> help for SQL Central that I
> should be able to drag and
> drop. The only problem is
> that I cannot connect to my
> SQL anywhere database from SQL
> Central. I also do not have
> SQL Advantage for some reason.


Download VCard vcard.vcf