If table is not exist in database then use this solution
SELECT * INTO TargetDB.dbo.TableName
FROM [SourceDb].[dbo].[TableName]
By using this query you can do.
Here you have to replace TargetDb and SourceDb and TableName according to your database name.
Else table is exists in database then use this one
INSERT INTO [TargetDB].[dbo].[Department]
([Title],[Credits])
SELECT
[Title],[Credits]
FROM [SourceDb].[dbo].[Department]
Let me know if you still face any issue.