Solved

Using SQL query

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

786 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