In the code below, I used this to transfer data:
insert into dbo.Contact
select
ContactID
,NameStyle
,Title
,FirstName
,MiddleName
,LastName
,Suffix
,EmailAddress
,EmailPromotion
,Phone
,ModifiedDate
from AdventureWorks.Person.Contact
this may be a stupid question, but I'm still learning sql. What does "Person" represent in the naming convention. AdventureWorks is the database, Contact is the table. What is Person?