Share
Report
1,240 hi,
I need to move smartlist favourites data(user specific) from one sql server location(SQL01) to another sql server location(SQL02). I am not able to login to GP on SQL01 location so it needs to be achieved through queries only.
Query : to find differences of informations between two server
select * from SLB10000 where SmartList_Number in
(
select distinct ASI_Favorite_Type from ASIEXP81 where userid = 'XYZ'
and ASI_Favorite_Name not in
(select distinct ASI_Favorite_Name from S_instance2.DYNAMICS.dbo.ASIEXP81))
I analyzed and found that smartlist favourites tables ASIEXP81 and ASIEXP86 contain "ASI_Favorite_Type" field which is SmartList_Number in SLB10000 (Master). I have corrected the data for the same case.
My issue is : there are few records in tables ASIEXP81 and ASIEXP86 which have not relevance in SLB10000( ASI_Favorite_Type from ASIEXP81 have no corrospnding records in SLB10000 ). If I move data for ASIEXP81 and ASIEXP86 then where could I view these smartlists in GP which have no master entry in SLB10000?
*This post is locked for comments
All responses (
Answers (
