?
Solved

Using SQL query

Posted on 1998-08-16
2
Medium Priority
?
218 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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 information from SQL Server on Database, Connection and Server properties
Suggested Courses

777 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