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
Solved

Using SQL query

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying 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

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how the fundamental information of how to create a table.

860 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