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 the default order of an order by clause?
What is the bookmark lookup and rid lookup?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
Why does sql studio use a single registered database repository? : sql server management studio
How do I determine how many instances of sql server are installed on a computer?
How you can change the database name in SQL SERVER?
How to list all triggers in the database with sys.triggers in ms sql server?
Name some of the open source software that you can use in alternative to SSR?
What is temporal table?
What is difference between temp table and cte?
How do you debug a procedure in sql server?
Can you move the resources after pausing the node? : sql server database administration
What is primary key and example?
What are the authentication modes in sql server? How can it be changed?
How to delete all rows with truncate table statement in ms sql server?