Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

You have more columns in target than source, and they're also NOT NULL columns. Where are you getting the other values from? (This will affect the query you need to use).
–
Stuart MooreFeb 4 '13 at 11:42

I'll let you sort out the insert and select columns, since mapping between database columns is not not trivial and you didn't provider enough information. I also don't understand what you mean by "I want all the rows from DB1 that have a catParent that is the same as I Id from DB2.", so you can fill in that condition too.

If you need to move ID too (which is IDENTITY column), remember to execute before INSERT statement SET IDENTITY_INSERT Categories ON and after you finish SET IDENTITY_INSERT Categories OFF.