Solved

Using SQL query

Posted on 1998-08-16
2
215 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 50 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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

729 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