copy data from one table of database to another database

Question

i have two databases with name "Student" and "Student1"

The "studentDetails" table is bellow

SdtId    |  StuName
           |
numeric | varbinary(100)
(100)    | 
           |
           |
a Certificate name("stuCert") and Symmetric("stuKey") Key are exist

for encripting the datas in sql server

code for insert

@StdName NVARCHAR(50)
@StdClass NVARCHAR(50)

ALTER PROCEDURE [dbo].[StudentInsert]NVARCHAR(50) ,

BEGIN
DECLARE @OMK nvarchar(1000)
DECLARE @OSK nvarchar(1000)
DECLARE @CMK nvarchar(100)
SET @OMK = 'OPEN MASTER KEY DECRYPTION BY PASSWORD =''abc'''
SET @OSK = 'OPEN SYMMETRIC KEY stuKey DECRYPTION BY CERTIFICATE stuCert'
SET @CMK = 'CLOSE MASTER KEY'
EXEC (@OMK);

IF @@error = 0
BEGIN

EXEC (@OSK);

INSERT INTO Student VALUES (@StdName,ENCRYPTBYKEY
(KEY_GUID('stuKey'),@StdClass))

EXEC (@CMK)

END
END

code for select

DECLARE @openMasterKey nvarchar(4000);

SET @openMasterKey='OPEN MASTER KEY DECRYPTION BY PASSWORD =''abc''';

EXEC (@openMasterKey);

IF @@error = 0

BEGIN

OPEN SYMMETRIC KEY stuKey DECRYPTION BY CERTIFICATE stuCert
SELECT dbo.Student1.StdId, dbo.Student1.StdName, cast(CONVERT(NVARCHAR(50),DECRYPTBYKEY(StdClass)) as NVARCHAR(50)) AS StdClassFROM dbo.Student1END

i want to copy datas from table "studentDetails"  from database "Student" to database "Student1"
please help me...