imagrate Data from File into rational Database
for half a year somebody created a Table and saved it in the MS-SQL Database.
the table was not designed in the 3ed Normal Form of a rational DataBase.
so the table increased in the high and the width.
NOW i want to create a real rational Database and imagrate the Data into the new Tables.
the proccess is hard and i have no idea where to start.
i look for some sites to read about.
PDF files.
examples. // hoply understandable :)
or alt least, give me some search keywords to google what i need :)
thx in advance
[575 byte] By [
sssakoa] at [2007-9-29 8:36:18]
First of all I think you mean 'relational' not 'rational'. Secondly, I'm not sure what you problem is exactly. You need to pull the data from the existing table do any conversions that are neccesary and insert it into the new table. There are dozens of way of going about this, do you know anything about SQL?
yes i know a lot about SQL :)
but what i need is these "dozens of ways"
i want to read about these ways to find out which one is the best for my situation :)
btw, i have an idea, but this will cost me a lot of time and its riskful, so i thought maybe somebody had to do this proccess before and can name me the way he used or the ideas, and i will search and check out if this is correct for me :)
thx
