ImpInTraining
Programmer
This is probably a pretty easy question, but I can't be sure. I have very little experience with SQL. I have access to an Oracle server. I have created some identical tables in SQL Server 2012.
ORACLE = Table1 ; Table2 ; etc.
SQL Server 2012 = NEW_Table1 ; NEW_Table2 ; etc.
All of the fields of these copied tables are likewise identical but prepended with a little indicator:
ORACLE = Column1 ; Column2 ; etc.
SQL Server 2012 = NEW_Column1 ; NEW_Column2 ; etc.
What I need to do is develop a script that will import all of the data of the ORACLE tables I am interested in into SQL Server tables. I saw the SELECT INTO command and thought I was on to something, but that will create new tables and I don't really want to create new tables since I already have some in place.
Any suggestions out there?
ORACLE = Table1 ; Table2 ; etc.
SQL Server 2012 = NEW_Table1 ; NEW_Table2 ; etc.
All of the fields of these copied tables are likewise identical but prepended with a little indicator:
ORACLE = Column1 ; Column2 ; etc.
SQL Server 2012 = NEW_Column1 ; NEW_Column2 ; etc.
What I need to do is develop a script that will import all of the data of the ORACLE tables I am interested in into SQL Server tables. I saw the SELECT INTO command and thought I was on to something, but that will create new tables and I don't really want to create new tables since I already have some in place.
Any suggestions out there?