Solved

Work with Sybase data using SQL Server 2008

Posted on 2014-04-01
7
415 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

920 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

12 Experts available now in Live!

Get 1:1 Help Now