Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jaywebguy
Starting Member
3 Posts |
 Posted - 2008-10-10 : 13:22:48
|
| Although I'm not totally new to SQL, my past experience mainly has focused on writing update/insert query scripts within web languages like ASP and CF.I've been tasked with putting together a working model on transferring data between two systems (from oracle 10g to SQL Server). My current method involves :1. creating views in Oracle to standardize the data between the two databases2. Use coldfusion to handle the connections between the two database.3. Write script in coldfusion to query out data from Oracle views, then insert records into SQl server.This methods works, but has limitation with how many records it can handle, as well as maintenance issues.What I want to be able to do, 1.Export the data from the views into flat files (easy enough)2. FTP files to sql server (easy enough).3. Use Bulk loader command in SQL server to load data into temp tables (I think I can do this)4. Use PL SQL to then delete matching records from real tables5. Use PL SQL to load new record from temp tables into real tables.Number 4 and 5 are what I need help with, plus I wouldn't mind some feedback on my plan. Can someone point me in the right directions to get started with number 4 and 5?Thanks, sorry it was so long.Jason |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-10-10 : 16:08:41
|
| Use LINKED SERVERS to update the your real tables with the view in Linked Server. |
 |
|
|
|
|
|
Load Script