Unnormalized to Normalized DB

Question

Post reply

Unnormalized to Normalized DB

varunfilim

Mr or Mrs. 500

Points: 594
More actions
August 2, 2010 at 10:40 pm

#238426

Hi Friends,
Is it possible to bring unnormalized and totally unstructured data to the Normalized DB Structure?How is it possible?any tool?.We have to bring each transactions to the Data base.
Regards
Varun R

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

I am not aware of any such tools.The requirement varies case by case

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

varunfilim Mr or Mrs. 500 Points: 594 More actions · Answer 2

Hi adiga,

I want to know whether it is possible or not?.I am new to this current DB and as I found it just not even complete first level normalization and DB logic(no flow) is not implemented.Most of the SP's using Temp tables and cursors,which is one reason for slowing down the application.The Current DB structure is worst...for 8 lakh data it is taking 15 min for retrieval.It is not because of table maintenance or indexes.Duplicate data is as much there...Whether it is possible to transfer the data to new Normalized DB structure?

Regards

Varun R

Adiga One Orange Chip Points: 27284 More actions · Answer 3

You can transfer the existing data to a new table (after pruning the duplicate rows) using SSIS

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

varunfilim Mr or Mrs. 500 Points: 594 More actions · Answer 4

Hi adiga,

Thanks 4 the replay.All the master tables are different and new id is generated.how is it possible to transfer all the transactions corresponding with these id's and the existing one's.(using SSIS).Any good book for SSIS?

Regards

Varun R

rakesh ghodasara SSC Enthusiast Points: 109 More actions · Answer 5

The best way to do it would be via a SQL Script. Though it would be tedious task. I dont see how you can use SSIS to do it very easily.