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: 2834
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: 64103
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: Sat Dec 03 22:16:06 CST 2016

Total time taken to generate the page: 0.06291 seconds