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?
Who is Participating?
sonicefuConnect With a Mentor Commented:
Yes, You can

1) import data into oracle

2) change your connection settings in, for details check the following links
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.
dqmqConnect With a Mentor Commented:
You certainly can.  I'm not saying it will be a transparent migration, but VB can connect to Oracle.
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?
All Courses

From novice to tech pro — start learning today.