if exists (select * FROM sys.sysobjects where id = object_id(N'dbo.ConnectionLogNew'))
    insert into dbo.ConnectionLogNew (ID, Username, MachineName, Message, MessageType, ConnectionName, ConnectionTypeName, ConnectionID, StartDateTime, EndDateTime, LoggedUserName, GroupName, StartDateTimeUTC, EndDateTimeUTC, Cost, Comment, Prompt, Data, ManualEndDateTime, UserInfoID, ManualClosedBy, SecurityGroup, SupportClose, OpenMode, CloseMode, HostName, IsEmbedded, ClosePrompt, Status, ActivityDuration, DataSourceID, CreationDate, ActiveTime, Application, Version, IsPrivate, PrivateUserID)
    select ID, Username, MachineName, Message, MessageType, ConnectionName, ConnectionTypeName, ConnectionID, StartDateTime, EndDateTime, LoggedUserName, GroupName, StartDateTimeUTC, EndDateTimeUTC, Cost, Comment, Prompt, Data, ManualEndDateTime, UserInfoID, ManualClosedBy, SecurityGroup, SupportClose, OpenMode, CloseMode, HostName, IsEmbedded, ClosePrompt, Status, ActivityDuration, DataSourceID, CreationDate, ActiveTime, Application, Version, IsPrivate, PrivateUserID
    from dbo.ConnectionLog;