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
What is cursors? And what are the different types of cursor?
How to rebuild the master database?
If a stored procedure is taking a table data type, how it looks?
Write an SQL query to obtain the 2nd highest salary.
What is sql server used for?
What is sql server locking?
Explain the difference between function and stored procedure?
What is the difference between osql and query analyzer?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
How to apply filtering criteria at group level with the having clause in ms sql server?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What are approximate numeric data types in ms sql server?
How you can get a list of all the table constraints in a database?
How much does sql server 2016 cost?
How to modify existing triggers using "alter trigger"?