Home » SQL & PL/SQL » SQL & PL/SQL » merging 2 databases with all constraints
merging 2 databases with all constraints [message #412625] Fri, 10 July 2009 03:22 Go to next message
sbaiju
Messages: 7
Registered: July 2009
Location: BOTSWANA
Junior Member

Merge two database with same field names with all contraints.i want to copy the data from new database to olddatabase.pla suggest querry for this
i write the query like this iam getting 10 records extra
select * from target..dbo.acs where target..dbo.acs.id=source..dbo.acs.id not in(select * from source..dbo.acs)
Re: merging 2 databases with all constraints [message #412626 is a reply to message #412625] Fri, 10 July 2009 03:23 Go to previous messageGo to next message
pablolee
Messages: 2844
Registered: May 2007
Location: Scotland
Senior Member
Are you working on SQL Server by any chance?
Re: merging 2 databases with all constraints [message #412628 is a reply to message #412626] Fri, 10 July 2009 03:39 Go to previous messageGo to next message
sbaiju
Messages: 7
Registered: July 2009
Location: BOTSWANA
Junior Member

yes iam using sql server
Re: merging 2 databases with all constraints [message #412631 is a reply to message #412628] Fri, 10 July 2009 03:44 Go to previous message
Michel Cadot
Messages: 64273
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And this an Oracle forum.

Regards
Michel
Previous Topic: Need Opinion on the Better Approach
Next Topic: How to identify Unicode Characters
Goto Forum:
  


Current Time: Thu Jan 19 02:49:37 CST 2017

Total time taken to generate the page: 0.09673 seconds