Michael Maddison
michael at ddisolutions.com.au
Mon Mar 13 21:49:39 CST 2006
Hi Patricia, DTS is what you are after. It would not take long to whip up a DTS package to handle the import from Oracle. You can then schedule the package to run monthly. I'd also write a function to determine the date range you want to import so no human intervention would be required. cheers Michael M www.ddisolutions.com.au -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of O'Connor, Patricia (OTDA) Sent: Tuesday, 14 March 2006 6:43 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Data from Oracle to SQL Server I am not that knowledgeable in SQL SERVER. Will become more so in the next few months but need some help now. Thanks in advance for any help. We have a large database in ORACLE. From this is generated a monthly summary report that does contain calculated fields. They have now decided they want to create a table on an MS SQL SERVER database that contains/matches the data in this report. One person wants to have a special view created on the Oracle DB for each month so that they can use an MS SQL Server WIZARD to extract this data to Sql server. The last thing I want is to have to use a WIZARD every month or have one non-IT person responsible to run this wizard every month. I prefer to have things like this in a PRODUCTION ROUTINE type mode. Either a proc or sql query/make table query that can be scheduled to run. One person says they can't run a query that has calculated fields to make a table in SQL server. I know in ORACLE I can make a table using query and subqueries containing pretty much any type field including calculated fields. Can't this also be done from a SQL SERVER database. Granted the original data is located in another database. Can you send me an example on how to set this up or where to look. Patti ************************************************** * Patricia O'Connor * Associate Computer Programmer Analyst * OTDA - BDMA * (W) mailto:Patricia.O'Connor at otda.state.ny.us * (w) mailto:aa1160 at nysemail.otda.state.ny.us ************************************************** -------------------------------------------------------- This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com