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?
al4629740Asked:
Who is Participating?
 
sonicefuConnect With a Mentor 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
0
 
Ted BouskillConnect With a Mentor Senior Software DeveloperCommented:
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.
0
 
dqmqConnect With a Mentor Commented:
You certainly can.  I'm not saying it will be a transparent migration, but VB can connect to Oracle.
0
 
dentabCommented:
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?
0
All Courses

From novice to tech pro — start learning today.