hai,
iam working in web development ,i have an problem in transfer ing the data from erp module to web page ,these two are inter related , how transfer the data from oracle to sql, give an solution
Depending on the type of data that you're trying to migrate your task can range from fairly easy to a bit complicated. I would suggest that you understand the differences between MSSQL and ORACLE datatypes for starters.
If you don't understand this concept, you're playing a game of hit or miss for a possible solution.
Take a look at Table 2-2 the following link:
http://download-east.oracle.com/docs...h2.htm#1026430
It provides an excellent overview for comparisons between the 2 platforms. You should then understand that while there are similarities in some areas, there are major differences in others. So the complexity of your project is directly dependent on what types of data your attempting to migrate.
Another good link that covers even more differences in the database architecture
is here:
http://www.microsoft.com/technet/pro....mspx?mfr=true
This information should provide you with what is necessary to accomplish your task (think it through)
Then if you still need further assistance, I am certain that you're going to have to post more information than what you've given here for anyone to help you.
Good Luck!