June 8, 2014 at 6:26 am
Dear All,
I would ask for your help in order to be sure that my reasoning is correct. I am migrating a server structure from SQL 2008 to 2012 and I would keep Job history for reporting purposes, but I cant migrate directly msdb.
So i copied my 2008 msdb to 2012 msdb trying to insert into SQL 2012 jobs tables the exact content of SQL 2008 jobs tables.
Is there any other suggestion or best practice for doing this task?
Many thanks in advance.
Best Regards,
Roberto
June 9, 2014 at 1:46 am
kamamusic (6/8/2014)
Dear All,I would ask for your help in order to be sure that my reasoning is correct. I am migrating a server structure from SQL 2008 to 2012 and I would keep Job history for reporting purposes, but I cant migrate directly msdb.
So i copied my 2008 msdb to 2012 msdb trying to insert into SQL 2012 jobs tables the exact content of SQL 2008 jobs tables.
Is there any other suggestion or best practice for doing this task?
Many thanks in advance.
Best Regards,
Roberto
First suggestion would be to import the 2008 history into an auxiliary database on the 2012 instance and then combine the two in the reporting queries.
😎
June 11, 2014 at 1:25 am
Hi
your solution is exactly what i'm doing, but it seems for me an "in extremis" way.
Does anynoe know other strategies or tools for doing that?
Thanks again!
BR,
Roberto
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply