General discussion

Locked

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.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by am_sameni In reply to vb scripting

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

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.

Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums