Sending Data Between MS SQL 2000 && Oracle
Dec 4, 2006I need to send data from a MS SQL 2000 DB in one location down to a Oracle DB (Solaris) in another location. I was wondering how(if at all possible) how to do this.
View 1 Replies
ADVERTISEMENT
Migrade Oracle Data To SQL Server 2000
Aug 1, 2005I am doing a test on migrating an Oracle 8i database toSQL 2000. I've never done this before and I would liketo find out if there are any complications or side effectsif I try doing the transfer of data using DTS?If not DTS then what would you suggest I transfer datawith?Thank you
View 4 Replies View RelatedData Migration Oracle 7.16 To SQL Server 2000
Aug 22, 2006Hi,
I have been asked to look at optimising a Data Migration Strategy for one of our clients. I am quite new to Data Migration (I'm actually a system designer!).
The migration is from a legacy Oracle 7.16 Db to a SQL Server 2000 environment.
The legacy Db has some large tables - 30 Million+ rows
Table/column Mapping is 1:1
At present we are using DTS to import into the SQL environment.
My question is: Is there any way to leverage the Oracle 7.16 export to speed up the migration process?
Any advice would be appreciated.
Many thanks
Mike
Accessing SQL Server Data From Oracle Developer 2000 Apps
Feb 17, 1999Hello there
I have a customer that wants to start using SQL Server 7.0 instead of Oracle, but they have a lot of Oracle applications (made in Developer 2000 and Forms). Due to the big effort needed to convert those applications (to Visual Basic), they want to be able somehow to migrate only data from Oracle to SQL Server, and then use some tool that will allow them to use the same applications with the SQL Server 7.0 engine.
I found on the "SQL Server Developer's Kit" a document describing the process of migrating data and applications from Oracle to SQL Server. There is a mention to an Oracle tool called "Oracle Gateway to SQL Server" that will translate calls received by the Oracle engine to the SQL Server engine, but this approach will still require the existence of Oracle servers (which is the thing the customer no longer wants).
The second option mentioned on that document, and the one that seems more attractive, is the use of Oracle "Open Client Adapter" (OCA) that will allow Developer 2000 applications to communicate directly to SQL Server via ODBC. However, I have been unable to find (on the Oracle site) any documentation regarding this tool.
Has anynoe heard or used such tool (OCA) ? Any comments, tips, drawbacks, experience you could share ? Any other idea on how a thing like that could be accomplished ? Perhaps a third-party application that can act as a gateway between the Forms app and ODBC/SQL Server, or that will be able to generate VB code from a Developer 2000/Forms app...
Any help will be appreciated.
Please respond directly to me, as I am not a member of the distribution list.
Luis Francisco Silva
Sending Mail Using SQL Server 2000
Dec 19, 2007Hello Friends
I want to send mail using Stored Procedure using SQL Server 2000 using windows smtp component. I don't want third party component.
can any body send Stored Procedure.
SSRS 2000 SP2 Failure Sending Email
Sep 29, 2006I am getting this error when sending an excel file via email.
Failure sending mail: The Report Server has encountered a configuration error; more details in the log files
The scheduled job which emails an excel spreadsheet has been working and now it doesn't. I've done some research and this KB article is close to the error that I'm seeing however the win 32 error 87 is different. http://support.microsoft.com/?kbid=842423
Has anyone any idea's? I have not applied the hotfix for SSRS 2000 sp2.
Log file has this.
ReportingServicesService!library!7b4!09/28/2006-15:00:08:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files, AuthzInitializeContextFromSid: Win32 error: 87;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files
ReportingServicesService!library!7b4!09/28/2006-15:00:08:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!7b4!09/28/2006-15:00:08:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report Server has encountered a configuration error; more details in the log files ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files
at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper)
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyDate)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String renderFormat, String deviceInfo)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
Data Access :: Accessing Oracle Tables From Server Via Oracle DBLINK?
May 8, 2015we recently got a scenario that we need to get the data from oracle tables which is installed on third party servers. we have sqlserver installed on ourservers. so they have created a DBLINK in oracle server to our sqlserver and published the DBLINK name.
what are the next steps that i need to follow on my sqlserver in order to access the oracle tables ?
Sending Data To Excel
Apr 4, 2001I want to send data to a excel spreadsheet from SQL server 7.
I know that I can create a odbc dsn which points to a table or a view on SQL Server. That works well.
Is there any way to point to a stored procedure.
I want to pull data to a spreadsheet based on a stored procedure.
Any suggestions ?, Is it possible ?
Sending SQL Data To Access
Feb 22, 2005I've created a "data warehouse" for the Access users in my area. I take
data from SQL Server, and write it to a network access DB using DTS.
I don't want to link to the tables, I really need to put the data in an access
format. The problem I'm having is that I'm appending the data and not overwriting it. Is it possible to truncate those table before importing?
Do I have to use ActiveX Script to accomplish this?
Thanks
Mark
Sending Data From One Database To Another
Jan 18, 2007DBMS = SQL server 2005Web programming language = ASP.NETHiI have database 1 sat on server 1.I would like to move selected tuples from specific tables into database 2 sat on server 2.What do i need to research to try and find a method of doing this?Is the correct approach to move the selected data into a 'recordset' and if so how can i send this record set to database 2?many thanksBil
View 14 Replies View RelatedSending Replication Monitor Data
Jan 4, 2005We have a database on the live server which powers a website. Then our client has a copy of the database at their office. Their is Merge replication set up between the two running every half a hour.
Now they want to be able to look at the merge replication history.
With my little knowledge, I believe that the place to get this data from is the distribution database on the publishing machine which is the live server. Now for obvious reasons we cannot replicate the
distrubution database to their side so we need to come up with some way of giving them the data. They also want a history of replication.
So the way I was thinking of fixing it was to have a job that copies some of the last days data from the distrubution database onto the main database and add that table to the replication so they got it every day. Also writing a ASP page so they can look at the last days
data straight from the distrubution database.
Here are my questions:
Question 1:
How long does the replication store history for?
Question 2:
Is thier any simpler way of allowing them to see the replication history?
Question 3:
Are their any other things I should be worried about?
Thanks for any feedback, Nixies
Sending Data From SQL 2005 To And From C# Code
May 3, 2006Hi
Background: I am a post-graduate student developing a model of the way HIV/AIDS spreads in communities. The data sets I am using are large (eg census data - 50m records) and the manipulation is complex (eg deciding which individuals will begin a sexual partnership, and with whom).
Problem: I need to process a table of data in code written in C# that will insert the results which are also a table of data into a table in the database.
In the example set up below, a table with rows comprising an Integer and a Real is the input. The output is a table where each row also comprises an Integer and a Real. Each row of input, say (Inti, Reali) leads to Inti rows of output. The example below gives a simple example of this.
The T-SQL code below sets up the problem, and includes simplest possible T-SQL that would lead to the requisite Output, so that you could compare your solution's code's with it:
-- Set up tables to use in example
CREATE TABLE InputTable
(
Int1 INT NOT NULL,
Real1 REAL NOT NULL
)
GO
CREATE TABLE OutputTable
(
Int1 INT NOT NULL,
Real1 REAL NOT NULL
)
GO
--Initialise the Input Table
INSERT INTO InputTable (Int1, Real1) VALUES (3, 0.5)
INSERT INTO InputTable (Int1, Real1) VALUES (5, 0.99)
--Manually put Data into Output table
--I do know how to code this in T-SQL using cursors and loops
--I wish to code this part in CLR
INSERT INTO OutputTable (Int1, Real1) VALUES (1, 0.5)
INSERT INTO OutputTable (Int1, Real1) VALUES (2, 0.5)
INSERT INTO OutputTable (Int1, Real1) VALUES (3, 0.5)
INSERT INTO OutputTable (Int1, Real1) VALUES (1, 0.99)
INSERT INTO OutputTable (Int1, Real1) VALUES (2, 0.99)
INSERT INTO OutputTable (Int1, Real1) VALUES (3, 0.99)
INSERT INTO OutputTable (Int1, Real1) VALUES (4, 0.99)
INSERT INTO OutputTable (Int1, Real1) VALUES (5, 0.99)
--This should show the output
SELECT * FROM InputTable
SELECT * FROM OutputTable
--The output should be
Int1Real1
3 0.5
5 0.99
Int1Real1
1 0.5
2 0.5
3 0.5
1 0.99
2 0.99
3 0.99
4 0.99
5 0.99
Additional Information: I would be grateful if your solution could indicate
* whether the code to be written is a class, stored procedure or user-defined function
* the answer could be included in entirity begining with "using system..."
* example T-SQL that can be used to execute the code
Current knowledge:I can write T-Sql. I have written C# user defined functions and stored procedures, assembled them and run them from within SQL-Server 2005.
Thanks in advance.
Greg
SQL Mail Sending Attachment Of Data From A Table!
Mar 29, 2001Ok i have a programmer who wants to send out the data from a table as an email attachment via sql mail without having to write a com component. Does any one know the procedures on how to do this (i.e stored procedures and triggers ect and anything else i need or should know).
Please dont answer this unless you have some genuine help as I dont want to post this every time someone comes up with a smart ass comment!
Thanks guys
Sending Data To A Stored Procedure With ASP Error
Jul 23, 2005Hi all..I'm trying to send multiple INT values to a Stored Procedure that willbe handled in an IN statement.ASP Code:strSQL = "SP_Get_Selections '29, 32'where 29 and 32 are 2 integer valuesNow, in my stored procedure... I would like to look these values up inan IN statement likeCREATE Procedure SY_GET_SELECTIONS@authorid varchar(20)SELECT * FROM Authors WHERE AuthorID IN (@authorid)But when I use this, I get [Microsoft][ODBC SQL Server Driver][SQLServer]Syntax error converting the varchar value '29, 32' to a columnof data type int.Any help would be great.Thanks
View 1 Replies View RelatedError For Sending(saving) Data To Database
Feb 22, 2007Hi,I'm using VS2005 and I'm trying to link the C# windows form to MSSQL.I used BindingNavigator Control to read the data. After that I addsqlcommand and sqldataadapter to send the data to the database. Mycode is thissqlDataAdapter1. InsertCommand. CommandText ="INSERT INTO SUDENT (" +"S_ID, S_NAME, S_ADDRESS, S_PHONE" +") VALUES ('" +S_IDComboBox. Text + "', '" +S_NAMETextBox. Text + "', '" +S_ADDRESSTextBox. Text + "', '" +S_PHONETextBox. Text + "')";sqlDataAdapter1. InsertCommand. ExecuteNonQuery( );It gave me this error"NulleferenceExcept ion was Unhandled"and " Object refrence not set toan instance of an object" so I add this linesqlCommand1 = ("INSERT INTO STUDENT (S_ID,S_NAME, S_ADDRESS, S_PHONE)VALUES (@S_ID,@S_NAME, @S_ADDRESS, @S_PHONE) " ,sqlConnection1) ;Then it gave me some stupid error. By the way it didn't make a newobject of SqlCommand although I tired ....So can u help me to solve my problem ? Thank you
View 1 Replies View RelatedError For Sending(saving) Data To Database
Feb 22, 2007Hi,
I€™m using VS2005 and I€™m trying to link the C# windows form to MSSQL. I used BindingNavigator Control to read the data. After that I add sqlcommand and sqldataadapter to send the data to the database. My code is this
sqlDataAdapter1.InsertCommand.CommandText =
"INSERT INTO SUDENT (" +
"S_ID, S_NAME, S_ADDRESS, S_PHONE" +
") VALUES ('" +
S_IDComboBox.Text + "', '" +
S_NAMETextBox.Text + "', '" +
S_ADDRESSTextBox.Text + "', '" +
S_PHONETextBox.Text + "')";
sqlDataAdapter1.InsertCommand.ExecuteNonQuery();
It gave me this error
€œNulleferenceException was Unhandled€?and €œ Object refrence not set to an instance of an object€? so I add this line
sqlCommand1 = ("INSERT INTO STUDENT (S_ID,S_NAME,S_ADDRESS,S_PHONE) VALUES (@S_ID,@S_NAME,@S_ADDRESS,@S_PHONE)" ,sqlConnection1);
Then it gave me some stupid error. By the way it didn€™t make a new object of SqlCommand although I tried €¦.
So can u help me to solve my problem ? Thank you
Error In Sending Out-of-band Data To SQL Server.
May 17, 2008
First, yes I know that DB Library is depreciated. Unfortunately it isn't an option for us to make a huge change like that right now.
Now, on to the problem. We have a few different C applications that access SQL Server via db-lib. On SQL 6.5, and SQL2000 we had no issues to speak of. Since upgrading to SQL2005 (Enterprise Edition, 32 bit), we have had a horrible time with receiving an error that says "Error msg: Possible network error: Error in sending out-of-band data to SQL Server. General network error.". It appears to happen at somewhat random times during the applications run.
Search for information on "Error msg: Possible network error: Error in sending out-of-band data to SQL Server. General network error." has provided next to nothing, so I turn to you. Any ideas?
Thanks,
Matt
File From Oracle To Sql 7/2000
May 2, 2001I am trying to take a table from Oracle and put it in a file and then
BCP this file to SQL. No problem until I get to the text column coming from
the Oracle table. I am using the vertical bar (pipe delimited) row and column delimeter options. But when I get to the Notes field I only get one
character per field???? I don't know what else to try.
Any thoughts?
I am transferring from Oracle 8.0 to my pc using SQL 2000. However the server has SQL 7.0 where the actually DTS package will run.
Thanks in advance for any help.
Dianne
Connecting Oracle To SQL 2000?
Jan 28, 2005Hi, i need to build some way of connecting Oracle to SQL Server in order to pull data off Oracle and house it temporarily on SQL 2000 for searching.
Basically we've built an intranet using ASP and SQL 2000 and which also pulls data off Oracle, however our connection to Oracle is very slow so an idea to speed it up would be to have SQL store a temporary snapshot of this data and the ASP site query off the fast connection it has to SQL rather than use our slow connection to Oracle.
This temporary snapshot of Oracle data would be stored on SQL 2000 and updated on a scheduled basis.
Any ideas how to do this, or a better way to work this?
Thing is I tried installing the Official Oracle ODBC & Client software on our SQL 2000 server before and it just took out SQL 2000 so would really like to hear other options.
Thanks in advance,
:confused:
How To Connect Oracle With SQL 2000
Jan 20, 2007Good evening,
I would like to ask help from professionals, I have oracle database as old system and SQL server 2000 as new system ,these databses for accounting department so we would make oracle as publisher server and SQL as subscriber which we be sure the database in the two system is synochornize. but the main problem I can't make oracle as publisher because when I go to SQL server2000, replication, no option for non sql server.
so I would like to help asap.
thank in advance.
DTS Between SQL Server 2000 And Oracle 8.1.7
Feb 11, 2004Hi,
I used DTS Export Wizard to copy tables from SQL server 2000 to Oracle 8.1.7. After transfering completed successfully, I loged into oracle and tried to select data from the tables. I got 'table does not exist' error. But when I select table_name from oracle data dictionary, I saw tables exist in oracle. Then I opened SQL Query Analyzer, I can select data from the tables just transfered through linked oracle server.
Does anyone have same experience? Could someone please give me suggestion?
Thanks in advance!
Oracle .dmp To SQL Server 2000
Apr 7, 2004Hi guys,
I was given a task to get an Oracle .dmp file into SQL Server.
Is it even possible to do? Or do I have to script the Oracle DB and import the DB that way?
But then how would I get the data?
I need to get the Oracle structure and the Data over to SQL Server.
PLease help.
SQL 2000 Replicate To Oracle 10g R2
Feb 4, 2007Hi all,
I have some questions about replicate data from MS SQL 2000 to Oracle 10g R2:
1. Is it only SQL 2000 Enterprise Edition support replication?
2. Is it the Oracle DB must install on Intel-based Windows server?
Thanks!
Regards,
Edwin
Transact SQL :: Sending Auto Email With Queried Data (On INSERT And On Month Ends)
Oct 22, 2015I have to send updated Employee list from employee master table to a particular email ID on every last date of Month and when a new employee is added / deleted / edited. Also need to send this as an Excel fileÂ
I tried the following but "Invalid Object name dbo.tbl_EmployeeMaster" error coming while inserting a new employee.
USE [eXact]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[trg_Email]
[Code] ....
Replication From Oracle To Sql Server 2000
Mar 3, 2003Is it possible to replicate from Oracle to SQL Server.
Thanks,
Bianca
Migrating From Oracle 8i To SQL Server 2000
Jan 31, 2004Hi
I am trying to migrate my database in Oracle 8i to Sql Server 2000 but am unsure of how to carry out the migration. How do I do it and what do I have to consider. My OS is Windows 2003. Thanks in advance
SQL 2000 To Oracle 9i Migration Problems
Jul 20, 2005Hi all,I am using the Oracle Workbench for migrating my DB currently on SqlServer 2000 to Oracle 9i. During the migration the following happensSELECT @tBaseTable = tBaseTable, @tDBColumnName = tDBColumnNameFROM tblColumnMain WITH (NOLOCK) left join tblCustomField WITH(NOLOCK) on aColumnID = nColumnIDWHERE aColumnID = @nPropertyIDgets converted toSELECT tBaseTable, tDBColumnNameINTOSPROC_PROPDATA.tBaseTable, SPROC_PROPDATA.tDBColumnName, FROMsa.tblColumnMain, sa.tblCustomFieldWHERE (aColumnID = nColumnID) AND (aColumnID =SPROC_PROPDATA.nPropertyID_);and gives the warning that complex outer joins maynot be reliablyconvertedOn the other hand the following codeselect @keyid = a.keyID, @pubs=b.pubs fromssd1 a left outer join ssd2 b on a.l_name = b.l_namewhere b.l_name = @namemigrates perfectly to Oracle asSELECT a.keyID, b.pubsINTO SPROC_JOINTEST8.keyid, SPROC_JOINTEST8.pubsFROM ssdash.ssd1 a, ssdash.ssd2 bWHERE (a.l_name = b.l_name(+)) AND(b.l_name = SPROC_JOINTEST8.name);with the same warning ...Could anyone enlighten me as to what exactly is the difference betweenthese 2 above cases.Also the migration bench seems to be removing nolocks and such stuff allaround. Any workaround for this is also needed.ssDash--Posted via http://dbforums.com
View 1 Replies View RelatedExporting Sql Server 2000 Tables To Oracle 10.2G
Jan 10, 2008Dear All,
I am working on a project to migrate a .net desktop application to web based application using ASP.NET 2.0.
The present app has lots of tables with data in sql server 2000. The new app is to have Oracle 10.2 G as data store.
Although the data store is being changed most of the tables in the present database will remain same along with the data they hold.
My problem is:
1) how to transfer the tables to the new datastore 10.2 G in an automated way?
After all it's not possible to create each table afresh in Oracle and then insert records into each table one by one. If that is done it will take atleast few months if not years.
2) can I export the tables to a xml file and then import it from Oracle.How to do that?
It has become a nightmare for me.
Pls suggest the easiest way and which takes the minimum time.
A solution to the problem will be gratefully accepted.
Thanks.
Accessing Oracle Tables From Within SQL Server 2000
Mar 24, 2006We are running SQL Server 2000 SP3. We have linked servers in use thatwe use to access Oracle tables.Recently the claim has been made that you can access Oracle tables fromwithin SQL Server without using a Linked Server. I searched BooksOnline using keywords: linked, remote, and Oracle and did not findanything.A search of the newsgroup archives found only entries related to usingLinked Servers.Is there any such method as claimed? I do not think there is, but Ineed to find some support for my position or else learn something new.Thank you-- Mark D Powell --
View 4 Replies View RelatedScalar Query In SQL Server 2000 Like In Oracle
Mar 28, 2008Hi Gurus,I have table (CallByCall) with following Data.Input :CallID Event DNIS UserID Time SeqID MobNo-----------------------------------------------------------------------------1 | 43 | 100 | |09:00:05 | 1 |98332107701 | 40 | | |09:01:05 | 2|1 | 41 | | |09:02:05 | 3|1 | 42 | | 25 |09:03:05 | 4|2 | 43 | 200| |09:10:05 | 1 |98339755362 | 40 | | |09:11:05 | 2|2 | 41 | | |09:12:05 | 3|2 | 42 | | 26 |09:13:05 | 4|3 | 43 | 300| |09:15:05 | 1 |98139785363 | 40 | | |09:15:55 | 2|3 | 41 | | |09:16:05 | 3|3 | 42 | | 28 |09:18:05 | 4|4 | 43 | 100| |09:45:05 | 1 |92239788964 | 40 | | |09:46:05 | 2|4 | 41 | | |09:47:05 | 3|4 | 42 | | 26 |09:48:05 | 4|Output:CallID DNIS UserID MinTime MaxTime MobNo--------------------------------------------------------------------------1 | 100 | 25 |09:00:05 |09:03:05 |98332107702 | 200 | 26 |09:10:05 |09:13:05 |98339755363 | 300 | 28 |09:15:05 |09:18:05 |98139785364 | 100 | 26 |09:45:05 |09:48:05 |9223978896In short I am getting DNIS and MobNo for Event 43 andUserId for Event 42.How can I achieve the above result?Is it possible with scalar query?Could any one help me for the same?Thanking in AdvanceSanjeev
View 1 Replies View RelatedAutomating The Importation Of An Oracle Table Into Sql Server 2000
Aug 25, 2004Hi guys,
I figure this should not be a complex one. I know how to manually pull in data from Oracle 9i into SQL Server 2000 using DTS. However this is my issue.....
I simply want to automate the pulling in of data from 1 table in my ORACLE 9i database into another table in my Sql Server 200. I was hoping I could simple write a stored procedure that would sort of utilize a dblink like in ORACLE and then schedule that procedure. Is this feasible in Sql Server, and how would one go about setting this automated import up????
Thanks in Advance all............
'Wale
How To Import An Oracle 8.1.7 Dump File Into SQL Server 2000 ?
Mar 2, 2005Hi,
I do not know if it can be done:
how to import an Oracle dump file into SQL server ?
That dump file contains the content of a table, excported from Oracle.
Is there a way or another to import it to SQLServer 2000 ?
Thanks
How To Do Pair-wise Comparision Like Oracle In MS Sql Server 2000?
Apr 18, 2008
How can we do pair wise comaprission using Sub query as generally can be done in Oracle?
Thanx