Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-07 : 08:54:24
|
| Ajay Kumar Gautam writes "Good Morning SirHappy New Year,I am Ajay Kumar Gautam from Mumbai(India)I want to work on one project that project is related to database.Object: - To develop application to convert, transfer and migrate data from the oracle / sql databases to the Linux operating system based database.In this project i will make one application in these database (oracle/ sql) migrating tables by using stored procedure or etc work same application should work in the Linux operating system based database with out too many changes then we can say that our project is working fine In this project “The general conception is migrating tables from one database to other (matching the datatypes), but another critical aspect is stored procedures. I should also work on that. Secondly, the main thrust is on application migration. Any application that was working with ORACLE for example, must work with Linux operating system based database now without too many changes but for the data connection string etc. That’s the main thing in this project.”I have knowledge of SQL so could you guide me or give me the points step wise step so that I can able to make this application tools.Wait for replyRegardsAjay Kumar Gautam" |
|
|
amachanic
SQL Server MVP
169 Posts |
Posted - 2005-01-07 : 13:26:05
|
| Keep waiting! Reply will come some day! |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-01-08 : 07:38:16
|
Are you writing the whole application for him then, Adam?  Kristen |
|
|
|
amachanic
SQL Server MVP
169 Posts |
Posted - 2005-01-08 : 10:57:53
|
| I figured that I would put an infinite number of monkeys in an infinitely large room with an infinite number of computers loaded up with VS.NET 2003 and eventually they'll come up with the app! |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-08 : 11:08:25
|
| Someone's already doing it:http://www.newtechusa.com/PPI/main.asp |
|
|
|
amachanic
SQL Server MVP
169 Posts |
Posted - 2005-01-08 : 12:09:25
|
| LOL!! Thanks for the link, Rob! "Our chimps and bonobos handle complex maintenance tasks and are experts at debugging techniques. For this reason chimps usually have a higher bill rate." |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2005-01-08 : 13:57:14
|
| These types of frameworks already exist. They are called persistance frameworks or Object Relational Mappers |
|
|
|
amachanic
SQL Server MVP
169 Posts |
Posted - 2005-01-08 : 14:27:41
|
| Actually, I don't think he's talking about an OR mapper; sounds to me like a data transformation / integration product. There are lots of those on the market already too, including DTS :) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-01-10 : 01:47:05
|
| But sadly I don't think DTS is going to rewrite Oracle SProcs into a "Linux operating system based database" - which sounds a lot like MySQL to me - lolKristen |
|
|
|
amachanic
SQL Server MVP
169 Posts |
Posted - 2005-01-10 : 11:38:48
|
| This product claims to:http://www.swissql.com/products/datamigration/index.html |
|
|
|
|
|
|
Query