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
- 2607 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
What are acid properties of transaction?
What is SQL Azure Firewall?
Difference between uniqe index and uniqe constraint?
What is nolock?
What is a transactions?
How can sql injection be stopped? : sql server security
What is the purpose of grouping data in a report?
Can I run multiple instances of sql server 2000 at the same time on one computer?
What is difference between views and stored procedures?
What happens if null values are involved in boolean operations?
What do we need queues in sql service broker?
Is it possible for a stored procedure to call itself or recursive stored procedure?
What command would you use to create an index?
How many partitions a clustered index has by default in sql server 2012?
What do you mean by authentication modes in sql server?
