Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transfer Database from Oracle

Status
Not open for further replies.
ecobb

ecobb

Programmer
Dec 5, 2002
2,190
US
I have a database (approx. 10 gigs and 200+ tables) on our Oracle 8i server and I would like to get a copy of the database/table structure over to our SQL Server (2000). I know I could import the whole database over with no problem, but I was wondering if there was some way through DTS or Query Analyzer that I could get a "blank" copy of the database moved over to SQL Server.

Thanks
 
Status
Not open for further replies.

Similar threads

TomCarnahan
  • Locked
  • Question
Passing Variables from Parent to Child DTS Packages
Replies
0
Views
78
TomCarnahan
TomCarnahan
Ascalonian
  • Locked
  • Question
How do I bring an Oracle BLOB into SQL Server?
Replies
0
Views
42
Ascalonian
Ascalonian
plugsharma
  • Locked
  • Question
Database backup (URGENT)
Replies
1
Views
84
mrdenny
mrdenny
rodeomount
  • Locked
  • Question
Importing a subset of records from ORACLE
Replies
1
Views
39
mrdenny
mrdenny
plevey
  • Locked
  • Question
Extracting data from a Progress SQL database truncates varchar columns
Replies
0
Views
30
plevey
plevey

Part and Inventory Search

Sponsor

Back
Top