> ok but we have about thousand different virtual hosts to migrate !
That shouldn't make any difference, if you know some basic SQL.
(Okay, it's not that basic. But it is straightforward once you know
the requirements.)
--BEGIN T-SQL--
USE IMAILSECDB
DECLARE @IMailTables CURSOR
DECLARE @IMailTable varchar(255)
DECLARE @IMailCSV varchar(255)
DECLARE @bcpString varchar(1024)
SET @IMailTables = CURSOR FAST_FORWARD READ_ONLY
FOR
SELECT distinct object_name(id)
FROM sysindexes
WHERE id IN(
SELECT id
FROM sysobjects
WHERE type = 'U'
AND name != 'dtproperties'
)
OPEN @IMailTables
FETCH NEXT FROM @IMailTables INTO @IMailTable
SELECT @IMailCSV = REPLACE(@IMailTable,'_','.')
SET @bcpString = 'bcp "SELECT USERID, PASSWORD, FULLNAME FROM IMAILSECDB..' +
@IMailTable + '" queryout c:\IMail\' + @IMailCSV + '.csv -t, -c -T'
EXEC master..xp_cmdshell @bcpString
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM @IMailTables INTO @IMailTable
SELECT @IMailCSV = REPLACE(@IMailTable,'_','.')
SET @bcpString = 'bcp "SELECT USERID, PASSWORD, FULLNAME FROM IMAILSECDB..' +
@IMailTable + '" queryout c:\IMail\' + @IMailCSV + '.csv -t, -c -T'
EXEC master..xp_cmdshell @bcpString
END
CLOSE @IMailTables
DEALLOCATE @IMailTables
--END T-SQL--
-Sandy
------------------------------------
Sanford Whiteman, Chief Technologist
Broadleaf Systems, a division of
Cypress Integrated Systems, Inc.
e-mail: [EMAIL PROTECTED]
------------------------------------
To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html
List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
