151 reputation
3
bio website
location
age
visits member for 1 year, 9 months
seen Aug 14 at 1:20

Incredibly handsome


Jul
24
awarded  Commentator
Jul
24
comment Copying a table in SQL Server database to Oracle database
The "t_database_link_sql_server_oracle.htm" link you referred to deals with setting up a link from Oracle to SQL Server and is irrelevant for this approach. In this approach you define the connection to Oracle in the destination step.
Jul
24
comment Copying a table in SQL Server database to Oracle database
For a thousand records there will be no performance issues no matter how you do it. The real challenge in your case is making something reliable that you can maintain yourself. Why don't you follow through the answer proposed below and ask any specific questions.
Jul
24
comment Copying a table in SQL Server database to Oracle database
OK, so you need to be on the server to do this. This will create a SSIS package which you should be able to schedule in a job. You will also need to install the Oracle client on the SQL Server in order to connect to Oracle.
Jul
24
comment Copying a table in SQL Server database to Oracle database
Very handy. What version of SQL Server is that? I can't see the export option in SSMS 2008 R2.
Jul
24
comment Copying a table in SQL Server database to Oracle database
If there is unlikely to be more than thousands of record then a TRUNCATE/INSERT solution should be fine rather than a more complicated CDC one. Do you want to 'push' the data from SQL Server or pull the data from Oracle? If you want to push from SQL Server you need to install the Oracle driver on the SQL Server.
Jul
24
comment Copying a table in SQL Server database to Oracle database
I assume the second time this is run duplicate data will be pushed over. Or does this process automatically clear the target table beforehand? You will also need to install the Oracle driver to do this.
Jul
24
comment Copying a table in SQL Server database to Oracle database
oh ,and exactly which version of SQL Server and Oracle?
Jul
24
comment Copying a table in SQL Server database to Oracle database
The data can never be synchronised in real time, there will always be some kind of latency. How big are the tables, how often are they changed, what is the volume of changes. Is it mainly inserts, updates or a mix of both? You first need to decide on a TRUNCATE/INSERT approach or a CDC (change data capture). You need to decide on a tool to transfer the data. If you are a beginner at this I suggest MS tools, not oracle ones. One MS tool to transfer data like this is `SSIS, though this is not necessarily the best option for real time replication, and is not the only option.
Apr
30
comment SQL Server agent job scripts
"Cannot run these packages until the source is closed." ? Is that an error you get? From where? SQL Agent? You should open a new question and explain in detail what you want to do, what you did and any errors that occurred. I assume from your response that your packages are saved in SQL Server, not in the file system.
Apr
29
comment SQL Server agent job scripts
You should ask another question and provide specifics, i.e. are your packages stored in the file system? What protection level do they use? What is your current issue - provide exact error messages if you have any. Please don't ask general question without providing specifics. Also please don't ask without trying something first.
Apr
29
answered SQL Server agent job scripts
Apr
13
comment Can't connect SQL Server through firewall
Have you verified, on the server, what port the SQL Server is listening on?
Apr
18
awarded  Teacher
Apr
18
answered Executing Child packages without using master package
Apr
17
answered How can I convert an Oracle dump file into SQL Server?
Apr
16
comment How can I convert an Oracle dump file into SQL Server?
You should consider a different way of transferring this data as you will never find a tool that can do this.
Apr
16
comment How can I convert an Oracle dump file into SQL Server?
I am fairly certain this is totally impossible.
Feb
15
awarded  Supporter
Feb
14
comment How can I make sure the SQL Server query optimizer uses the exact tables in the query
I must ask.. WHY don't you want to use use the indexed view result? Surely performance is superior? Is it giving you the wrong result - it shouldn't be.