Databases :: Migration From SQL Server To Oracle?
Feb 7, 2011I need to transfer SQL Server databse to Oracle database.
View 2 Replies
Similar Messages:
Databases :: Migration From Oracle To Sql Server?
Feb 1, 2010 I've developed a web app in Visual Studio 2008 using ASP.NET which connects to an Oracle database and a separate SQL Server 2005 database in the same application.
I want to convert this application to use SQL Server only. I have copied the Oracle tables that I need to SQL Server and am in the process of converting the SQL queries from Oracle format to SQL Server format.
I have also modified all the Connection Strings in web.config to point to the SQL Server database now and not the Oracle one.
However I have come across a problem. The TableAdapters are configured to use the OracleClient in the declarations code behind the scenes, i.e. it is "hard coded". But this causes problems of course while modifying/saving queries, because I don't want any trace of Oracle in my new web app.
The only thing I can think of is to delete all my TableAdapters and re-create them all.
Databases :: Sync Oracle And SQL Server 2008?
Jun 24, 2010Does anyone know of a way that I could sync a few contact info views from an OracleDB to SQL Server without spending thousands on syncing software?
View 1 RepliesDatabases :: How To Check Space On Oracle Database Server
Jan 27, 2010I have to automate one database process in .Net web applicaiton which uses Oracle 11g Database as Backend.
I need to know two things:
(1) How to check space on Oracle database server? I need space on server and not in the Database itself. My process creates few tables so I want to make sure that we have sufficient space before the process starts.
(2) Also I need to create script to backup Indexes and Triggers on the table so that I can recreate them after data transfer process is completed. Any idea how to create script form c# code?
Databases :: UI Tool For Oracle Similar To MS SQL Server Profiler?
Jun 29, 2010I would like to monitor all the queries running under Oracle which are being fired. Looking for some good UI tool for Oracle similar to Microsoft SQL Server Profiler.
View 1 RepliesDatabases :: How To Transfer Data From Oracle 10g To Sql Server 2008
Jul 27, 2010I want to know the best way to transfer data from a view in Oracle database 10g to Sql Server 2008.
View 1 RepliesDatabases :: Server Explorer - Unable To Connect To Oracle
Jan 31, 2011Using VS 2008 and oracle 10g.
I have installed oracle odp.net (11.1.0.7.20). This client installation includes all VS developer tools.
All my application seems to be working ok. I have never attempted to use VS Server Explorer.
For ReportViewer I was trying to create a dataset and in the server explorer I was trying to create a new dataconnection for oracle. As soon as I click new connection I get the following error.
An unexpected error occured in Oracle Data Net provider for .NET. contact the provider vendor to resolve this problem.
Also I am unable to add a server to the server explorer. When I enter the IP address of
oracle DB Server, it gives the following error.
An error occured while connecting to 999.99.99.999
Databases :: Oracle Reside In Linux Server Connection From 2010?
Nov 25, 2010I am starting a new project where I have to use oracle and asp.net. Oracle 11 enterprise edition. Problem is oracle database reside in linux server and application server is in windows. My question is1. Is there any problem connecting oracle from asp.net?
View 1 RepliesDatabases :: How To Access Oracle Db From Diffrent Server Without Installing Any Client
Mar 8, 2011I want to access oracle database which is on diffrent server my application is giving error in connection string that is object ref not set
View 1 RepliesDatabases :: Windows 2008 R2 Server And Visual Studio 2010 To Get Oracle Quereis To Work?
Feb 23, 2011Is there anything special to do with Windows 2008 R2 Server and Visual Studio 2010 to get Oracle quereis to work? I have the same DB Connnection.string I have used before and it works. I am at a loss here.
View 6 RepliesDatabases :: SQL Server Database Dependency In Oracle Database?
Feb 27, 2010I'm working with Oracle database and I want to improve performance of my website.I read about caching. So is it possible to implement caching (SQL Server Database Dependency) with oracle?
View 2 RepliesDatabases :: Oracle Query Convert To Sql Server Query
Sep 3, 2010I am a biggner in SQL DB . but i started a complicated and painfull work in SQL SERVER 2008. the problem convert Oracle hierarchical query to SQL query. the query
SELECT DISTINCT
LEVEL LVL,
SCH.NSCHEDULE_SL,
SCH.NSCHEDULE_SL_FM,
SCH.CSHED_CNAME
FROM FA_SCHEDULES SCH
WHERE LEVEL = 1
AND NSCHEDULE_SL_FM IS NULL
AND NBRANCH_SL = 2
CONNECT BY PRIOR SCH.NSCHEDULE_SL_FM = SCH.NSCHEDULE_SL
AND NBRANCH_SL = 2
Databases :: The OLE DB Provider "OraOLEDB.Oracle" For Linked Server "ORA_sys2" Doesn't Contain The Table
Mar 2, 2010I don't know why I did have the following problem with this. USE [myschema]; select acc,acc_name from ORA_sys2..oraschema.acc_table; Msg 7314, Level 16, State 1, Line 3 The OLE DB provider "OraOLEDB.Oracle" for linked server "ORA_sys2" does not contain the table ""oraschema"."acc_table"". The table either does not exist or the current user does not have permissions on that table. But within the SP, I did make use of the following way without any problem! from ORA_sys2..oraschema.tab2
View 2 RepliesDatabases :: How To Use Oracle 10g Using Toad
Jan 27, 2010how we can use oracle 10g in asp.net 3.5 using toad
View 1 RepliesDatabases :: How To Run The Oracle 32 And 64 Bit Clients
Feb 22, 2011As the title says I have a Win 7 64 bit dev machine, Win 2K3 32 bit production box and I run against Oracle 10g which Oracle clients do I need to run? Do I need to run the Oracle 32 and 64 bit clients? And if so what versions?
View 1 RepliesDatabases :: Connect To Oracle Without DSN?
Oct 4, 2010I need to find a way to connect to the remote Oracle server without a DSN. There are some practical problem for accessing the server using a DSN. I need a way to connect to Oracle server like I connect to SQL Server etc. For example, in SQL server, I can connect directly with server using Servername (IP adress) + Username + Password + DB Name. Any way to connect to the Oracle server like in SQL Server we do ??
View 6 RepliesDatabases :: SqlDataSource On Oracle 64 Bit?
Aug 2, 2010I have an Asp.net web application targeting .Net2.0 and my databse is oracle, I used SqlDataSource Control to communicate with oracle database its working fine on my development server, but on my production Oracle is 64 bit so im getting an error like
"<asp:ControlParameter doesnot have a property DbType="Int32"> "
i tried with Int64 also but still im getting the same error
following is the markup of sqldatasource i used
<
asp:SqlDataSource
ID="sdsEmployees"
runat="server"
ConnectionString="User Id=user;pwd=user1;server=prod" ProviderName="System.Data.OracleClient"
SelectCommand="GetEmployeeInfo" SelectCommandType="StoredProcedure"
OnSelecting="sdsEmployees_OnSelecting">
<SelectParameters> <asp:ControlParameter
ControlID="txtNumber"
DbType="Int32"
/> </SelectParameters> </asp:SqlDataSource>
Databases :: Use Link To Oracle In 4.0?
Jan 3, 2011tried to use linq to oracle 10g express but it throws an error as I can make no errors because I throw
View 1 RepliesDatabases :: Getting Data From Oracle Sp?
Mar 15, 2011have a sp in oracle which has 3 input parameters and 3 output parameters( 1 ref cursor, i number, 1 varchar2)
Command.CommandText = sp name;
Command.CommandType =
CommandType.StoredProcedure;
i am doing cmd.ExecuteNonQuery();I am able to get the number and varchar2 values from output parameters. But i am unable to get output from Ref Cursor. (How can i get this...)If i use dataadaptor then i am getting the datatable in the dataset(but i am not getting the other two parameters(where will get the other two??)...
Databases :: Connect To Oracle DB?
Jul 8, 2010Is required to install Oracle client software to connect Oracle DB?
As following code will generate exception, prompt:"System.Data.OracleClient requires Oracle client software version 8.1.7 or greater."
using System.Data.OracleClient;
string dataSource ="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=addr)(PORT=pt))(CONNECT_DATA=(SERVICE_NAME=svc)))";
string connectionString=string.Format("Data Source={0};User Id={1};Password={2};",dataSource,"id","pwd");
using (OracleConnection connection=new OracleConnection(connectionString))
{
connection.Open();
}
Databases :: How Make SQL Query Run Under ORACLE
Jan 8, 2010i have a SQL Query. It works fine in Sql server. let me know how to make it work in Oracle.
You can run below code in Sql server and check. It will work fine. But in Oracle,( I am using TOAD for Oracle )it is giving some errors.
Code]....
Databases :: How To Use Oracle Membership Provider For .Net
Apr 13, 2010to Find website or write to me How to use Oracle Membership provider for ASP.Net and what changes should i do to Web.config and machine.config?
View 1 RepliesDatabases :: Connecting To Oracle In A Web Application?
Feb 21, 2011I am developing a web application with back end as Oracle. I call the procedures from web application when ever some update, create or delete for the records needs to be performed. How to maintain the connection in these scenarios.
Can I open the connection and maintain it through out the application till user logs out?
Databases :: InsertUpdateData Error Using C# .net With Oracle Db
Jun 8, 2010here's my error... Compiler Error Message: CS1502: The best overloaded method match for '_Default.InsertUpdateData(System.Data.SqlClient.SqlCommand)' has some invalid arguments
here's my codebehind:
[Code].....
Databases :: Roles In .net / Oracle - What Is Best Practice For This
Apr 20, 2010I'm using oracle for my asp.net website. In website I have 3 different roles. Now do I need to create as many diff users in oracle as roles?
Someone in team insisted on having as many users in oracle. But then unnecessarily i have to maintain multiple connection strings in app.
like, I have manager/ team leader/ user roles.
Now the team member insists on having 3 users in oracle. then in DAL i've to check role and use corresponding connection string.
This is not very big app, but in all 12-15 aspx pages and some 10 table in oracle to be used only on intranet.
what is best practice for this?