idfortekniks
IS-IT--Management
ANYONE TO HELP ME AROUND WITH THIS..
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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Oracle Schema to SQL Server
- Thread starter idfortekniks
- Start date
- Status
richardtsa
Programmer
Firstly do you have the oracle client and the sql server client on your PC. If so you setup your odbc for oracle and then you go to Sql server (I have SQL server 7) and go to the Tools Menu and select Data Transformation Services then select import.
Then in source select other(odbc data source).
Then in the user/system dsn select the odbc you have created
Enter your user name and password then press next.
In the next screen you will specify in which database you want to copy the tables to.
After this click next.
In the following screen select copy tables from source database and click next on the next screen select the tables that you want to copy in the schema.
Hope this helps
Then in source select other(odbc data source).
Then in the user/system dsn select the odbc you have created
Enter your user name and password then press next.
In the next screen you will specify in which database you want to copy the tables to.
After this click next.
In the following screen select copy tables from source database and click next on the next screen select the tables that you want to copy in the schema.
Hope this helps
- Status
Similar threads
