Migrate ISA 2006 logs to MS SQL 2000 using DTS
Hello,
I'm trying to figure out a way to copy the ISA 2006 MDSE database to MS SQL server 2000 using DTS. I want to maintain the MSDE tables in ISA 2006 server and schedule daily DTS job to copy the MSDE enytries to another server hosting MS SQL server 2000 standard edition. I know I can configure ISA 2006 to connect directly to the SQL 2000 but in this case I will loose some important features such as live monitoring and scheduled reporting.
I tried to connect remotely using OSQL -E -S myserver\MSFW and also using SQL 2000 Enterprise Manager but both attempts failed. I even opened all ports in ISA but still with no success.
Cheers
Have any one tried this scenario before ?
Thanks
I'm trying to figure out a way to copy the ISA 2006 MDSE database to MS SQL server 2000 using DTS. I want to maintain the MSDE tables in ISA 2006 server and schedule daily DTS job to copy the MSDE enytries to another server hosting MS SQL server 2000 standard edition. I know I can configure ISA 2006 to connect directly to the SQL 2000 but in this case I will loose some important features such as live monitoring and scheduled reporting.
I tried to connect remotely using OSQL -E -S myserver\MSFW and also using SQL 2000 Enterprise Manager but both attempts failed. I even opened all ports in ISA but still with no success.
Cheers
Have any one tried this scenario before ?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't know.
I don't know that you will ever be able to do what you are wanting.
I don't know that you will ever be able to do what you are wanting.
ASKER
Thanks pwindell.
I was thinking some more.
You probably know a lot more about SQL Server than I do,...but if you load the Enterprise Manager on the ISA and open the DB Engine,...then maybe you can enable the "features" than MS left disabled. I don't know for sure,...but it is just a thought.
You probably know a lot more about SQL Server than I do,...but if you load the Enterprise Manager on the ISA and open the DB Engine,...then maybe you can enable the "features" than MS left disabled. I don't know for sure,...but it is just a thought.
ASKER
Thanks
ASKER
Thanks for the comments. if I install the SQL Enterprise manager on the ISA server, how do I create a DTS to read the MSDE database and convert it to SQL database given that the MSDE database name is chaning every day?
Regards