SET IDENTITY_INSERT asurnet.dbo.COMPETIDORES ON;
INSERT INTO asurnet.dbo.COMPETIDORES (
    COM_ID,
    OPT_ID,
    COM_NOMBRE,
    COM_COMPANIA,
	COM_PRODUCTO,
	COM_COMENTARIOS,
	COM_PRECIO
    )
SELECT      COM_ID,
    OPT_ID,
    COM_NOMBRE,
    COM_COMPANIA,
	COM_PRODUCTO,
	COM_COMENTARIOS,
	COM_PRECIO
FROM vsegbas.dbo.COMPETIDORES A
    ;
SET IDENTITY_INSERT asurnet.dbo.COMPETIDORES OFF;