Web Development

General discussion


vb scripting

By swapnil_19 ·
we are having existing project in vb having backend oracle, now we are going to rebuilt the project in .net and backend as ms sql server with some changes in the database(tables), but we want to migrate the existing data from oracle to sql server.
Is it possible through vbscript or java script.
tell me in detail.
thank you.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by am_sameni In reply to vb scripting

In vbscript or javascript we dont have any database convertion.
You must sending your data to XML and then convert this to ms sql.

Collapse -

by Tony Hopkinson In reply to vb scripting

Use the DTS tool in MS SQL to transfer the data.
Whether you do the restructure in oracle and then move it, move it then restructure is up to you as long as there aren't any data type mismatches between the two DBs. DTS will tell you if there are.
You can move the entire structure for common features. Depends on how much Oracle specific functionality you are using.

Related Discussions

Related Forums