Please post your valuable comment.
-
Dear members, This is not a specific tec doubts. This all about your experience and your way of dealing the issue. Brief idea: We have an application which uses Sybase database as Backend and Dotnet( C# Lan) as Front-End. This application uses IAnywhere.Data.AsaClient.dll (managed provider for Sybase db). This application is a small supporting module for our ERP which is developed using Power Builder. Real requirement. Now we are deciding to make this application as a pluggable for our ERP and also can plugged into other ERPS or applications, which have raw data needed to run our pluggable application. Here the raw data ( data required to run this pluggable application ) may be in different database ( Db2,Sql Server,Oracle,Sybase etc). But now we don't have any interface or mechanism to pull the data from other Databases into my data base with required form (field name and data types). What will be the better solution to make my product as pluggable for other application. ? What is the real industry standard to tackle this sort of scenarios. ? If you need to face this issue, what you will prefer to get out of this ? How will i make a Data Pipe kind of mechanism to get required data in required form from other databases ? Please do comment for this query. Your post will be most appreciable. Sreejith Nair [ My Articles ]
-
Dear members, This is not a specific tec doubts. This all about your experience and your way of dealing the issue. Brief idea: We have an application which uses Sybase database as Backend and Dotnet( C# Lan) as Front-End. This application uses IAnywhere.Data.AsaClient.dll (managed provider for Sybase db). This application is a small supporting module for our ERP which is developed using Power Builder. Real requirement. Now we are deciding to make this application as a pluggable for our ERP and also can plugged into other ERPS or applications, which have raw data needed to run our pluggable application. Here the raw data ( data required to run this pluggable application ) may be in different database ( Db2,Sql Server,Oracle,Sybase etc). But now we don't have any interface or mechanism to pull the data from other Databases into my data base with required form (field name and data types). What will be the better solution to make my product as pluggable for other application. ? What is the real industry standard to tackle this sort of scenarios. ? If you need to face this issue, what you will prefer to get out of this ? How will i make a Data Pipe kind of mechanism to get required data in required form from other databases ? Please do comment for this query. Your post will be most appreciable. Sreejith Nair [ My Articles ]
for data migration from one DB to another, there is a DTS package which you can automate via SQL DMO. another solution is make an intermediate flat file to transfer the data between different databases. you must write one tool to export the data from different Databases in to a flat file(xml is a better choice), and after that you can parse that File and you can update your database. Ninety-eight percent of the thrill comes from knowing that the thing you designed works, and works almost the way you expected it would. If that happens, part of you is in that machine.