Solved

Convert D-base & SQLAnywhere dbs to SQL Server 6.5 dbs?

Posted on 1998-09-16
2
314 Views
Last Modified: 2010-03-19
 Is it possible (and if so... How?) to convert .db and .db2 databases to a SQL database.  I have a few .db databases that were 1st generated Sybase's SQLAnywhere(used in SilverStream) and also some D-base databases(generated through Clipper) -- I would like to upgrade them to SQL Server 6.5 databases.  Is there a particulare utility in SQL Server 6.5 to do this?  Will any integrity from these databases be lost in the conversion?
0
Comment
Question by:dickeys
2 Comments
 
LVL 2

Expert Comment

by:odessa
ID: 1090097
there are many way's to convert data, the right word is UPSIZING,
the best way that I now is to do it throu DataDump, witch is comming with delphi 2.0 +, there you can convert any type of data to other only you need to have a ODBC drivers to initial data and to target.

0
 
LVL 2

Accepted Solution

by:
martyn_bannister earned 50 total points
ID: 1090098
DickeyS,

One approach I have used in the past is to download the trial version of Powerdesigner ("S designor" as was) from the Sybase/Powersoft web site. This has very powerful utilities for reading the schema of one dataabse and writing it out in another format. If you find it useful you could always buy it!


0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Using a hta file with MSSQL agent to schedule a script job 4 39
SQL Stored Proc - Performance Enhancement 15 54
SQLCMD Syntax 2 13
Help With SQL Query 9 30
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

856 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