473,383 Members | 1,868 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

Moving from proprietary database to a SQL database help?

10
Hey all,
I am a young new programmer and one of my first assignments is to move our company's proprietary database to a SQL database, and then to a .net envoriment. The question I have is what would be the best way for me to do so. and if any one knows where I can find more information on this task, and where I can learn more about what the .net frame work is and its importance.
thank you in advance!
Jun 7 '07 #1
4 3138
pbmods
5,821 Expert 4TB
MySQL's LOAD DATA INFILE command is pretty versatile. As long as you can output the data in your proprietary database as a CSV (Comma-Separated Values) file, you should be good to go.

In terms of the database's structure... eww. That's gonna take some time. Well, that's why they're paying you the big bucks!
Jun 7 '07 #2
nineoo
10
MySQL's LOAD DATA INFILE command is pretty versatile. As long as you can output the data in your proprietary database as a CSV (Comma-Separated Values) file, you should be good to go.

In terms of the database's structure... eww. That's gonna take some time. Well, that's why they're paying you the big bucks!


Hey thanks for the timely advice!!
Jun 8 '07 #3
nineoo
10
MySQL's LOAD DATA INFILE command is pretty versatile. As long as you can output the data in your proprietary database as a CSV (Comma-Separated Values) file, you should be good to go.

In terms of the database's structure... eww. That's gonna take some time. Well, that's why they're paying you the big bucks!
Hello again,
Thanks for the advice earlier is has been very helpful thus far. I have written a routine that exports all of the data in our proprietary data base to a CSV file. So should my next step be "create the Database structure" with in the SQL Database, so that I can then use the "LOAD DATA INFILE command"?
Jun 25 '07 #4
pbmods
5,821 Expert 4TB
Heya, nineoo.

So should my next step be "create the Database structure" with in the SQL Database, so that I can then use the "LOAD DATA INFILE command"?
You got it.

I have written a routine that exports all of the data in our proprietary data base to a CSV file.
See if that works; you might have to create a separate file for each table and import them individually. But then, you might not.

Good luck, and post back if you need anything!
Jun 25 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

39
by: Kaarel | last post by:
I don't feel very confident when it comes to software licenses. But there are some cases I would like to make myself clear. What I am particulary interested in is when does GPL license become...
22
by: Matt | last post by:
Some people identify Microsoft C# is Proprietary programming language. What is Proprietary programming language then? How does it differ from other languages such as C++, or Java?? Please...
3
by: Iavor Raytchev | last post by:
Hello, We a situation with a central database that contains the data that needs to be presented at N off-line terminals (N can be 5 000 can be 15 000). Each terminal presents unique data. The...
7
by: =?Utf-8?B?TW9iaWxlTWFu?= | last post by:
Hello everyone: I am looking for everyone's thoughts on moving large amounts (actually, not very large, but large enough that I'm throwing exceptions using the default configurations). We're...
8
by: Chris Asaipillai | last post by:
Hi there I have some questions for those experienced Visual Basic 6 programmers out there who have made the transition from VB6 to Vb.net. How long did it take you to learn at least the basic...
0
by: linkswanted | last post by:
We are your trusted source. World Moving & Storage is bonded and licensed by the U.S. Department of Transportation and is one of the largest residential moving and corporate relocation company in...
0
by: linkswanted | last post by:
We are your trusted source. World Moving & Storage is bonded and licensed by the U.S. Department of Transportation and is one of the largest residential moving and corporate relocation company in...
0
by: SuzK | last post by:
I am trying to calculate in VBA in Access 2002 a moving average and update a table with the calculations. Fields in my WeeklyData table are Week Ending (date) ItemNbr (double) Sales Dollars...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.