Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
This is a discussion on I want to convert that database to SQLSERVER database within the Oracle forums, part of the Databases category; I am using Oracle database to retrieve some data. Now i want to convert that database to SQLSERVER database. Is it possible to convert and retrieve data from Sql server. ...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
![]() |
| LinkBack | Thread Tools | Display Modes |
|
|||
|
I want to convert that database to SQLSERVER database
I am using Oracle database to retrieve some data. Now i want to convert that database to SQLSERVER database. Is it possible to convert and retrieve data from Sql server. If possible. Give me the detailed solution.
Thanks & Regards vijay |
| Sponsored Links |
|
|||
|
Re: I want to convert that database to SQLSERVER database
what do u mean by convert that database to SQLSERVER database.
Do u want to copy certain tables from ORACLE into SQL SERVER or what ? |
|
|||
|
Re: I want to convert that database to SQLSERVER database
Question is not clear, but what i understood you want to copy into sqlserver. So just extract the data from oracle with some delimitor and BCP in into the sqlserver having tables with same layout.
|
|
|||
|
Hi
I din't understood the question. I came to know that you want to move the databse from oracleDB to SQL Server DB. try following steps I hope it make works 1) first of all open MS-Access and import the data from oracle database later export the data to SQl Server DB Regards, Phanikanth |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Database | sakshi_2801 | Testing Issues | 5 | 06-18-2009 03:13 PM |
| Project database size and schema in database | Geek_Guest | Data Warehousing | 2 | 12-21-2008 06:45 PM |
| Relationship between SQL server, database and database applications | Geek_Guest | SQL | 1 | 07-10-2007 03:21 AM |
| Database Error: Failed to connect to database | srivenu | Data Warehousing | 0 | 04-01-2007 05:08 AM |
| SQL Database | sane_rt | Oracle | 3 | 11-14-2006 10:26 PM |