DELETE FROM ImportExportConnection
SET IDENTITY_INSERT [dbo].[ImportExportConnection] ON;
BEGIN TRANSACTION;
INSERT INTO [dbo].[ImportExportConnection]([idImportExportConnection], [ImportExportConnectionDesc], [ImportExportConnectionString], [fkImportExportDatabaseType], [RowCreateDate], [RowModifyDate], [RowVersion])
SELECT 1, N'Aeros Ext', N'SERVER=SRVGAERPSQL;UID=ERP_AppUser;PWD=xyz;DATABASE=Aeros_Ext;', 1, '20111026 11:15:47.753', '20130916 09:58:42.660', 13 UNION ALL
SELECT 2, N'Aeros Attachment', N'SERVER=SRVGAERPSQL;UID=ERP_AppUser;PWD=xyz;DATABASE=Aeros_Attachment', 3, '20120306 18:35:57.757', '20130924 21:42:39.000', 10 UNION ALL
SELECT 3, N'Aeros Vision', N'SERVER=SRVGAERPSQL;UID=ERP_AppUser;PWD=xyz;DATABASE=Aeros_Vision;', 5, '20140424 08:33:18.637', '20140424 08:38:38.070', 3
COMMIT;
RAISERROR (N'[dbo].[ImportExportConnection]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;
GO
SET IDENTITY_INSERT [dbo].[ImportExportConnection] OFF;