Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 2959 Views
- Fidelity, I also Faced
- E-Mail Answers
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
Can sql server be linked with other servers like oracle?
What is an entity-relationship diagram (erd)?
Explain sub-query?
What is sql injection? How to protect against sql injection attack?
What are the pre-defined functions in the sql server?
How to define the name and server for a new dsn?
What is indexing explain it with an example?
What is always encrypted?
What is the difference between for trigger and after trigger?
What is the current pricing model of SQL Azure?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
Why use sub query in sql server and list out types of sub queries?
What are filegroups in sql server?
What is the query and subquery?
How can i Relate Tables in SSIS
