Solved

Converting Data Elements From A Legacy System

Posted on 1998-08-04
10
148 Views
Last Modified: 2010-03-19
 I will be using data elements from a legacy system to populate the database created in SQL Server.  These data elements use an older style of naming like auto_rfi_stow_fg.  Is there a way to create the tables in
SQL Server so that intelligible  names may be used yet enable the elements from the legacy system to be dumped into SQL Server.  I don't know enough about the process of
dumping/importing to know what is involved?  I guessing that somewhere behind the scenes there is a way to set the older name to the newer name.

Thanks!
0
Comment
Question by:John500
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
  • 2
  • +1
10 Comments
 
LVL 2

Expert Comment

by:odessa
ID: 1089393
When you finish with dumping you can change the name's of tables inside the SQL Server
e.g. in Enterprise Manager you can do rename...
0
 

Author Comment

by:John500
ID: 1089394
So, in other words the new tables created in SQL must have names identical to the ones in the legacy system?  Also, does this mean that each new table has to have the exact elements as the old for the dump to be successful?  The older database is not relational (which I desire) so I'm assuming I would create the relational database once I have all the data?

Or, is it possible to create the relational database with the legacy table/element names and then do the dump?  This approach would save the time of making two different databases.


0
 

Author Comment

by:John500
ID: 1089395
Requesting quicker response time!!  Thank you!
0
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 
LVL 2

Expert Comment

by:odessa
ID: 1089396
1. When you dumping data you must know with what Instrument you'll do data dumping I use Delphi's Data Migration Wizard
2. With DMW I can change names of tables & fields before dumping.
Thats all
0
 

Author Comment

by:John500
ID: 1089397
What if I have all of the data elements in a Word document.  How could I dump the data?  Would Delphi's Data Migration Wizard be able to do the trick?

Are there any demo products out there like DMW that can be download and tested before purchasing the complete product...
0
 

Author Comment

by:John500
ID: 1089398
Also, can you tell me what option allows manual data entry into tables?
0
 
LVL 5

Expert Comment

by:mayhew
ID: 1089399
John,

If I'm understanding you right...

If all your data is in a Word document, you could Save As an ascii flat-file and then bcp the data into SQL Server.

Bcp is a command line utility in the mssql\binn directory that was made for just this kind of application.

Take a look at the description in the help files (or Books Online) and let us know if this is what you need.

Don
0
 
LVL 9

Expert Comment

by:cymbolic
ID: 1089400
Here's another common route to getting data into SQL Server.  Import it into Access first.  Access has a number of drivers and readers that will help you get your data into a database, and it has a friendly front end to manually make the kind of changes you want more easily than using SQL server.  Then, when your data is as you like it, you can "upsize" it to SQL server uisng MS Upsizing tools, or, you can link your Access database to SQL Server tables, and use Access Queries to copy the data over from your local database to your SQL Server tables.
0
 

Author Comment

by:John500
ID: 1089401
Sorry to take so long responding to this question.

I have since solved the problem and in part due to mayhew's answer.  Thanks for the responding cymbolic, but it will be fair to grade mayhew's answer.

This is a great service you guys/gals provide.

Mayhew, please make the grading screen available to me.

John
0
 
LVL 5

Accepted Solution

by:
mayhew earned 50 total points
ID: 1089402
John,

I'm glad you got it figured out.  Would you mind sharing what you found, if you have the time?

Thanks!

Don
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question