Solved

Work with Sybase data using SQL Server 2008

Posted on 2014-04-01
7
406 Views
Last Modified: 2014-04-03
Hi experts,

OK...I am using SQL Server 2008 and have been sent a Sybase database to analyse.  

I have never used, or even seen, Sybase.

I installed Sybase SQL Anywhere and went to restore the database, but I couldn't do it because "the file was created using a different version".

I would prefer to get the data into SQL Server but will work with Sybase if necessary.

Thanks in advance for your help, I am fumbling around in the dark here!

Cheers,

  Col
0
Comment
Question by:colinspurs
  • 3
  • 3
7 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 39969910
"... have been sent a Sybase database to analyse"

A database OR a Sybase database Backup?

Regardless...you need to install a Sybase server and attach or restore it on that Sybase Server prior to "analyse" it.

http://www.sybase.ca/linux/ase

http://www.sybase.com/advantage-30daytrial
0
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 39970988
Yeah, we need to know a bit more information here. What exactly do you have? (The questions of database vs. backup is pretty important.) Which Sybase database product? (There are several.) Which version?
0
 
LVL 3

Author Comment

by:colinspurs
ID: 39971981
Ok I can see I was mean with the info.

I was sent a .db file and it was described as a database by the sender.

It is version 9.

<you need to install a Sybase server>...is SQL Anywhere not a Sybase server?

I am using Windows 7.  I downloaded and installed a free developer version of SQL Anywhere 16.    I could not connect directly to the file supplied (“it was created in another version” was the reason given).

I found the unload utility and used that to populate a new database that I created, and was able to interrogate that.  

I would still like to connect to it from SQL Server though, an ODBC driver for Sybase is necessary for that?  I am having trouble locating one, it may not be available to the free version I am using, I am not sure.

Cheers,

  Col
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 3

Author Comment

by:colinspurs
ID: 39972360
Lcohan, the links you gave are down...probably to do with SAP taking it over.
0
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 500 total points
ID: 39974118
SQL Anywhere is a Sybase server, yes. :)

What I would have meant by that comment is that it's like MS SQL in that you need to have a database engine installed and correctly set up to use the .DB file as its database. Sounds like you got what you needed.

You will indeed need an ODBC driver to connect to your SQL Anywhere instance. It should be included in the install media you used, even the free eval version. Note that it will be part of the client-side tools, not the server.
0
 
LVL 3

Author Comment

by:colinspurs
ID: 39974368
Hi Joe, that comment was meant for lcohan who obviously hadn't read my post properly, but nevertheless I appreciate the fact you have both tried to help.

Yes, I have found find that driver thanks.  As you say it was there in the client-side tools.

Cheers,

  Col
0
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 39974383
Glad we could help!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now