INSERT [NewDB].[your_schema].[Countries](Id,Name) SELECT CountryId, CountryName FROM [OldDB].[your_schema].[Country]