?
Solved

Using SQL query

Posted on 1998-08-16
2
Medium Priority
?
226 Views
Last Modified: 2010-03-19
Hi,
I am using a (Seagate) Crystal Report, and a network database (mdb & dbf). I am not using any Crystal Report's SQL query yet becos' I don't have a SQL server. The Crystal Report is connected to the data-source with an ODBC driver of its kind.
Qn:
Now, the database files already exists, running with a business application. After i install an SQL server (MS/Oracle), is there a method to utilise the existing database files & SQL, without creating the databases again within the SQL server ? Or should i need to convert/migrate the databases to SQL databases ? If using the SQL databases, i will disable/void the compatibility of the business application.
Await for your answers.
Best Regards,
Collin Ng.
0
Comment
Question by:collinng
2 Comments
 
LVL 2

Accepted Solution

by:
jbiswas earned 200 total points
ID: 1089579
No you will be able to utilize very little of your access backend for Oracle or Microsoft SQL Server. The database schema in both is very different from Access and Oracle SQL is specially very different. There are a lot of datatypes that wont match. What is text in Access, is called varchar in Oracle. Erwin has a database migration tool that does a pretty nifty job, but my advice would be to rewrite all the sql and tune them as you go. This is a fairly simple job but painstaking since now you have to check that the sql here produces the same results. However access is not much of a database and you'll have to migrate sooner or later.
0
 

Author Comment

by:collinng
ID: 1089580
Kindly give me your advise/opinion again on below:
If i need to re-create databases, i suppose my functional business application (Scala4.1) has to be an independent software from any type of databases. But is it so - the Scala system ? If it is, then the problem isn't big, and needs only changing of the ODBC driver to SQL ODBC, right ? Or it is not so simple ? So it is pretty important to write software for ODBC environment...
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

588 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