9 Replies Latest reply on Apr 18, 2017 5:26 AM by LibraTiger

    Do not see the synonyms tables for SQL SERVER DB

    User472204-OC

      Hi Experts,

      After I create the synonyms for different data source(DB Name) in SQL SERVER, and I can see the related synonyms tables in SQL SERVER, but do not see them when I import data by RPD for using the same user. Is it ok for Oracle, not SQL SERVER DB, What happen? The synonyms is not for SQL SERVER DB? Or what I missing some steps?

       

      – Generates Synonyms:

      use [ecp_ods]
      select 'create synonym ' + name + ' for [ecp_ods].[dbo].[' + name + '];'
      from sys.objects where type_desc='user_table' order by name;

      – Then create synonyms:
      use [ecp_lcl];
      create synonym acpt_typ for [ecp_ods].[dbo].[acpt_typ];