i use few third party softwares. they r all having their
own databases .
but the data is repeated in all these databases - say a
person is in all the three databases, but his name is
stoared in diff format in all databases
i want to create a centralised database ,and i dont want to
re-enter the records .
using the exisating records how can i build a centralised
database?
Answer Posted / himanshu gupta
First try to convert all names into same format(normalize) and then will insert all details to centralized database excluding duplicate record.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Where do you find the default Index fill factor and how to change it?
What is use of except clause?
What is the difference between DataRow.Delete() and DataRow.Remove()?
Explain primary key in sql server?
Explain about unique identifier data type in sql server?
Where are stored procedures in sql server?
What is the security model used in sql server 2005?
what is hash nonclustered index
What are magic tables in sql server?
What is store procedure? How do they work? When do you use?
How to rebuild the master database?
What is a transactions?
What are the different types of collation sensitivity?
What are transactions and its controls?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?