Try

INSERT INTO test2.dbo.cisstudemo SELECT * test1.dbo.cisstudemo

It assumes that test2.dbo.cisstudemo already exists.

>Hello Group,
>
>I would like to transfer all of the records in test1 database table cisstudemo into test2 database cisstudemo.
>
< snip >