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
- 2925 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
Explain transaction server explicit transaction?
Differentiate between a local and a global temporary table?
What is the default schema of your login session in ms sql server?
Explain trigger classes i.e. Instead of and after trigger?
What will happen if a column containing char type data is changed to the nchar data type?
How you can get the list of largest tables in a database?
What is bcnf normalization form?
what are user defined datatypes? : Sql server database administration
What is the query and subquery?
How do I connect to sql server database?
What is data source document?
What is merge replication?
what is database replicaion? : Sql server database administration
what is the difference between delete table and truncate table commands? : Sql server database administration
Explain the use of keyword with encryption. Create a store procedure with encryption?
