I
I
iklementiev2012-09-03 21:44:49
Data conversion
iklementiev, 2012-09-03 21:44:49

How to convert Sybase database to MSSQL?

Good afternoon.
Colleagues, please help me solve this problem.
Input:
Cegedim database file (file with .db extension).
At the end: I
want to get this database in MS SQL
Using google and enumeration of versions, we managed to understand empirically that the database is from Sybase 7 Anywhere.
Because The 7th version is very old and spat heavily on win7 x64, deployed it on a virtual machine with Windows XP x86
Completely not knowing what to do and from which side to approach, I went to ODBC and set up something as follows:
92d363e000b9102c163f0226ebe61fbd.png
4c35e6171437af5e591fc4e4248b037c.png
14823c458bb8966b7df8d734bc56c9d7.png
Next, google suggested that you can convert the database using the program Full Converter Enterprise (I have version 5.19)
It successfully converts the Sampe database that appeared when installing Sybase 7 Anywhere.
But here with my base it is impossible to cope.
3e6a59ec322bdbe6d887663ebce590fd.png
The first problem was solved quite simply
e51d90fc7821c3417991ad5da18b7d23.png
C:\Program Files\Sybase\SQL Anywhere 7\win32>dbeng7.exe -c 500m C:\share\db1.db
Now there is a problem with authorization
df9cdde24a958a1e222b7f48cdd2c07e.png
As far as I understand, you can enable Integrated logins by changing LOGIN_MODE to Mixed or integrated. You can do this with the SET OPTION Public.LOGIN_MODE = Mixed command.
But you can't connect through the Interactive SQL snap-in either.
8423b4d8637d79461a5b4eca80ef4d66.png
Login\password to the database is unknown to me. There is no way to make the database publicly available.
Help advice. Thanks in advance!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
rasa, 2012-09-05
@rasa

If you have Sybase 7 Anywhere, then the default login: DBA
password: SQL
will not work?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question