Solved

Work with Sybase data using SQL Server 2008

Posted on 2014-04-01
7
420 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SqlDataBase 7 46
query execution hang 5 28
How to search for strings inside db views 4 24
what are the unique tables in SQL master database 5 57
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…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

815 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