Configure Import Export Connections

^{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=SERVERNAME;UID=ERP_AppUser;PWD=xyz;DATABASE=Aeros_Ext;', 1, GetDate(), GetDate(), 1 UNION ALL} 

^{SELECT 2, N'Aeros Attachment', N'SERVER=SE;UID=ERP_AppUser;PWD=xyz;DATABASE=Aeros_Attachment', 3, GetDate(), GetDate(), 1 UNION ALL} 

^{SELECT 3, N'Aeros Vision', N'SERVER=SRVGAERPSQL;UID=ERP_AppUser;PWD=xyz;DATABASE=Aeros_Vision;', 5, GetDate(), GetDate(), 1}

^COMMIT;

^{RAISERROR (N'[dbo].[ImportExportConnection]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;}

^GO

^{SET IDENTITY_INSERT [dbo].[ImportExportConnection] OFF;}