473,385 Members | 1,154 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

database migration using DTS help

40
dear experts, i heard recently, that using DTS, we can convert databases from sql server to oracle. if so, please provide me the process and steps to follow.



thank you very much
Sep 14 '06 #1
2 1731
aramki
9
You should just be able to use DTS to move the tables and data from SQL Server to Oracle. DTS can make OLE DB connections to any database that supports OLE DB.

Hint: you can use the DTS Wizards in the tools menu of the Enterprise manager.
Sep 14 '06 #2
hi,
you can proceed in this way

Goto...
Action -> All Task ->Export Data

then as per your requirement .............you can proceed.

if you require more quidelines
plz feel free..
Sep 15 '06 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: democratix | last post by:
Hi, I've only got a couple years experience developing for Access but have recently been experimenting with HTML/javascript for gui and client-side scripting, mysql for database and php for...
2
by: LizP | last post by:
Could someone help us with a problem we're having with regard to moving several databases from SQL 7 to SQL 2000 on different servers in different domains. Our current SQL 7 server resides in one...
0
by: Patrick Finnegan | last post by:
Running UDB V7 FP10a and 8.1 .4 on Windows 2000. Did full offline backups of three V7 databases. Restored two databases to V8 instance successfully. Third restore ended with: SQL2517W The...
11
by: Jep | last post by:
Any help or advice appreciated. We have just installed and configured a new DB2 v.8.1 with latest FixPack. Just a few days later it dies and now we have a DB that is totally unusable. - - - -...
5
by: Hassan Naqvi | last post by:
Hi, Basically, I am Java developer. In past I have played with Oracle using Java (JDBC). But this is the time to play with IBM DB2 using Java (JDBC). So kindly help this DB2 newbie. I have a...
4
by: Collin Peters | last post by:
I have searched the Internet... but haven't found much relating to this. I am wondering on what the best practices are for migrating a developmemnt database to a release database. Here is the...
0
by: Rodolfo | last post by:
Hi everybody! I have migrated some tables from a database in Informix to a database in SQL Server 2000 using the DTS via ODBC. I installed the Informix Client SDK in order to make my conection....
21
by: nihad.nasim | last post by:
Hi there, I have a database in Access that I need on the web. The web page should connect to the database and write records for certain tables and view records for others. I want to know a...
2
by: Alex | last post by:
Hi, Probably a simple question :-) I've got a few xml aware databases on a 9.1.2 db2 server running on RHEL 4. As db2 V9.5 doesn't run on RHEL 4 I've set up a new server running RHEL5.1 with...
3
Frinavale
by: Frinavale | last post by:
I have been researching the best approach to migrating a VB6 application into a VB.NET application. There is a lot of information out there but most of it recommends that you "train in the migration...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.