We help IT Professionals succeed at work.

Oracle and SQL Server

I am accessing an SQL Express Server for my database to my VB application.  Can I take all my data and drop it into an Oracle database and then use VB to connect to the Oracle db?
Comment
Watch Question

Ted BouskillSenior Software Developer
CERTIFIED EXPERT
Top Expert 2009
Commented:
Not exactly.  Oracle uses some different datatypes and there are subtle differences in their T-SQL with some of the functions.  However, once you've moved the schema and data VB can use Oracle as easily as it would use SQL Express.
Commented:
You certainly can.  I'm not saying it will be a transparent migration, but VB can connect to Oracle.
Commented:
Yes, You can


1) import data into oracle

2) change your connection settings in vb.net, for details check the following links

http://www.oracle.com/technology/pub/articles/cook_dotnet.html

http://www.startvbdotnet.com/ado/oracle.aspx

http://www.oracle.com/technology/pub/articles/price_dbtrans_dotnet.html

Commented:
Are you asking about making a VB program handle to transfer on a regular basis,
or a single migration, switching you VB app to use Oracle instead of SQL Server?

Explore More ContentExplore courses, solutions, and other research materials related to this topic.