pbcharlie
Technical User
- Jan 16, 2002
- 55
Is there a quick way to transfere a Oracle database to sql?
Thanks in advance
Charlie
Thanks in advance
Charlie
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Oracle to SQL Server 1
- Thread starter pbcharlie
- Start date
- Status
-
1
- #2
Yeah...Since u ask this Q in DTS forum.So use ActiveX and open a connection with
Dim objConn
Set objConn = CreateObject("ADODB.Connection"
Dim strConnection
strConnection="PROVIDER=OraOLEDB.Oracle;DATA SOURCE=beq-local;USERID=scott;PASSWORD=tiger;PLSQLRSet=1"
objConn.Open strConnection
objConn.Execute "SQL Command"
-----------------------------------------------------------
Or use openquery and openrowset to move data
Dim objConn
Set objConn = CreateObject("ADODB.Connection"
Dim strConnection
strConnection="PROVIDER=OraOLEDB.Oracle;DATA SOURCE=beq-local;USERID=scott;PASSWORD=tiger;PLSQLRSet=1"
objConn.Open strConnection
objConn.Execute "SQL Command"
-----------------------------------------------------------
Or use openquery and openrowset to move data
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question