Agregar base de datos auxiliar

Al agregar un servidor de comunicación, agrega y conecta una base de datos auxiliar para reducir la carga en el servidor principal.

Información

• Necesitas una licencia de servidor de comunicación múltiple para agregar una base de datos auxiliar. Para más información sobre la política de licencias, consulta lo siguiente.

• Para obtener más información sobre la instalación de un servidor de comunicación, consulta lo siguiente.

Antes de comenzar

Si usas un dominio o nombre de host en lugar de una dirección IP para la comunicación entre bases de datos en un entorno MariaDB, asegúrate de revisar la siguiente guía.

• Si no utilizas una dirección IP, puede que no sea posible ejecutar Create user o Grant.

• Si la comunicación se realiza mediante un dominio o nombre de host, asegura que el usuario y los permisos estén registrados para localhost.

• Si instalaste BioStar X mediante el método de instalación conveniente, la cuenta root está registrada solo para localhost, por lo que debes agregar la dirección IP del servidor o 127.0.0.1.

Método de registro

Verifica si hay una contraseña establecida para la cuenta con Host 127.0.0.1 y Usuario root; si no existe, establece una contraseña y otorga permisos.

1. Verifica si hay una contraseña establecida para la cuenta con Host 127.0.0.1 y Usuario root.

   SELECT * FROM mysql.user;

   

   Si está en blanco, la contraseña no está establecida; ejecuta la consulta en los siguientes elementos para agregar una contraseña y otorgar permisos.

2. Establece una contraseña y otorga permisos para la cuenta con Host 127.0.0.1 y Usuario root.

   ALTER USER 'root'@'127.0.0.1' IDENTIFIED BY '<Main DB AC Schema Password>';
   GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1';
     
   CREATE USER '<Main DB AC User>'@'127.0.0.1' IDENTIFIED BY '<Main DB AC Schema Password>';
   GRANT ALL PRIVILEGES ON *.* TO '<Main DB AC User>'@'127.0.0.1';
   CREATE USER '<Main DB AC User>'@'::1' IDENTIFIED BY '<Main DB AC Schema Password>';
   GRANT ALL PRIVILEGES ON *.* TO '<Main DB AC User>'@'::1';
     
   CREATE USER '<Main DB TA User>'@'127.0.0.1' IDENTIFIED BY '<Main DB AC Schema Password>';
   GRANT ALL PRIVILEGES ON *.* TO '<Main DB TA User>'@'127.0.0.1';
   CREATE USER '<Main DB TA User>'@'::1' IDENTIFIED BY '<Main DB AC Schema Password>';
   GRANT ALL PRIVILEGES ON *.* TO '<Main DB TA User>'@'::1';
     
   CREATE USER '<Main DB VE User>'@'127.0.0.1' IDENTIFIED BY '<Main DB AC Schema Password>';
   GRANT ALL PRIVILEGES ON *.* TO '<Main DB VE User>'@'127.0.0.1';
   CREATE USER '<Main DB VE User>'@'::1' IDENTIFIED BY '<Main DB AC Schema Password>';
   GRANT ALL PRIVILEGES ON *.* TO '<Main DB VE User>'@'::1';
     
   FLUSH PRIVILEGES;

   Example

   ALTER USER 'root'@'127.0.0.1' IDENTIFIED BY 'admin1234!';
   GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1';
   FLUSH PRIVILEGES;

Configuración de comunicación mediante dirección IP

Las siguientes configuraciones pueden forzar la comunicación mediante dirección IP.

1. Después de instalar BioStar X, dirígete a la siguiente ruta.

   C:\Program Files\BioStar X\ta\mariadb-11.4.4-winx64

2. Abre el archivo my.cnf con permisos de propietario y agrega la opción skip-name-resolve a la sección [mysqld].

   [mysqld]
   port = 3312
   character-set-server=utf8
   collation-server=utf8_unicode_ci
   socket = /tmp/mysql.sock
   skip-external-locking
   key_buffer_size = 32M
   max_allowed_packet = 64M
   ...
   skip-name-resolve

3. Reinicia el servicio de MariaDB.

Agregar base de datos auxiliar

Esta sección brinda orientación sobre cómo agregar una base de datos auxiliar. Según el tipo de base de datos que se utilice, existen dos métodos: MariaDB y SQL Server.

MariaDB

Base de datos principal

Otorga la cuenta y los permisos para acceder a la base de datos principal desde la nueva base de datos auxiliar.

CREATE USER '<Main DB AC Schema User>'@'<Sub DB IP>' IDENTIFIED BY '<Main DB AC Schema Password>';

GRANT ALL PRIVILEGES ON <Main DB AC Schema>.* TO '<Main DB AC Schema User>'@'<Sub DB IP>';
FLUSH PRIVILEGES;

Example

CREATE USER 'biostarx_ac_user'@'192.168.12.42' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON biostar2_ac.* TO 'biostarx_ac_user'@'192.168.12.42';
FLUSH PRIVILEGES;

Base de datos auxiliar

Otorga la cuenta y los permisos para acceder a la nueva base de datos auxiliar desde la base de datos principal.

CREATE USER '<Sub DB AC Schema User>'@'<Main DB IP>' IDENTIFIED BY '<Sub DB AC Schema Password>';

GRANT ALL PRIVILEGES ON <Sub DB AC Schema>.* TO '<Sub DB AC Schema User>'@'<Main DB IP>';
FLUSH PRIVILEGES;

Example

CREATE USER 'biostarx_ac_user'@'192.168.12.161' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON biostar2_ac.* TO 'biostarx_ac_user'@'192.168.12.161';
FLUSH PRIVILEGES;

Verificar el uso de FederatedX

Ejecuta el siguiente comando tanto en la base de datos principal como en la auxiliar para verificar si el motor de almacenamiento FederatedX está habilitado.

SHOW ENGINES;

Si el resultado de la consulta muestra Engine : FEDERATED, Support : YES, ya está instalado. Si el motor de almacenamiento FederatedX no está instalado, ejecuta la siguiente consulta.

INSTALL PLUGIN federated SONAME 'ha_federatedx';

Información

Verifica si el archivo ha_federatedx.dll existe en la carpeta lib/plugin en la ruta donde está instalada MariaDB. Normalmente, el archivo dll se encuentra en la ruta C:\Program Files\MariaDB {version}\lib\plugin.

Registrar alias de servidor

Registra un alias de servidor para que la tabla federatedX creada en la base de datos auxiliar pueda acceder a la tabla origen en la base de datos principal.

CREATE SERVER 'default' FOREIGN DATA WRAPPER mysql OPTIONS (HOST '<Main DB IP>', PORT <Main DB PORT>, DATABASE '<Main DB AC Schema>', USER '<Main DB AC USER>', PASSWORD '<Main DB AC USER Password>');

-- Confirm registration
SELECT * FROM mysql.servers;

Si necesitas cambiar la información de Host, Puerto, BD, Usuario o Contraseña del nombre de servidor registrado, puedes modificarla usando la instrucción Alter. También puedes cambiar solo cierta información.

ALTER SERVER 'default' OPTIONS (HOST '<Main DB IP>', PORT <Main DB PORT>, DATABASE '<Main DB AC Schema>', USER '<Main DB AC USER>', PASSWORD '<Main DB AC USER Password>');

Example

CREATE SERVER 'default' FOREIGN DATA WRAPPER mysql OPTIONS (HOST '192.168.12.161', PORT 3312, DATABASE 'biostar2_ac', USER 'biostarx_ac_user', PASSWORD 'password');
  
ALTER SERVER 'default' OPTIONS (HOST '192.168.12.161', PORT 3312, DATABASE 'biostar2_ac', USER 'biostarx_ac_usermt__fttid__', PASSWORD 'password');

Configuración de enlace de tablas

Sigue los pasos a continuación para enlazar las tablas necesarias en la base de datos auxiliar con las tablas en la base de datos principal.

• A continuación se muestra la consulta para generar sentencias CREATE TABLE en la base de datos principal.

  select
    concat(
        'CREATE TABLE IF NOT EXISTS <SubDB_AC_Database_Schema>.', table_name,
        ' ENGINE=FEDERATED ',
        'CONNECTION=''default/', table_name, ''';'
    ) as create_table_sql
  from information_schema.TABLES
  where TABLE_SCHEMA = '<MainDB_AC_Database_Schema>'
      AND TABLE_TYPE = 'BASE TABLE'
      AND NOT TABLE_NAME REGEXP '^t_lg[0-9]{6}$'
      AND NOT TABLE_NAME REGEXP '^t_almevt[0-9]{6}$'
      AND NOT TABLE_NAME REGEXP '^t_lgalmtrstrc[0-9]{6}$'
  ORDER BY TABLE_NAME;

  Información

  Debido a la naturaleza de FederatedX, se recomienda establecer Table_type en 'BASE TABLE'. El VIEW type también es posible, pero no recomendado.

• Asegúrate de ingresar la sentencia CREATE generada por la consulta anterior en la base de datos auxiliar.

  CREATE TABLE

  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.mt__fttid__ ENGINE=FEDERATED CONNECTION='default/mt__fttid__';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.mt__lksrch ENGINE=FEDERATED CONNECTION='default/mt__lksrch';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.temp_acsgrusr ENGINE=FEDERATED CONNECTION='default/temp_acsgrusr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.temp_doubleauthusr ENGINE=FEDERATED CONNECTION='default/temp_doubleauthusr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.temp_operator ENGINE=FEDERATED CONNECTION='default/temp_operator';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_acsgr ENGINE=FEDERATED CONNECTION='default/t_acsgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_acsgrlvls ENGINE=FEDERATED CONNECTION='default/t_acsgrlvls';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_acsgrsent ENGINE=FEDERATED CONNECTION='default/t_acsgrsent';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_acsgruss ENGINE=FEDERATED CONNECTION='default/t_acsgruss';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_acslvl ENGINE=FEDERATED CONNECTION='default/t_acslvl';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_acslvlitm ENGINE=FEDERATED CONNECTION='default/t_acslvlitm';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_acslvlitmdrs ENGINE=FEDERATED CONNECTION='default/t_acslvlitmdrs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_acslvlitms ENGINE=FEDERATED CONNECTION='default/t_acslvlitms';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_acslvlsent ENGINE=FEDERATED CONNECTION='default/t_acslvlsent';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_adserver_setting ENGINE=FEDERATED CONNECTION='default/t_adserver_setting';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_adt ENGINE=FEDERATED CONNECTION='default/t_adt';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_advusrcrd ENGINE=FEDERATED CONNECTION='default/t_advusrcrd';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_advusrgrp ENGINE=FEDERATED CONNECTION='default/t_advusrgrp';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_ad_column ENGINE=FEDERATED CONNECTION='default/t_ad_column';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_ad_group_filter ENGINE=FEDERATED CONNECTION='default/t_ad_group_filter';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_ad_group_filter_setting ENGINE=FEDERATED CONNECTION='default/t_ad_group_filter_setting';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_ad_usrmapping ENGINE=FEDERATED CONNECTION='default/t_ad_usrmapping';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_almact ENGINE=FEDERATED CONNECTION='default/t_almact';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_almdr ENGINE=FEDERATED CONNECTION='default/t_almdr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_almeml ENGINE=FEDERATED CONNECTION='default/t_almeml';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_almmsg ENGINE=FEDERATED CONNECTION='default/t_almmsg';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_almset ENGINE=FEDERATED CONNECTION='default/t_almset';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_almsetevt ENGINE=FEDERATED CONNECTION='default/t_almsetevt';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_almsetobj ENGINE=FEDERATED CONNECTION='default/t_almsetobj';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_almsmtpset ENGINE=FEDERATED CONNECTION='default/t_almsmtpset';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_almsndset ENGINE=FEDERATED CONNECTION='default/t_almsndset';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_apbbpacgr ENGINE=FEDERATED CONNECTION='default/t_apbbpacgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_area_info ENGINE=FEDERATED CONNECTION='default/t_area_info';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_atmsyndevgrs ENGINE=FEDERATED CONNECTION='default/t_atmsyndevgrs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_atmsyndevs ENGINE=FEDERATED CONNECTION='default/t_atmsyndevs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_audit ENGINE=FEDERATED CONNECTION='default/t_audit';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_authgrp ENGINE=FEDERATED CONNECTION='default/t_authgrp';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_blkl ENGINE=FEDERATED CONNECTION='default/t_blkl';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_bzoup ENGINE=FEDERATED CONNECTION='default/t_bzoup';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_crd ENGINE=FEDERATED CONNECTION='default/t_crd';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_crdidasm ENGINE=FEDERATED CONNECTION='default/t_crdidasm';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_crdisshis ENGINE=FEDERATED CONNECTION='default/t_crdisshis';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_crdlay ENGINE=FEDERATED CONNECTION='default/t_crdlay';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_crdlay_felica ENGINE=FEDERATED CONNECTION='default/t_crdlay_felica';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_crdmoachis ENGINE=FEDERATED CONNECTION='default/t_crdmoachis';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_crdt ENGINE=FEDERATED CONNECTION='default/t_crdt';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_crdtbin ENGINE=FEDERATED CONNECTION='default/t_crdtbin';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_crdtyp ENGINE=FEDERATED CONNECTION='default/t_crdtyp';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_cusfldtyp ENGINE=FEDERATED CONNECTION='default/t_cusfldtyp';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_cusfldtyp_vst ENGINE=FEDERATED CONNECTION='default/t_cusfldtyp_vst';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_dashboard_setting ENGINE=FEDERATED CONNECTION='default/t_dashboard_setting';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_dblmdacsgrs ENGINE=FEDERATED CONNECTION='default/t_dblmdacsgrs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_dblmdflrgrs ENGINE=FEDERATED CONNECTION='default/t_dblmdflrgrs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_dev ENGINE=FEDERATED CONNECTION='default/t_dev';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_dev3rdprnt ENGINE=FEDERATED CONNECTION='default/t_dev3rdprnt';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_devcap ENGINE=FEDERATED CONNECTION='default/t_devcap';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_devcaps ENGINE=FEDERATED CONNECTION='default/t_devcaps';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_devcapsfrdev ENGINE=FEDERATED CONNECTION='default/t_devcapsfrdev';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_devforcecmd ENGINE=FEDERATED CONNECTION='default/t_devforcecmd';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_devgr ENGINE=FEDERATED CONNECTION='default/t_devgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_devinactive ENGINE=FEDERATED CONNECTION='default/t_devinactive';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_devoprmd ENGINE=FEDERATED CONNECTION='default/t_devoprmd';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_devoprt ENGINE=FEDERATED CONNECTION='default/t_devoprt';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_devrs4chns ENGINE=FEDERATED CONNECTION='default/t_devrs4chns';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_devthm ENGINE=FEDERATED CONNECTION='default/t_devthm';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_devtposdp ENGINE=FEDERATED CONNECTION='default/t_devtposdp';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_devtyp ENGINE=FEDERATED CONNECTION='default/t_devtyp';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_devwgd ENGINE=FEDERATED CONNECTION='default/t_devwgd';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_dev_fllr ENGINE=FEDERATED CONNECTION='default/t_dev_fllr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_dr ENGINE=FEDERATED CONNECTION='default/t_dr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_drgr ENGINE=FEDERATED CONNECTION='default/t_drgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_drtrgact ENGINE=FEDERATED CONNECTION='default/t_drtrgact';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_drzn ENGINE=FEDERATED CONNECTION='default/t_drzn';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_dr_flr_map ENGINE=FEDERATED CONNECTION='default/t_dr_flr_map';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_dst ENGINE=FEDERATED CONNECTION='default/t_dst';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_elvt ENGINE=FEDERATED CONNECTION='default/t_elvt';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_elvtdevs ENGINE=FEDERATED CONNECTION='default/t_elvtdevs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_elvtgr ENGINE=FEDERATED CONNECTION='default/t_elvtgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_elvttrgact ENGINE=FEDERATED CONNECTION='default/t_elvttrgact';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_email_content ENGINE=FEDERATED CONNECTION='default/t_email_content';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_emlst ENGINE=FEDERATED CONNECTION='default/t_emlst';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_encmgr ENGINE=FEDERATED CONNECTION='default/t_encmgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_erldev ENGINE=FEDERATED CONNECTION='default/t_erldev';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_etrdevs ENGINE=FEDERATED CONNECTION='default/t_etrdevs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_evtflt ENGINE=FEDERATED CONNECTION='default/t_evtflt';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_evtprio ENGINE=FEDERATED CONNECTION='default/t_evtprio';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_evtprioaltdevs ENGINE=FEDERATED CONNECTION='default/t_evtprioaltdevs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_evtpriosnd ENGINE=FEDERATED CONNECTION='default/t_evtpriosnd';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_evtspc ENGINE=FEDERATED CONNECTION='default/t_evtspc';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_evttyp ENGINE=FEDERATED CONNECTION='default/t_evttyp';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_evttyp_group ENGINE=FEDERATED CONNECTION='default/t_evttyp_group';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_exdevs ENGINE=FEDERATED CONNECTION='default/t_exdevs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_extsys ENGINE=FEDERATED CONNECTION='default/t_extsys';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_failsyncacsgrupdate ENGINE=FEDERATED CONNECTION='default/t_failsyncacsgrupdate';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_failsyncacslvlupdate ENGINE=FEDERATED CONNECTION='default/t_failsyncacslvlupdate';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_failsyncflrlvlupdate ENGINE=FEDERATED CONNECTION='default/t_failsyncflrlvlupdate';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_failsyncusrupdate ENGINE=FEDERATED CONNECTION='default/t_failsyncusrupdate';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_faldrgrs ENGINE=FEDERATED CONNECTION='default/t_faldrgrs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_faldrs ENGINE=FEDERATED CONNECTION='default/t_faldrs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_falelvts ENGINE=FEDERATED CONNECTION='default/t_falelvts';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_fclty_info ENGINE=FEDERATED CONNECTION='default/t_fclty_info';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_fctmpl ENGINE=FEDERATED CONNECTION='default/t_fctmpl';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_flkbpacgr ENGINE=FEDERATED CONNECTION='default/t_flkbpacgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_flkdrgrs ENGINE=FEDERATED CONNECTION='default/t_flkdrgrs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_flkdrs ENGINE=FEDERATED CONNECTION='default/t_flkdrs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_flkelvts ENGINE=FEDERATED CONNECTION='default/t_flkelvts';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_flrgrlvls ENGINE=FEDERATED CONNECTION='default/t_flrgrlvls';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_flrlvl ENGINE=FEDERATED CONNECTION='default/t_flrlvl';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_flrlvlitm ENGINE=FEDERATED CONNECTION='default/t_flrlvlitm';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_flrlvlitmelvts ENGINE=FEDERATED CONNECTION='default/t_flrlvlitmelvts';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_flrlvlitms ENGINE=FEDERATED CONNECTION='default/t_flrlvlitms';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_flrlvlsent ENGINE=FEDERATED CONNECTION='default/t_flrlvlsent';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_flrs ENGINE=FEDERATED CONNECTION='default/t_flrs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_flr_info ENGINE=FEDERATED CONNECTION='default/t_flr_info';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_fngptmpl ENGINE=FEDERATED CONNECTION='default/t_fngptmpl';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_fngptmplver ENGINE=FEDERATED CONNECTION='default/t_fngptmplver';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_fulacgrs ENGINE=FEDERATED CONNECTION='default/t_fulacgrs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_fuldrgrs ENGINE=FEDERATED CONNECTION='default/t_fuldrgrs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_fuldrs ENGINE=FEDERATED CONNECTION='default/t_fuldrs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_fulelvts ENGINE=FEDERATED CONNECTION='default/t_fulelvts';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_gis_door_info ENGINE=FEDERATED CONNECTION='default/t_gis_door_info';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_gis_vcm_info ENGINE=FEDERATED CONNECTION='default/t_gis_vcm_info';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_grm ENGINE=FEDERATED CONNECTION='default/t_grm';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_grmel ENGINE=FEDERATED CONNECTION='default/t_grmel';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_grmeltyp ENGINE=FEDERATED CONNECTION='default/t_grmeltyp';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_grmelvid ENGINE=FEDERATED CONNECTION='default/t_grmelvid';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_grmgr ENGINE=FEDERATED CONNECTION='default/t_grmgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_hol ENGINE=FEDERATED CONNECTION='default/t_hol';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_holgr ENGINE=FEDERATED CONNECTION='default/t_holgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_holsch ENGINE=FEDERATED CONNECTION='default/t_holsch';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_holschtmprds ENGINE=FEDERATED CONNECTION='default/t_holschtmprds';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_imglgjb ENGINE=FEDERATED CONNECTION='default/t_imglgjb';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_inpcfg ENGINE=FEDERATED CONNECTION='default/t_inpcfg';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_inpcfgex ENGINE=FEDERATED CONNECTION='default/t_inpcfgex';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_ledoup ENGINE=FEDERATED CONNECTION='default/t_ledoup';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_lgserverevt ENGINE=FEDERATED CONNECTION='default/t_lgserverevt';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_lgtbidx ENGINE=FEDERATED CONNECTION='default/t_lgtbidx';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_lgupdhis ENGINE=FEDERATED CONNECTION='default/t_lgupdhis';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_licenses ENGINE=FEDERATED CONNECTION='default/t_licenses';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_lstlog ENGINE=FEDERATED CONNECTION='default/t_lstlog';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_lstsynsta ENGINE=FEDERATED CONNECTION='default/t_lstsynsta';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_lstusrauth ENGINE=FEDERATED CONNECTION='default/t_lstusrauth';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_lulacgrs ENGINE=FEDERATED CONNECTION='default/t_lulacgrs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_mblcrd ENGINE=FEDERATED CONNECTION='default/t_mblcrd';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_mobile_credential ENGINE=FEDERATED CONNECTION='default/t_mobile_credential';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_mobile_picture_hash ENGINE=FEDERATED CONNECTION='default/t_mobile_picture_hash';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_mxdt ENGINE=FEDERATED CONNECTION='default/t_mxdt';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_nested_dev ENGINE=FEDERATED CONNECTION='default/t_nested_dev';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_nested_devgr ENGINE=FEDERATED CONNECTION='default/t_nested_devgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_nested_drgr ENGINE=FEDERATED CONNECTION='default/t_nested_drgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_nested_elvtgr ENGINE=FEDERATED CONNECTION='default/t_nested_elvtgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_nested_grmgr ENGINE=FEDERATED CONNECTION='default/t_nested_grmgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_nested_usrgr ENGINE=FEDERATED CONNECTION='default/t_nested_usrgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_ntc ENGINE=FEDERATED CONNECTION='default/t_ntc';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_occpbpacgr ENGINE=FEDERATED CONNECTION='default/t_occpbpacgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_oupsig ENGINE=FEDERATED CONNECTION='default/t_oupsig';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_perm ENGINE=FEDERATED CONNECTION='default/t_perm';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_polygon_info ENGINE=FEDERATED CONNECTION='default/t_polygon_info';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_prf ENGINE=FEDERATED CONNECTION='default/t_prf';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_qcact ENGINE=FEDERATED CONNECTION='default/t_qcact';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_qcactalm ENGINE=FEDERATED CONNECTION='default/t_qcactalm';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_qcactperm ENGINE=FEDERATED CONNECTION='default/t_qcactperm';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_reporttempid ENGINE=FEDERATED CONNECTION='default/t_reporttempid';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_reporttempid_header ENGINE=FEDERATED CONNECTION='default/t_reporttempid_header';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_report_export_setting ENGINE=FEDERATED CONNECTION='default/t_report_export_setting';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_report_print_setting ENGINE=FEDERATED CONNECTION='default/t_report_print_setting';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_report_schedules ENGINE=FEDERATED CONNECTION='default/t_report_schedules';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_report_setting ENGINE=FEDERATED CONNECTION='default/t_report_setting';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_report_template ENGINE=FEDERATED CONNECTION='default/t_report_template';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_report_template_group_filter ENGINE=FEDERATED CONNECTION='default/t_report_template_group_filter';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_report_template_user_filter ENGINE=FEDERATED CONNECTION='default/t_report_template_user_filter';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_rmjb ENGINE=FEDERATED CONNECTION='default/t_rmjb';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_rmjbev ENGINE=FEDERATED CONNECTION='default/t_rmjbev';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_rmjbzn ENGINE=FEDERATED CONNECTION='default/t_rmjbzn';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_sch ENGINE=FEDERATED CONNECTION='default/t_sch';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_schdl ENGINE=FEDERATED CONNECTION='default/t_schdl';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_schdltmprds ENGINE=FEDERATED CONNECTION='default/t_schdltmprds';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_shf ENGINE=FEDERATED CONNECTION='default/t_shf';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_shfgr ENGINE=FEDERATED CONNECTION='default/t_shfgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_shfgrshfs ENGINE=FEDERATED CONNECTION='default/t_shfgrshfs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_shfgruss ENGINE=FEDERATED CONNECTION='default/t_shfgruss';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_shfrul ENGINE=FEDERATED CONNECTION='default/t_shfrul';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_shftmplshfs ENGINE=FEDERATED CONNECTION='default/t_shftmplshfs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_snd ENGINE=FEDERATED CONNECTION='default/t_snd';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_srvsta ENGINE=FEDERATED CONNECTION='default/t_srvsta';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_synctapb ENGINE=FEDERATED CONNECTION='default/t_synctapb';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_syscfg ENGINE=FEDERATED CONNECTION='default/t_syscfg';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_takey ENGINE=FEDERATED CONNECTION='default/t_takey';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_tmapbbpacgr ENGINE=FEDERATED CONNECTION='default/t_tmapbbpacgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_tmprd ENGINE=FEDERATED CONNECTION='default/t_tmprd';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_trgact ENGINE=FEDERATED CONNECTION='default/t_trgact';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_usersent ENGINE=FEDERATED CONNECTION='default/t_usersent';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_usr ENGINE=FEDERATED CONNECTION='default/t_usr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_usracsgrtmpl ENGINE=FEDERATED CONNECTION='default/t_usracsgrtmpl';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_usrcrd ENGINE=FEDERATED CONNECTION='default/t_usrcrd';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_usrcusfld ENGINE=FEDERATED CONNECTION='default/t_usrcusfld';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_usrcusfldtmpl ENGINE=FEDERATED CONNECTION='default/t_usrcusfldtmpl';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_usrgr ENGINE=FEDERATED CONNECTION='default/t_usrgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_usrgr_order ENGINE=FEDERATED CONNECTION='default/t_usrgr_order';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_usrmsksyn ENGINE=FEDERATED CONNECTION='default/t_usrmsksyn';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_usroprmd ENGINE=FEDERATED CONNECTION='default/t_usroprmd';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_usrphoto ENGINE=FEDERATED CONNECTION='default/t_usrphoto';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_usrtmpl ENGINE=FEDERATED CONNECTION='default/t_usrtmpl';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_usr_phrase ENGINE=FEDERATED CONNECTION='default/t_usr_phrase';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_usr_rep ENGINE=FEDERATED CONNECTION='default/t_usr_rep';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_vcm_flr_map ENGINE=FEDERATED CONNECTION='default/t_vcm_flr_map';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_vipphbks ENGINE=FEDERATED CONNECTION='default/t_vipphbks';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_visit ENGINE=FEDERATED CONNECTION='default/t_visit';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_visitacsgrmap ENGINE=FEDERATED CONNECTION='default/t_visitacsgrmap';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_visitcusfld ENGINE=FEDERATED CONNECTION='default/t_visitcusfld';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_visitfngptmpl ENGINE=FEDERATED CONNECTION='default/t_visitfngptmpl';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_visitfngptmplver ENGINE=FEDERATED CONNECTION='default/t_visitfngptmplver';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_visitorterminal ENGINE=FEDERATED CONNECTION='default/t_visitorterminal';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_visitorterminalacgroupmap ENGINE=FEDERATED CONNECTION='default/t_visitorterminalacgroupmap';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_visitorterminalregion ENGINE=FEDERATED CONNECTION='default/t_visitorterminalregion';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_visitorterminalregionmap ENGINE=FEDERATED CONNECTION='default/t_visitorterminalregionmap';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_visitorterms ENGINE=FEDERATED CONNECTION='default/t_visitorterms';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_wgdbz ENGINE=FEDERATED CONNECTION='default/t_wgdbz';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_wgdfmt ENGINE=FEDERATED CONNECTION='default/t_wgdfmt';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_wgdled ENGINE=FEDERATED CONNECTION='default/t_wgdled';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_wgdtmpr ENGINE=FEDERATED CONNECTION='default/t_wgdtmpr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_widget ENGINE=FEDERATED CONNECTION='default/t_widget';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_zn ENGINE=FEDERATED CONNECTION='default/t_zn';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_znacsgr ENGINE=FEDERATED CONNECTION='default/t_znacsgr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_znapb ENGINE=FEDERATED CONNECTION='default/t_znapb';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_znapbusrio ENGINE=FEDERATED CONNECTION='default/t_znapbusrio';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_zncrd ENGINE=FEDERATED CONNECTION='default/t_zncrd';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_zndr ENGINE=FEDERATED CONNECTION='default/t_zndr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_znelvt ENGINE=FEDERATED CONNECTION='default/t_znelvt';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_znfal ENGINE=FEDERATED CONNECTION='default/t_znfal';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_znfalinpsns ENGINE=FEDERATED CONNECTION='default/t_znfalinpsns';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_znflk ENGINE=FEDERATED CONNECTION='default/t_znflk';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_znflrs ENGINE=FEDERATED CONNECTION='default/t_znflrs';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_znful ENGINE=FEDERATED CONNECTION='default/t_znful';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_zninp ENGINE=FEDERATED CONNECTION='default/t_zninp';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_znital ENGINE=FEDERATED CONNECTION='default/t_znital';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_znlul ENGINE=FEDERATED CONNECTION='default/t_znlul';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_znmst ENGINE=FEDERATED CONNECTION='default/t_znmst';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_znoccp ENGINE=FEDERATED CONNECTION='default/t_znoccp';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_znoccp_lstusrevt ENGINE=FEDERATED CONNECTION='default/t_znoccp_lstusrevt';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_znrc ENGINE=FEDERATED CONNECTION='default/t_znrc';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_zntapb ENGINE=FEDERATED CONNECTION='default/t_zntapb';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_zntmapb ENGINE=FEDERATED CONNECTION='default/t_zntmapb';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_zntrck ENGINE=FEDERATED CONNECTION='default/t_zntrck';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_zntrgact ENGINE=FEDERATED CONNECTION='default/t_zntrgact';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.t_znusr ENGINE=FEDERATED CONNECTION='default/t_znusr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.v_devices ENGINE=FEDERATED CONNECTION='default/v_devices';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.v_dr ENGINE=FEDERATED CONNECTION='default/v_dr';
  CREATE TABLE IF NOT EXISTS biostar_x_ac_be_136.v_elvt ENGINE=FEDERATED CONNECTION='default/v_elvt';

Configuración de Service Manager

1. Ejecuta BioStar X Service Manager. (Inicio → BioStar X → BioStar X Service Manager)

2. Haz clic en el menú DATABASE en la barra lateral izquierda.

3. Haz clic en el botón + Add Database en la esquina superior derecha de la pantalla.

4. Ingresa cada elemento en la pantalla de adición de base de datos.

   

   • Name: Ingresa el nombre de la base de datos.

   • Description: Ingresa la descripción de la base de datos.

   • DB Type: Selecciona el tipo de base de datos. (Maria, MS SQL)

   • Host: Ingresa el nombre de host o la dirección IP del servidor de bases de datos.

   • Port: Ingresa el número de puerto del servidor de bases de datos.

   • AC / TA: Ingresa el nombre, usuario y contraseña de las bases de datos AC y TA.

5. Haz clic en el botón Test Connection en la esquina superior derecha para comprobar si la base de datos está correctamente conectada.

6. Haz clic en Save en la parte superior derecha de la pantalla para guardar la configuración.

SQL Server

Otorgar permisos para la base de datos principal

Concede los siguientes permisos en la base de datos principal con una cuenta que tenga privilegios de sysadmin.

GRANT ALTER ANY LINKED SERVER TO [<MAIN DATABASE AC USER>];
GRANT ALTER ANY LOGIN TO [<MAIN DATABASE AC USER>];

Example

GRANT ALTER ANY LINKED SERVER TO [biostar_x_user];
GRANT ALTER ANY LOGIN TO [biostar_x_user];

Otorgar permisos para la base de datos auxiliar

1. Conecta User Mapping para las tablas y usuarios en la base de datos auxiliar con una cuenta que tenga privilegios de sysadmin. En este momento, es necesario agregar el rol db_owner.

   

2. Otorga los siguientes permisos a la base de datos que se va a agregar.

   GRANT ALTER ANY LINKED SERVER TO [<SUB DATABASE AC USER>];
   GRANT ALTER ANY LOGIN TO [<SUB DATABASE AC USER>];

   Example

   GRANT ALTER ANY LINKED SERVER TO [biostar_x_user_sub];
   GRANT ALTER ANY LOGIN TO [biostar_x_user_sub];

Configuración de Service Manager

Usa BioStar X Service Manager para agregar la base de datos auxiliar.

1. Ejecuta BioStar X Service Manager. (Inicio → BioStar X → BioStar X Service Manager)

2. Haz clic en el menú DATABASE en la barra lateral izquierda.

3. Haz clic en el botón + Add Database en la esquina superior derecha de la pantalla.

4. Ingresa cada elemento en la pantalla de adición de base de datos.

   

   • Name: Ingresa el nombre de la base de datos.

   • Description: Ingresa la descripción de la base de datos.

   • DB Type: Selecciona el tipo de base de datos. (Maria, MS SQL)

   • Host: Ingresa el nombre de host o la dirección IP del servidor de bases de datos.

   • Port: Ingresa el número de puerto del servidor de bases de datos.

   • AC / TA: Ingresa el nombre, usuario y contraseña de las bases de datos AC y TA.

5. Haz clic en el botón Test Connection en la esquina superior derecha para comprobar si la base de datos está correctamente conectada.

6. Haz clic en Save en la parte superior derecha de la pantalla para guardar la configuración.

Información

• Después de completar la configuración, los ajustes de Linked Server para ambas bases de datos, principal y auxiliar, se aplicarán automáticamente.

• Incluso al modificar la información de la base de datos, los ajustes de Linked Server se cambiarán automáticamente. Al modificar la base de datos principal, los cambios se reflejarán en los ajustes de Linked Server de todas las bases de datos auxiliares registradas. Cuando se modifique la base de datos auxiliar, solo se reflejarán los cambios correspondientes a la base de datos principal y a esa base de datos auxiliar.

Generar la consulta de Linked Temp Table

Ejecuta la siguiente consulta en la base de datos principal para generar la consulta de Linked Temp Table que se creará en la base de datos auxiliar.

USE [<AC Schema>];
GO
DECLARE @LinkedServer  sysname = N'default';
DECLARE @SourceSchema  sysname = N'dbo';
DECLARE @TargetSchema  sysname = N'dbo';
  
SELECT
    'IF OBJECT_ID(N''' + QUOTENAME(@TargetSchema,'') + '.' + QUOTENAME(t.name,'') + ''', ''SN'') IS NOT NULL '
  + 'DROP SYNONYM ' + QUOTENAME(@TargetSchema) + '.' + QUOTENAME(t.name) + ';'
  + 'CREATE SYNONYM ' + QUOTENAME(@TargetSchema) + '.' + QUOTENAME(t.name)
  + ' FOR ' + QUOTENAME(@LinkedServer) + '.' + QUOTENAME(DB_NAME()) + '.' + QUOTENAME(s.name) + '.' + QUOTENAME(t.name) + ';'
  AS recreate_synonym_sql
FROM sys.tables AS t
JOIN sys.schemas AS s
  ON s.schema_id = t.schema_id
WHERE s.name = @SourceSchema
  AND t.is_ms_shipped = 0
  AND t.name NOT LIKE 't_lg[0-9][0-9][0-9][0-9][0-9][0-9]'
  AND t.name NOT LIKE 't_almevt[0-9][0-9][0-9][0-9][0-9][0-9]'
  AND t.name NOT LIKE 't_lgalmtrstrc[0-9][0-9][0-9][0-9][0-9][0-9]'
ORDER BY t.name;

Example

-- Example
USE [main_ac_x_215];
GO
DECLARE @LinkedServer  sysname = N'default';  -- Linked Server name set in the sub DB
DECLARE @SourceSchema  sysname = N'dbo';      -- Schema to target in the main DB
DECLARE @TargetSchema  sysname = N'dbo';      -- Schema to create synonyms in the sub DB (reflected in the output string)

SELECT
    'IF OBJECT_ID(N''' + QUOTENAME(@TargetSchema,'') + '.' + QUOTENAME(t.name,'') + ''', ''SN'') IS NOT NULL '
  + 'DROP SYNONYM ' + QUOTENAME(@TargetSchema) + '.' + QUOTENAME(t.name) + ';'
  + 'CREATE SYNONYM ' + QUOTENAME(@TargetSchema) + '.' + QUOTENAME(t.name)
  + ' FOR ' + QUOTENAME(@LinkedServer) + '.' + QUOTENAME(DB_NAME()) + '.' + QUOTENAME(s.name) + '.' + QUOTENAME(t.name) + ';'
  AS recreate_synonym_sql
FROM sys.tables AS t
JOIN sys.schemas AS s
  ON s.schema_id = t.schema_id
WHERE s.name = @SourceSchema
  AND t.is_ms_shipped = 0
  AND t.name NOT LIKE 't_lg[0-9][0-9][0-9][0-9][0-9][0-9]'
  AND t.name NOT LIKE 't_almevt[0-9][0-9][0-9][0-9][0-9][0-9]'
  AND t.name NOT LIKE 't_lgalmtrstrc[0-9][0-9][0-9][0-9][0-9][0-9]'
ORDER BY t.name;

Información

Este es un ejemplo de una instrucción CREATE generada por la consulta anterior.

CREATE TABLE

IF OBJECT_ID(N'[dbo].[T_ACSGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ACSGR];CREATE SYNONYM [dbo].[T_ACSGR] FOR [default].[main_ac_x_215].[dbo].[T_ACSGR];
IF OBJECT_ID(N'[dbo].[T_ACSGRLVLS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ACSGRLVLS];CREATE SYNONYM [dbo].[T_ACSGRLVLS] FOR [default].[main_ac_x_215].[dbo].[T_ACSGRLVLS];
IF OBJECT_ID(N'[dbo].[T_ACSGRSENT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ACSGRSENT];CREATE SYNONYM [dbo].[T_ACSGRSENT] FOR [default].[main_ac_x_215].[dbo].[T_ACSGRSENT];
IF OBJECT_ID(N'[dbo].[T_ACSGRUSS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ACSGRUSS];CREATE SYNONYM [dbo].[T_ACSGRUSS] FOR [default].[main_ac_x_215].[dbo].[T_ACSGRUSS];
IF OBJECT_ID(N'[dbo].[T_ACSLVL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ACSLVL];CREATE SYNONYM [dbo].[T_ACSLVL] FOR [default].[main_ac_x_215].[dbo].[T_ACSLVL];
IF OBJECT_ID(N'[dbo].[T_ACSLVLITM]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ACSLVLITM];CREATE SYNONYM [dbo].[T_ACSLVLITM] FOR [default].[main_ac_x_215].[dbo].[T_ACSLVLITM];
IF OBJECT_ID(N'[dbo].[T_ACSLVLITMDRS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ACSLVLITMDRS];CREATE SYNONYM [dbo].[T_ACSLVLITMDRS] FOR [default].[main_ac_x_215].[dbo].[T_ACSLVLITMDRS];
IF OBJECT_ID(N'[dbo].[T_ACSLVLITMS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ACSLVLITMS];CREATE SYNONYM [dbo].[T_ACSLVLITMS] FOR [default].[main_ac_x_215].[dbo].[T_ACSLVLITMS];
IF OBJECT_ID(N'[dbo].[T_ACSLVLSENT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ACSLVLSENT];CREATE SYNONYM [dbo].[T_ACSLVLSENT] FOR [default].[main_ac_x_215].[dbo].[T_ACSLVLSENT];
IF OBJECT_ID(N'[dbo].[T_AD_COLUMN]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_AD_COLUMN];CREATE SYNONYM [dbo].[T_AD_COLUMN] FOR [default].[main_ac_x_215].[dbo].[T_AD_COLUMN];
IF OBJECT_ID(N'[dbo].[T_AD_GROUP_FILTER]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_AD_GROUP_FILTER];CREATE SYNONYM [dbo].[T_AD_GROUP_FILTER] FOR [default].[main_ac_x_215].[dbo].[T_AD_GROUP_FILTER];
IF OBJECT_ID(N'[dbo].[T_AD_GROUP_FILTER_SETTING]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_AD_GROUP_FILTER_SETTING];CREATE SYNONYM [dbo].[T_AD_GROUP_FILTER_SETTING] FOR [default].[main_ac_x_215].[dbo].[T_AD_GROUP_FILTER_SETTING];
IF OBJECT_ID(N'[dbo].[T_AD_USRMAPPING]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_AD_USRMAPPING];CREATE SYNONYM [dbo].[T_AD_USRMAPPING] FOR [default].[main_ac_x_215].[dbo].[T_AD_USRMAPPING];
IF OBJECT_ID(N'[dbo].[T_ADSERVER_SETTING]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ADSERVER_SETTING];CREATE SYNONYM [dbo].[T_ADSERVER_SETTING] FOR [default].[main_ac_x_215].[dbo].[T_ADSERVER_SETTING];
IF OBJECT_ID(N'[dbo].[T_ADT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ADT];CREATE SYNONYM [dbo].[T_ADT] FOR [default].[main_ac_x_215].[dbo].[T_ADT];
IF OBJECT_ID(N'[dbo].[T_ADVUSRCRD]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ADVUSRCRD];CREATE SYNONYM [dbo].[T_ADVUSRCRD] FOR [default].[main_ac_x_215].[dbo].[T_ADVUSRCRD];
IF OBJECT_ID(N'[dbo].[T_ADVUSRGRP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ADVUSRGRP];CREATE SYNONYM [dbo].[T_ADVUSRGRP] FOR [default].[main_ac_x_215].[dbo].[T_ADVUSRGRP];
IF OBJECT_ID(N'[dbo].[T_ALMACT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ALMACT];CREATE SYNONYM [dbo].[T_ALMACT] FOR [default].[main_ac_x_215].[dbo].[T_ALMACT];
IF OBJECT_ID(N'[dbo].[T_ALMDR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ALMDR];CREATE SYNONYM [dbo].[T_ALMDR] FOR [default].[main_ac_x_215].[dbo].[T_ALMDR];
IF OBJECT_ID(N'[dbo].[T_ALMEML]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ALMEML];CREATE SYNONYM [dbo].[T_ALMEML] FOR [default].[main_ac_x_215].[dbo].[T_ALMEML];
IF OBJECT_ID(N'[dbo].[T_ALMMSG]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ALMMSG];CREATE SYNONYM [dbo].[T_ALMMSG] FOR [default].[main_ac_x_215].[dbo].[T_ALMMSG];
IF OBJECT_ID(N'[dbo].[T_ALMSET]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ALMSET];CREATE SYNONYM [dbo].[T_ALMSET] FOR [default].[main_ac_x_215].[dbo].[T_ALMSET];
IF OBJECT_ID(N'[dbo].[T_ALMSETEVT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ALMSETEVT];CREATE SYNONYM [dbo].[T_ALMSETEVT] FOR [default].[main_ac_x_215].[dbo].[T_ALMSETEVT];
IF OBJECT_ID(N'[dbo].[T_ALMSETOBJ]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ALMSETOBJ];CREATE SYNONYM [dbo].[T_ALMSETOBJ] FOR [default].[main_ac_x_215].[dbo].[T_ALMSETOBJ];
IF OBJECT_ID(N'[dbo].[T_ALMSMTPSET]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ALMSMTPSET];CREATE SYNONYM [dbo].[T_ALMSMTPSET] FOR [default].[main_ac_x_215].[dbo].[T_ALMSMTPSET];
IF OBJECT_ID(N'[dbo].[T_ALMSNDSET]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ALMSNDSET];CREATE SYNONYM [dbo].[T_ALMSNDSET] FOR [default].[main_ac_x_215].[dbo].[T_ALMSNDSET];
IF OBJECT_ID(N'[dbo].[T_APBBPACGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_APBBPACGR];CREATE SYNONYM [dbo].[T_APBBPACGR] FOR [default].[main_ac_x_215].[dbo].[T_APBBPACGR];
IF OBJECT_ID(N'[dbo].[T_AREA_INFO]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_AREA_INFO];CREATE SYNONYM [dbo].[T_AREA_INFO] FOR [default].[main_ac_x_215].[dbo].[T_AREA_INFO];
IF OBJECT_ID(N'[dbo].[T_ATMSYNDEVGRS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ATMSYNDEVGRS];CREATE SYNONYM [dbo].[T_ATMSYNDEVGRS] FOR [default].[main_ac_x_215].[dbo].[T_ATMSYNDEVGRS];
IF OBJECT_ID(N'[dbo].[T_ATMSYNDEVS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ATMSYNDEVS];CREATE SYNONYM [dbo].[T_ATMSYNDEVS] FOR [default].[main_ac_x_215].[dbo].[T_ATMSYNDEVS];
IF OBJECT_ID(N'[dbo].[T_AUDIT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_AUDIT];CREATE SYNONYM [dbo].[T_AUDIT] FOR [default].[main_ac_x_215].[dbo].[T_AUDIT];
IF OBJECT_ID(N'[dbo].[T_AUTHGRP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_AUTHGRP];CREATE SYNONYM [dbo].[T_AUTHGRP] FOR [default].[main_ac_x_215].[dbo].[T_AUTHGRP];
IF OBJECT_ID(N'[dbo].[T_BLKL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_BLKL];CREATE SYNONYM [dbo].[T_BLKL] FOR [default].[main_ac_x_215].[dbo].[T_BLKL];
IF OBJECT_ID(N'[dbo].[T_BZOUP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_BZOUP];CREATE SYNONYM [dbo].[T_BZOUP] FOR [default].[main_ac_x_215].[dbo].[T_BZOUP];
IF OBJECT_ID(N'[dbo].[T_CRD]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_CRD];CREATE SYNONYM [dbo].[T_CRD] FOR [default].[main_ac_x_215].[dbo].[T_CRD];
IF OBJECT_ID(N'[dbo].[T_CRDIDASM]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_CRDIDASM];CREATE SYNONYM [dbo].[T_CRDIDASM] FOR [default].[main_ac_x_215].[dbo].[T_CRDIDASM];
IF OBJECT_ID(N'[dbo].[T_CRDISSHIS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_CRDISSHIS];CREATE SYNONYM [dbo].[T_CRDISSHIS] FOR [default].[main_ac_x_215].[dbo].[T_CRDISSHIS];
IF OBJECT_ID(N'[dbo].[T_CRDLAY]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_CRDLAY];CREATE SYNONYM [dbo].[T_CRDLAY] FOR [default].[main_ac_x_215].[dbo].[T_CRDLAY];
IF OBJECT_ID(N'[dbo].[T_CRDLAY_FELICA]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_CRDLAY_FELICA];CREATE SYNONYM [dbo].[T_CRDLAY_FELICA] FOR [default].[main_ac_x_215].[dbo].[T_CRDLAY_FELICA];
IF OBJECT_ID(N'[dbo].[T_CRDMOACHIS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_CRDMOACHIS];CREATE SYNONYM [dbo].[T_CRDMOACHIS] FOR [default].[main_ac_x_215].[dbo].[T_CRDMOACHIS];
IF OBJECT_ID(N'[dbo].[T_CRDT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_CRDT];CREATE SYNONYM [dbo].[T_CRDT] FOR [default].[main_ac_x_215].[dbo].[T_CRDT];
IF OBJECT_ID(N'[dbo].[T_CRDTBIN]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_CRDTBIN];CREATE SYNONYM [dbo].[T_CRDTBIN] FOR [default].[main_ac_x_215].[dbo].[T_CRDTBIN];
IF OBJECT_ID(N'[dbo].[T_CRDTYP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_CRDTYP];CREATE SYNONYM [dbo].[T_CRDTYP] FOR [default].[main_ac_x_215].[dbo].[T_CRDTYP];
IF OBJECT_ID(N'[dbo].[T_CUSFLDTYP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_CUSFLDTYP];CREATE SYNONYM [dbo].[T_CUSFLDTYP] FOR [default].[main_ac_x_215].[dbo].[T_CUSFLDTYP];
IF OBJECT_ID(N'[dbo].[T_CUSFLDTYP_VST]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_CUSFLDTYP_VST];CREATE SYNONYM [dbo].[T_CUSFLDTYP_VST] FOR [default].[main_ac_x_215].[dbo].[T_CUSFLDTYP_VST];
IF OBJECT_ID(N'[dbo].[T_DASHBOARD_SETTING]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DASHBOARD_SETTING];CREATE SYNONYM [dbo].[T_DASHBOARD_SETTING] FOR [default].[main_ac_x_215].[dbo].[T_DASHBOARD_SETTING];
IF OBJECT_ID(N'[dbo].[T_DBLMDACSGRS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DBLMDACSGRS];CREATE SYNONYM [dbo].[T_DBLMDACSGRS] FOR [default].[main_ac_x_215].[dbo].[T_DBLMDACSGRS];
IF OBJECT_ID(N'[dbo].[T_DBLMDFLRGRS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DBLMDFLRGRS];CREATE SYNONYM [dbo].[T_DBLMDFLRGRS] FOR [default].[main_ac_x_215].[dbo].[T_DBLMDFLRGRS];
IF OBJECT_ID(N'[dbo].[T_DEV]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DEV];CREATE SYNONYM [dbo].[T_DEV] FOR [default].[main_ac_x_215].[dbo].[T_DEV];
IF OBJECT_ID(N'[dbo].[T_DEV_FLLR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DEV_FLLR];CREATE SYNONYM [dbo].[T_DEV_FLLR] FOR [default].[main_ac_x_215].[dbo].[T_DEV_FLLR];
IF OBJECT_ID(N'[dbo].[T_DEV3RDPRNT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DEV3RDPRNT];CREATE SYNONYM [dbo].[T_DEV3RDPRNT] FOR [default].[main_ac_x_215].[dbo].[T_DEV3RDPRNT];
IF OBJECT_ID(N'[dbo].[T_DEVCAP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DEVCAP];CREATE SYNONYM [dbo].[T_DEVCAP] FOR [default].[main_ac_x_215].[dbo].[T_DEVCAP];
IF OBJECT_ID(N'[dbo].[T_DEVCAPS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DEVCAPS];CREATE SYNONYM [dbo].[T_DEVCAPS] FOR [default].[main_ac_x_215].[dbo].[T_DEVCAPS];
IF OBJECT_ID(N'[dbo].[T_DEVCAPSFRDEV]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DEVCAPSFRDEV];CREATE SYNONYM [dbo].[T_DEVCAPSFRDEV] FOR [default].[main_ac_x_215].[dbo].[T_DEVCAPSFRDEV];
IF OBJECT_ID(N'[dbo].[T_DEVFORCECMD]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DEVFORCECMD];CREATE SYNONYM [dbo].[T_DEVFORCECMD] FOR [default].[main_ac_x_215].[dbo].[T_DEVFORCECMD];
IF OBJECT_ID(N'[dbo].[T_DEVGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DEVGR];CREATE SYNONYM [dbo].[T_DEVGR] FOR [default].[main_ac_x_215].[dbo].[T_DEVGR];
IF OBJECT_ID(N'[dbo].[T_DEVINACTIVE]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DEVINACTIVE];CREATE SYNONYM [dbo].[T_DEVINACTIVE] FOR [default].[main_ac_x_215].[dbo].[T_DEVINACTIVE];
IF OBJECT_ID(N'[dbo].[T_DEVOPRMD]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DEVOPRMD];CREATE SYNONYM [dbo].[T_DEVOPRMD] FOR [default].[main_ac_x_215].[dbo].[T_DEVOPRMD];
IF OBJECT_ID(N'[dbo].[T_DEVOPRT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DEVOPRT];CREATE SYNONYM [dbo].[T_DEVOPRT] FOR [default].[main_ac_x_215].[dbo].[T_DEVOPRT];
IF OBJECT_ID(N'[dbo].[T_DEVRS4CHNS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DEVRS4CHNS];CREATE SYNONYM [dbo].[T_DEVRS4CHNS] FOR [default].[main_ac_x_215].[dbo].[T_DEVRS4CHNS];
IF OBJECT_ID(N'[dbo].[T_DEVTHM]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DEVTHM];CREATE SYNONYM [dbo].[T_DEVTHM] FOR [default].[main_ac_x_215].[dbo].[T_DEVTHM];
IF OBJECT_ID(N'[dbo].[T_DEVTPOSDP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DEVTPOSDP];CREATE SYNONYM [dbo].[T_DEVTPOSDP] FOR [default].[main_ac_x_215].[dbo].[T_DEVTPOSDP];
IF OBJECT_ID(N'[dbo].[T_DEVTYP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DEVTYP];CREATE SYNONYM [dbo].[T_DEVTYP] FOR [default].[main_ac_x_215].[dbo].[T_DEVTYP];
IF OBJECT_ID(N'[dbo].[T_DEVWGD]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DEVWGD];CREATE SYNONYM [dbo].[T_DEVWGD] FOR [default].[main_ac_x_215].[dbo].[T_DEVWGD];
IF OBJECT_ID(N'[dbo].[T_DR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DR];CREATE SYNONYM [dbo].[T_DR] FOR [default].[main_ac_x_215].[dbo].[T_DR];
IF OBJECT_ID(N'[dbo].[T_DR_FLR_MAP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DR_FLR_MAP];CREATE SYNONYM [dbo].[T_DR_FLR_MAP] FOR [default].[main_ac_x_215].[dbo].[T_DR_FLR_MAP];
IF OBJECT_ID(N'[dbo].[T_DRGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DRGR];CREATE SYNONYM [dbo].[T_DRGR] FOR [default].[main_ac_x_215].[dbo].[T_DRGR];
IF OBJECT_ID(N'[dbo].[T_DRTRGACT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DRTRGACT];CREATE SYNONYM [dbo].[T_DRTRGACT] FOR [default].[main_ac_x_215].[dbo].[T_DRTRGACT];
IF OBJECT_ID(N'[dbo].[T_DRZN]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DRZN];CREATE SYNONYM [dbo].[T_DRZN] FOR [default].[main_ac_x_215].[dbo].[T_DRZN];
IF OBJECT_ID(N'[dbo].[T_DST]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_DST];CREATE SYNONYM [dbo].[T_DST] FOR [default].[main_ac_x_215].[dbo].[T_DST];
IF OBJECT_ID(N'[dbo].[T_ELVT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ELVT];CREATE SYNONYM [dbo].[T_ELVT] FOR [default].[main_ac_x_215].[dbo].[T_ELVT];
IF OBJECT_ID(N'[dbo].[T_ELVTDEVS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ELVTDEVS];CREATE SYNONYM [dbo].[T_ELVTDEVS] FOR [default].[main_ac_x_215].[dbo].[T_ELVTDEVS];
IF OBJECT_ID(N'[dbo].[T_ELVTGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ELVTGR];CREATE SYNONYM [dbo].[T_ELVTGR] FOR [default].[main_ac_x_215].[dbo].[T_ELVTGR];
IF OBJECT_ID(N'[dbo].[T_ELVTTRGACT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ELVTTRGACT];CREATE SYNONYM [dbo].[T_ELVTTRGACT] FOR [default].[main_ac_x_215].[dbo].[T_ELVTTRGACT];
IF OBJECT_ID(N'[dbo].[T_EMAIL_CONTENT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_EMAIL_CONTENT];CREATE SYNONYM [dbo].[T_EMAIL_CONTENT] FOR [default].[main_ac_x_215].[dbo].[T_EMAIL_CONTENT];
IF OBJECT_ID(N'[dbo].[T_EMLST]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_EMLST];CREATE SYNONYM [dbo].[T_EMLST] FOR [default].[main_ac_x_215].[dbo].[T_EMLST];
IF OBJECT_ID(N'[dbo].[T_ENCMGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ENCMGR];CREATE SYNONYM [dbo].[T_ENCMGR] FOR [default].[main_ac_x_215].[dbo].[T_ENCMGR];
IF OBJECT_ID(N'[dbo].[T_ERLDEV]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ERLDEV];CREATE SYNONYM [dbo].[T_ERLDEV] FOR [default].[main_ac_x_215].[dbo].[T_ERLDEV];
IF OBJECT_ID(N'[dbo].[T_ETRDEVS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ETRDEVS];CREATE SYNONYM [dbo].[T_ETRDEVS] FOR [default].[main_ac_x_215].[dbo].[T_ETRDEVS];
IF OBJECT_ID(N'[dbo].[T_EVTFLT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_EVTFLT];CREATE SYNONYM [dbo].[T_EVTFLT] FOR [default].[main_ac_x_215].[dbo].[T_EVTFLT];
IF OBJECT_ID(N'[dbo].[T_EVTPRIO]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_EVTPRIO];CREATE SYNONYM [dbo].[T_EVTPRIO] FOR [default].[main_ac_x_215].[dbo].[T_EVTPRIO];
IF OBJECT_ID(N'[dbo].[T_EVTPRIOALTDEVS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_EVTPRIOALTDEVS];CREATE SYNONYM [dbo].[T_EVTPRIOALTDEVS] FOR [default].[main_ac_x_215].[dbo].[T_EVTPRIOALTDEVS];
IF OBJECT_ID(N'[dbo].[T_EVTPRIOSND]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_EVTPRIOSND];CREATE SYNONYM [dbo].[T_EVTPRIOSND] FOR [default].[main_ac_x_215].[dbo].[T_EVTPRIOSND];
IF OBJECT_ID(N'[dbo].[T_EVTSPC]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_EVTSPC];CREATE SYNONYM [dbo].[T_EVTSPC] FOR [default].[main_ac_x_215].[dbo].[T_EVTSPC];
IF OBJECT_ID(N'[dbo].[T_EVTTYP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_EVTTYP];CREATE SYNONYM [dbo].[T_EVTTYP] FOR [default].[main_ac_x_215].[dbo].[T_EVTTYP];
IF OBJECT_ID(N'[dbo].[T_EVTTYP_GROUP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_EVTTYP_GROUP];CREATE SYNONYM [dbo].[T_EVTTYP_GROUP] FOR [default].[main_ac_x_215].[dbo].[T_EVTTYP_GROUP];
IF OBJECT_ID(N'[dbo].[T_EXDEVS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_EXDEVS];CREATE SYNONYM [dbo].[T_EXDEVS] FOR [default].[main_ac_x_215].[dbo].[T_EXDEVS];
IF OBJECT_ID(N'[dbo].[T_EXTSYS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_EXTSYS];CREATE SYNONYM [dbo].[T_EXTSYS] FOR [default].[main_ac_x_215].[dbo].[T_EXTSYS];
IF OBJECT_ID(N'[dbo].[T_FAILSYNCACSGRUPDATE]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FAILSYNCACSGRUPDATE];CREATE SYNONYM [dbo].[T_FAILSYNCACSGRUPDATE] FOR [default].[main_ac_x_215].[dbo].[T_FAILSYNCACSGRUPDATE];
IF OBJECT_ID(N'[dbo].[T_FAILSYNCACSLVLUPDATE]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FAILSYNCACSLVLUPDATE];CREATE SYNONYM [dbo].[T_FAILSYNCACSLVLUPDATE] FOR [default].[main_ac_x_215].[dbo].[T_FAILSYNCACSLVLUPDATE];
IF OBJECT_ID(N'[dbo].[T_FAILSYNCFLRLVLUPDATE]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FAILSYNCFLRLVLUPDATE];CREATE SYNONYM [dbo].[T_FAILSYNCFLRLVLUPDATE] FOR [default].[main_ac_x_215].[dbo].[T_FAILSYNCFLRLVLUPDATE];
IF OBJECT_ID(N'[dbo].[T_FAILSYNCUSRUPDATE]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FAILSYNCUSRUPDATE];CREATE SYNONYM [dbo].[T_FAILSYNCUSRUPDATE] FOR [default].[main_ac_x_215].[dbo].[T_FAILSYNCUSRUPDATE];
IF OBJECT_ID(N'[dbo].[T_FALDRGRS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FALDRGRS];CREATE SYNONYM [dbo].[T_FALDRGRS] FOR [default].[main_ac_x_215].[dbo].[T_FALDRGRS];
IF OBJECT_ID(N'[dbo].[T_FALDRS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FALDRS];CREATE SYNONYM [dbo].[T_FALDRS] FOR [default].[main_ac_x_215].[dbo].[T_FALDRS];
IF OBJECT_ID(N'[dbo].[T_FALELVTS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FALELVTS];CREATE SYNONYM [dbo].[T_FALELVTS] FOR [default].[main_ac_x_215].[dbo].[T_FALELVTS];
IF OBJECT_ID(N'[dbo].[T_FCLTY_INFO]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FCLTY_INFO];CREATE SYNONYM [dbo].[T_FCLTY_INFO] FOR [default].[main_ac_x_215].[dbo].[T_FCLTY_INFO];
IF OBJECT_ID(N'[dbo].[T_FCTMPL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FCTMPL];CREATE SYNONYM [dbo].[T_FCTMPL] FOR [default].[main_ac_x_215].[dbo].[T_FCTMPL];
IF OBJECT_ID(N'[dbo].[T_FLKBPACGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FLKBPACGR];CREATE SYNONYM [dbo].[T_FLKBPACGR] FOR [default].[main_ac_x_215].[dbo].[T_FLKBPACGR];
IF OBJECT_ID(N'[dbo].[T_FLKDRGRS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FLKDRGRS];CREATE SYNONYM [dbo].[T_FLKDRGRS] FOR [default].[main_ac_x_215].[dbo].[T_FLKDRGRS];
IF OBJECT_ID(N'[dbo].[T_FLKDRS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FLKDRS];CREATE SYNONYM [dbo].[T_FLKDRS] FOR [default].[main_ac_x_215].[dbo].[T_FLKDRS];
IF OBJECT_ID(N'[dbo].[T_FLKELVTS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FLKELVTS];CREATE SYNONYM [dbo].[T_FLKELVTS] FOR [default].[main_ac_x_215].[dbo].[T_FLKELVTS];
IF OBJECT_ID(N'[dbo].[T_FLR_INFO]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FLR_INFO];CREATE SYNONYM [dbo].[T_FLR_INFO] FOR [default].[main_ac_x_215].[dbo].[T_FLR_INFO];
IF OBJECT_ID(N'[dbo].[T_FLRGRLVLS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FLRGRLVLS];CREATE SYNONYM [dbo].[T_FLRGRLVLS] FOR [default].[main_ac_x_215].[dbo].[T_FLRGRLVLS];
IF OBJECT_ID(N'[dbo].[T_FLRLVL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FLRLVL];CREATE SYNONYM [dbo].[T_FLRLVL] FOR [default].[main_ac_x_215].[dbo].[T_FLRLVL];
IF OBJECT_ID(N'[dbo].[T_FLRLVLITM]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FLRLVLITM];CREATE SYNONYM [dbo].[T_FLRLVLITM] FOR [default].[main_ac_x_215].[dbo].[T_FLRLVLITM];
IF OBJECT_ID(N'[dbo].[T_FLRLVLITMELVTS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FLRLVLITMELVTS];CREATE SYNONYM [dbo].[T_FLRLVLITMELVTS] FOR [default].[main_ac_x_215].[dbo].[T_FLRLVLITMELVTS];
IF OBJECT_ID(N'[dbo].[T_FLRLVLITMS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FLRLVLITMS];CREATE SYNONYM [dbo].[T_FLRLVLITMS] FOR [default].[main_ac_x_215].[dbo].[T_FLRLVLITMS];
IF OBJECT_ID(N'[dbo].[T_FLRLVLSENT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FLRLVLSENT];CREATE SYNONYM [dbo].[T_FLRLVLSENT] FOR [default].[main_ac_x_215].[dbo].[T_FLRLVLSENT];
IF OBJECT_ID(N'[dbo].[T_FLRS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FLRS];CREATE SYNONYM [dbo].[T_FLRS] FOR [default].[main_ac_x_215].[dbo].[T_FLRS];
IF OBJECT_ID(N'[dbo].[T_FNGPTMPL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FNGPTMPL];CREATE SYNONYM [dbo].[T_FNGPTMPL] FOR [default].[main_ac_x_215].[dbo].[T_FNGPTMPL];
IF OBJECT_ID(N'[dbo].[T_FNGPTMPLVER]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FNGPTMPLVER];CREATE SYNONYM [dbo].[T_FNGPTMPLVER] FOR [default].[main_ac_x_215].[dbo].[T_FNGPTMPLVER];
IF OBJECT_ID(N'[dbo].[T_FULACGRS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FULACGRS];CREATE SYNONYM [dbo].[T_FULACGRS] FOR [default].[main_ac_x_215].[dbo].[T_FULACGRS];
IF OBJECT_ID(N'[dbo].[T_FULDRGRS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FULDRGRS];CREATE SYNONYM [dbo].[T_FULDRGRS] FOR [default].[main_ac_x_215].[dbo].[T_FULDRGRS];
IF OBJECT_ID(N'[dbo].[T_FULDRS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FULDRS];CREATE SYNONYM [dbo].[T_FULDRS] FOR [default].[main_ac_x_215].[dbo].[T_FULDRS];
IF OBJECT_ID(N'[dbo].[T_FULELVTS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_FULELVTS];CREATE SYNONYM [dbo].[T_FULELVTS] FOR [default].[main_ac_x_215].[dbo].[T_FULELVTS];
IF OBJECT_ID(N'[dbo].[T_GIS_DOOR_INFO]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_GIS_DOOR_INFO];CREATE SYNONYM [dbo].[T_GIS_DOOR_INFO] FOR [default].[main_ac_x_215].[dbo].[T_GIS_DOOR_INFO];
IF OBJECT_ID(N'[dbo].[T_GIS_VCM_INFO]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_GIS_VCM_INFO];CREATE SYNONYM [dbo].[T_GIS_VCM_INFO] FOR [default].[main_ac_x_215].[dbo].[T_GIS_VCM_INFO];
IF OBJECT_ID(N'[dbo].[T_GRM]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_GRM];CREATE SYNONYM [dbo].[T_GRM] FOR [default].[main_ac_x_215].[dbo].[T_GRM];
IF OBJECT_ID(N'[dbo].[T_GRMEL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_GRMEL];CREATE SYNONYM [dbo].[T_GRMEL] FOR [default].[main_ac_x_215].[dbo].[T_GRMEL];
IF OBJECT_ID(N'[dbo].[T_GRMELTYP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_GRMELTYP];CREATE SYNONYM [dbo].[T_GRMELTYP] FOR [default].[main_ac_x_215].[dbo].[T_GRMELTYP];
IF OBJECT_ID(N'[dbo].[T_GRMELVID]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_GRMELVID];CREATE SYNONYM [dbo].[T_GRMELVID] FOR [default].[main_ac_x_215].[dbo].[T_GRMELVID];
IF OBJECT_ID(N'[dbo].[T_GRMGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_GRMGR];CREATE SYNONYM [dbo].[T_GRMGR] FOR [default].[main_ac_x_215].[dbo].[T_GRMGR];
IF OBJECT_ID(N'[dbo].[T_HOL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_HOL];CREATE SYNONYM [dbo].[T_HOL] FOR [default].[main_ac_x_215].[dbo].[T_HOL];
IF OBJECT_ID(N'[dbo].[T_HOLGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_HOLGR];CREATE SYNONYM [dbo].[T_HOLGR] FOR [default].[main_ac_x_215].[dbo].[T_HOLGR];
IF OBJECT_ID(N'[dbo].[T_HOLSCH]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_HOLSCH];CREATE SYNONYM [dbo].[T_HOLSCH] FOR [default].[main_ac_x_215].[dbo].[T_HOLSCH];
IF OBJECT_ID(N'[dbo].[T_HOLSCHTMPRDS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_HOLSCHTMPRDS];CREATE SYNONYM [dbo].[T_HOLSCHTMPRDS] FOR [default].[main_ac_x_215].[dbo].[T_HOLSCHTMPRDS];
IF OBJECT_ID(N'[dbo].[T_IMGLGJB]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_IMGLGJB];CREATE SYNONYM [dbo].[T_IMGLGJB] FOR [default].[main_ac_x_215].[dbo].[T_IMGLGJB];
IF OBJECT_ID(N'[dbo].[T_INPCFG]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_INPCFG];CREATE SYNONYM [dbo].[T_INPCFG] FOR [default].[main_ac_x_215].[dbo].[T_INPCFG];
IF OBJECT_ID(N'[dbo].[T_INPCFGEX]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_INPCFGEX];CREATE SYNONYM [dbo].[T_INPCFGEX] FOR [default].[main_ac_x_215].[dbo].[T_INPCFGEX];
IF OBJECT_ID(N'[dbo].[T_LEDOUP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_LEDOUP];CREATE SYNONYM [dbo].[T_LEDOUP] FOR [default].[main_ac_x_215].[dbo].[T_LEDOUP];
IF OBJECT_ID(N'[dbo].[T_LGSERVEREVT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_LGSERVEREVT];CREATE SYNONYM [dbo].[T_LGSERVEREVT] FOR [default].[main_ac_x_215].[dbo].[T_LGSERVEREVT];
IF OBJECT_ID(N'[dbo].[T_LGTBIDX]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_LGTBIDX];CREATE SYNONYM [dbo].[T_LGTBIDX] FOR [default].[main_ac_x_215].[dbo].[T_LGTBIDX];
IF OBJECT_ID(N'[dbo].[T_LGUPDHIS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_LGUPDHIS];CREATE SYNONYM [dbo].[T_LGUPDHIS] FOR [default].[main_ac_x_215].[dbo].[T_LGUPDHIS];
IF OBJECT_ID(N'[dbo].[T_LICENSES]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_LICENSES];CREATE SYNONYM [dbo].[T_LICENSES] FOR [default].[main_ac_x_215].[dbo].[T_LICENSES];
IF OBJECT_ID(N'[dbo].[T_LSTLOG]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_LSTLOG];CREATE SYNONYM [dbo].[T_LSTLOG] FOR [default].[main_ac_x_215].[dbo].[T_LSTLOG];
IF OBJECT_ID(N'[dbo].[T_LSTSYNSTA]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_LSTSYNSTA];CREATE SYNONYM [dbo].[T_LSTSYNSTA] FOR [default].[main_ac_x_215].[dbo].[T_LSTSYNSTA];
IF OBJECT_ID(N'[dbo].[T_LSTUSRAUTH]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_LSTUSRAUTH];CREATE SYNONYM [dbo].[T_LSTUSRAUTH] FOR [default].[main_ac_x_215].[dbo].[T_LSTUSRAUTH];
IF OBJECT_ID(N'[dbo].[T_LULACGRS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_LULACGRS];CREATE SYNONYM [dbo].[T_LULACGRS] FOR [default].[main_ac_x_215].[dbo].[T_LULACGRS];
IF OBJECT_ID(N'[dbo].[T_MBLCRD]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_MBLCRD];CREATE SYNONYM [dbo].[T_MBLCRD] FOR [default].[main_ac_x_215].[dbo].[T_MBLCRD];
IF OBJECT_ID(N'[dbo].[T_MOBILE_CREDENTIAL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_MOBILE_CREDENTIAL];CREATE SYNONYM [dbo].[T_MOBILE_CREDENTIAL] FOR [default].[main_ac_x_215].[dbo].[T_MOBILE_CREDENTIAL];
IF OBJECT_ID(N'[dbo].[T_MOBILE_PICTURE_HASH]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_MOBILE_PICTURE_HASH];CREATE SYNONYM [dbo].[T_MOBILE_PICTURE_HASH] FOR [default].[main_ac_x_215].[dbo].[T_MOBILE_PICTURE_HASH];
IF OBJECT_ID(N'[dbo].[T_MXDT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_MXDT];CREATE SYNONYM [dbo].[T_MXDT] FOR [default].[main_ac_x_215].[dbo].[T_MXDT];
IF OBJECT_ID(N'[dbo].[T_NESTED_DEV]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_NESTED_DEV];CREATE SYNONYM [dbo].[T_NESTED_DEV] FOR [default].[main_ac_x_215].[dbo].[T_NESTED_DEV];
IF OBJECT_ID(N'[dbo].[T_NESTED_DEVGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_NESTED_DEVGR];CREATE SYNONYM [dbo].[T_NESTED_DEVGR] FOR [default].[main_ac_x_215].[dbo].[T_NESTED_DEVGR];
IF OBJECT_ID(N'[dbo].[T_NESTED_DRGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_NESTED_DRGR];CREATE SYNONYM [dbo].[T_NESTED_DRGR] FOR [default].[main_ac_x_215].[dbo].[T_NESTED_DRGR];
IF OBJECT_ID(N'[dbo].[T_NESTED_ELVTGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_NESTED_ELVTGR];CREATE SYNONYM [dbo].[T_NESTED_ELVTGR] FOR [default].[main_ac_x_215].[dbo].[T_NESTED_ELVTGR];
IF OBJECT_ID(N'[dbo].[T_NESTED_GRMGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_NESTED_GRMGR];CREATE SYNONYM [dbo].[T_NESTED_GRMGR] FOR [default].[main_ac_x_215].[dbo].[T_NESTED_GRMGR];
IF OBJECT_ID(N'[dbo].[T_NESTED_USRGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_NESTED_USRGR];CREATE SYNONYM [dbo].[T_NESTED_USRGR] FOR [default].[main_ac_x_215].[dbo].[T_NESTED_USRGR];
IF OBJECT_ID(N'[dbo].[T_NTC]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_NTC];CREATE SYNONYM [dbo].[T_NTC] FOR [default].[main_ac_x_215].[dbo].[T_NTC];
IF OBJECT_ID(N'[dbo].[T_OCCPBPACGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_OCCPBPACGR];CREATE SYNONYM [dbo].[T_OCCPBPACGR] FOR [default].[main_ac_x_215].[dbo].[T_OCCPBPACGR];
IF OBJECT_ID(N'[dbo].[T_OUPSIG]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_OUPSIG];CREATE SYNONYM [dbo].[T_OUPSIG] FOR [default].[main_ac_x_215].[dbo].[T_OUPSIG];
IF OBJECT_ID(N'[dbo].[T_PERM]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_PERM];CREATE SYNONYM [dbo].[T_PERM] FOR [default].[main_ac_x_215].[dbo].[T_PERM];
IF OBJECT_ID(N'[dbo].[T_POLYGON_INFO]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_POLYGON_INFO];CREATE SYNONYM [dbo].[T_POLYGON_INFO] FOR [default].[main_ac_x_215].[dbo].[T_POLYGON_INFO];
IF OBJECT_ID(N'[dbo].[T_PRF]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_PRF];CREATE SYNONYM [dbo].[T_PRF] FOR [default].[main_ac_x_215].[dbo].[T_PRF];
IF OBJECT_ID(N'[dbo].[T_QCACT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_QCACT];CREATE SYNONYM [dbo].[T_QCACT] FOR [default].[main_ac_x_215].[dbo].[T_QCACT];
IF OBJECT_ID(N'[dbo].[T_QCACTALM]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_QCACTALM];CREATE SYNONYM [dbo].[T_QCACTALM] FOR [default].[main_ac_x_215].[dbo].[T_QCACTALM];
IF OBJECT_ID(N'[dbo].[T_QCACTPERM]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_QCACTPERM];CREATE SYNONYM [dbo].[T_QCACTPERM] FOR [default].[main_ac_x_215].[dbo].[T_QCACTPERM];
IF OBJECT_ID(N'[dbo].[T_REPORT_EXPORT_SETTING]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_REPORT_EXPORT_SETTING];CREATE SYNONYM [dbo].[T_REPORT_EXPORT_SETTING] FOR [default].[main_ac_x_215].[dbo].[T_REPORT_EXPORT_SETTING];
IF OBJECT_ID(N'[dbo].[T_REPORT_PRINT_SETTING]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_REPORT_PRINT_SETTING];CREATE SYNONYM [dbo].[T_REPORT_PRINT_SETTING] FOR [default].[main_ac_x_215].[dbo].[T_REPORT_PRINT_SETTING];
IF OBJECT_ID(N'[dbo].[T_REPORT_SCHEDULES]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_REPORT_SCHEDULES];CREATE SYNONYM [dbo].[T_REPORT_SCHEDULES] FOR [default].[main_ac_x_215].[dbo].[T_REPORT_SCHEDULES];
IF OBJECT_ID(N'[dbo].[T_REPORT_SETTING]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_REPORT_SETTING];CREATE SYNONYM [dbo].[T_REPORT_SETTING] FOR [default].[main_ac_x_215].[dbo].[T_REPORT_SETTING];
IF OBJECT_ID(N'[dbo].[T_REPORT_TEMPLATE]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_REPORT_TEMPLATE];CREATE SYNONYM [dbo].[T_REPORT_TEMPLATE] FOR [default].[main_ac_x_215].[dbo].[T_REPORT_TEMPLATE];
IF OBJECT_ID(N'[dbo].[T_REPORT_TEMPLATE_GROUP_FILTER]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_REPORT_TEMPLATE_GROUP_FILTER];CREATE SYNONYM [dbo].[T_REPORT_TEMPLATE_GROUP_FILTER] FOR [default].[main_ac_x_215].[dbo].[T_REPORT_TEMPLATE_GROUP_FILTER];
IF OBJECT_ID(N'[dbo].[T_REPORT_TEMPLATE_USER_FILTER]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_REPORT_TEMPLATE_USER_FILTER];CREATE SYNONYM [dbo].[T_REPORT_TEMPLATE_USER_FILTER] FOR [default].[main_ac_x_215].[dbo].[T_REPORT_TEMPLATE_USER_FILTER];
IF OBJECT_ID(N'[dbo].[T_REPORTTEMPID]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_REPORTTEMPID];CREATE SYNONYM [dbo].[T_REPORTTEMPID] FOR [default].[main_ac_x_215].[dbo].[T_REPORTTEMPID];
IF OBJECT_ID(N'[dbo].[T_REPORTTEMPID_HEADER]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_REPORTTEMPID_HEADER];CREATE SYNONYM [dbo].[T_REPORTTEMPID_HEADER] FOR [default].[main_ac_x_215].[dbo].[T_REPORTTEMPID_HEADER];
IF OBJECT_ID(N'[dbo].[T_RMJB]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_RMJB];CREATE SYNONYM [dbo].[T_RMJB] FOR [default].[main_ac_x_215].[dbo].[T_RMJB];
IF OBJECT_ID(N'[dbo].[T_RMJBEV]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_RMJBEV];CREATE SYNONYM [dbo].[T_RMJBEV] FOR [default].[main_ac_x_215].[dbo].[T_RMJBEV];
IF OBJECT_ID(N'[dbo].[T_RMJBZN]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_RMJBZN];CREATE SYNONYM [dbo].[T_RMJBZN] FOR [default].[main_ac_x_215].[dbo].[T_RMJBZN];
IF OBJECT_ID(N'[dbo].[T_SCH]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_SCH];CREATE SYNONYM [dbo].[T_SCH] FOR [default].[main_ac_x_215].[dbo].[T_SCH];
IF OBJECT_ID(N'[dbo].[T_SCHDL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_SCHDL];CREATE SYNONYM [dbo].[T_SCHDL] FOR [default].[main_ac_x_215].[dbo].[T_SCHDL];
IF OBJECT_ID(N'[dbo].[T_SCHDLTMPRDS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_SCHDLTMPRDS];CREATE SYNONYM [dbo].[T_SCHDLTMPRDS] FOR [default].[main_ac_x_215].[dbo].[T_SCHDLTMPRDS];
IF OBJECT_ID(N'[dbo].[T_SHF]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_SHF];CREATE SYNONYM [dbo].[T_SHF] FOR [default].[main_ac_x_215].[dbo].[T_SHF];
IF OBJECT_ID(N'[dbo].[T_SHFGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_SHFGR];CREATE SYNONYM [dbo].[T_SHFGR] FOR [default].[main_ac_x_215].[dbo].[T_SHFGR];
IF OBJECT_ID(N'[dbo].[T_SHFGRSHFS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_SHFGRSHFS];CREATE SYNONYM [dbo].[T_SHFGRSHFS] FOR [default].[main_ac_x_215].[dbo].[T_SHFGRSHFS];
IF OBJECT_ID(N'[dbo].[T_SHFGRUSS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_SHFGRUSS];CREATE SYNONYM [dbo].[T_SHFGRUSS] FOR [default].[main_ac_x_215].[dbo].[T_SHFGRUSS];
IF OBJECT_ID(N'[dbo].[T_SHFRUL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_SHFRUL];CREATE SYNONYM [dbo].[T_SHFRUL] FOR [default].[main_ac_x_215].[dbo].[T_SHFRUL];
IF OBJECT_ID(N'[dbo].[T_SHFTMPLSHFS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_SHFTMPLSHFS];CREATE SYNONYM [dbo].[T_SHFTMPLSHFS] FOR [default].[main_ac_x_215].[dbo].[T_SHFTMPLSHFS];
IF OBJECT_ID(N'[dbo].[T_SND]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_SND];CREATE SYNONYM [dbo].[T_SND] FOR [default].[main_ac_x_215].[dbo].[T_SND];
IF OBJECT_ID(N'[dbo].[T_SRVSTA]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_SRVSTA];CREATE SYNONYM [dbo].[T_SRVSTA] FOR [default].[main_ac_x_215].[dbo].[T_SRVSTA];
IF OBJECT_ID(N'[dbo].[T_SYNCTAPB]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_SYNCTAPB];CREATE SYNONYM [dbo].[T_SYNCTAPB] FOR [default].[main_ac_x_215].[dbo].[T_SYNCTAPB];
IF OBJECT_ID(N'[dbo].[T_SYSCFG]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_SYSCFG];CREATE SYNONYM [dbo].[T_SYSCFG] FOR [default].[main_ac_x_215].[dbo].[T_SYSCFG];
IF OBJECT_ID(N'[dbo].[T_TAKEY]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_TAKEY];CREATE SYNONYM [dbo].[T_TAKEY] FOR [default].[main_ac_x_215].[dbo].[T_TAKEY];
IF OBJECT_ID(N'[dbo].[T_TMAPBBPACGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_TMAPBBPACGR];CREATE SYNONYM [dbo].[T_TMAPBBPACGR] FOR [default].[main_ac_x_215].[dbo].[T_TMAPBBPACGR];
IF OBJECT_ID(N'[dbo].[T_TMPRD]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_TMPRD];CREATE SYNONYM [dbo].[T_TMPRD] FOR [default].[main_ac_x_215].[dbo].[T_TMPRD];
IF OBJECT_ID(N'[dbo].[T_TRGACT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_TRGACT];CREATE SYNONYM [dbo].[T_TRGACT] FOR [default].[main_ac_x_215].[dbo].[T_TRGACT];
IF OBJECT_ID(N'[dbo].[T_USERSENT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_USERSENT];CREATE SYNONYM [dbo].[T_USERSENT] FOR [default].[main_ac_x_215].[dbo].[T_USERSENT];
IF OBJECT_ID(N'[dbo].[T_USR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_USR];CREATE SYNONYM [dbo].[T_USR] FOR [default].[main_ac_x_215].[dbo].[T_USR];
IF OBJECT_ID(N'[dbo].[T_USR_PHRASE]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_USR_PHRASE];CREATE SYNONYM [dbo].[T_USR_PHRASE] FOR [default].[main_ac_x_215].[dbo].[T_USR_PHRASE];
IF OBJECT_ID(N'[dbo].[T_USRACSGRTMPL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_USRACSGRTMPL];CREATE SYNONYM [dbo].[T_USRACSGRTMPL] FOR [default].[main_ac_x_215].[dbo].[T_USRACSGRTMPL];
IF OBJECT_ID(N'[dbo].[T_USRCRD]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_USRCRD];CREATE SYNONYM [dbo].[T_USRCRD] FOR [default].[main_ac_x_215].[dbo].[T_USRCRD];
IF OBJECT_ID(N'[dbo].[T_USRCUSFLD]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_USRCUSFLD];CREATE SYNONYM [dbo].[T_USRCUSFLD] FOR [default].[main_ac_x_215].[dbo].[T_USRCUSFLD];
IF OBJECT_ID(N'[dbo].[T_USRCUSFLDTMPL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_USRCUSFLDTMPL];CREATE SYNONYM [dbo].[T_USRCUSFLDTMPL] FOR [default].[main_ac_x_215].[dbo].[T_USRCUSFLDTMPL];
IF OBJECT_ID(N'[dbo].[T_USRGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_USRGR];CREATE SYNONYM [dbo].[T_USRGR] FOR [default].[main_ac_x_215].[dbo].[T_USRGR];
IF OBJECT_ID(N'[dbo].[T_USRGR_ORDER]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_USRGR_ORDER];CREATE SYNONYM [dbo].[T_USRGR_ORDER] FOR [default].[main_ac_x_215].[dbo].[T_USRGR_ORDER];
IF OBJECT_ID(N'[dbo].[T_USRMSKSYN]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_USRMSKSYN];CREATE SYNONYM [dbo].[T_USRMSKSYN] FOR [default].[main_ac_x_215].[dbo].[T_USRMSKSYN];
IF OBJECT_ID(N'[dbo].[T_USROPRMD]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_USROPRMD];CREATE SYNONYM [dbo].[T_USROPRMD] FOR [default].[main_ac_x_215].[dbo].[T_USROPRMD];
IF OBJECT_ID(N'[dbo].[T_USRPHOTO]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_USRPHOTO];CREATE SYNONYM [dbo].[T_USRPHOTO] FOR [default].[main_ac_x_215].[dbo].[T_USRPHOTO];
IF OBJECT_ID(N'[dbo].[T_USRTMPL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_USRTMPL];CREATE SYNONYM [dbo].[T_USRTMPL] FOR [default].[main_ac_x_215].[dbo].[T_USRTMPL];
IF OBJECT_ID(N'[dbo].[T_VCM_FLR_MAP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_VCM_FLR_MAP];CREATE SYNONYM [dbo].[T_VCM_FLR_MAP] FOR [default].[main_ac_x_215].[dbo].[T_VCM_FLR_MAP];
IF OBJECT_ID(N'[dbo].[T_VDEV]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_VDEV];CREATE SYNONYM [dbo].[T_VDEV] FOR [default].[main_ac_x_215].[dbo].[T_VDEV];
IF OBJECT_ID(N'[dbo].[T_VIPPHBKS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_VIPPHBKS];CREATE SYNONYM [dbo].[T_VIPPHBKS] FOR [default].[main_ac_x_215].[dbo].[T_VIPPHBKS];
IF OBJECT_ID(N'[dbo].[T_VISIT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_VISIT];CREATE SYNONYM [dbo].[T_VISIT] FOR [default].[main_ac_x_215].[dbo].[T_VISIT];
IF OBJECT_ID(N'[dbo].[T_VISITACSGRMAP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_VISITACSGRMAP];CREATE SYNONYM [dbo].[T_VISITACSGRMAP] FOR [default].[main_ac_x_215].[dbo].[T_VISITACSGRMAP];
IF OBJECT_ID(N'[dbo].[T_VISITCUSFLD]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_VISITCUSFLD];CREATE SYNONYM [dbo].[T_VISITCUSFLD] FOR [default].[main_ac_x_215].[dbo].[T_VISITCUSFLD];
IF OBJECT_ID(N'[dbo].[T_VISITFNGPTMPL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_VISITFNGPTMPL];CREATE SYNONYM [dbo].[T_VISITFNGPTMPL] FOR [default].[main_ac_x_215].[dbo].[T_VISITFNGPTMPL];
IF OBJECT_ID(N'[dbo].[T_VISITFNGPTMPLVER]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_VISITFNGPTMPLVER];CREATE SYNONYM [dbo].[T_VISITFNGPTMPLVER] FOR [default].[main_ac_x_215].[dbo].[T_VISITFNGPTMPLVER];
IF OBJECT_ID(N'[dbo].[T_VISITORTERMINAL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_VISITORTERMINAL];CREATE SYNONYM [dbo].[T_VISITORTERMINAL] FOR [default].[main_ac_x_215].[dbo].[T_VISITORTERMINAL];
IF OBJECT_ID(N'[dbo].[T_VISITORTERMINALACGROUPMAP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_VISITORTERMINALACGROUPMAP];CREATE SYNONYM [dbo].[T_VISITORTERMINALACGROUPMAP] FOR [default].[main_ac_x_215].[dbo].[T_VISITORTERMINALACGROUPMAP];
IF OBJECT_ID(N'[dbo].[T_VISITORTERMINALREGION]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_VISITORTERMINALREGION];CREATE SYNONYM [dbo].[T_VISITORTERMINALREGION] FOR [default].[main_ac_x_215].[dbo].[T_VISITORTERMINALREGION];
IF OBJECT_ID(N'[dbo].[T_VISITORTERMINALREGIONMAP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_VISITORTERMINALREGIONMAP];CREATE SYNONYM [dbo].[T_VISITORTERMINALREGIONMAP] FOR [default].[main_ac_x_215].[dbo].[T_VISITORTERMINALREGIONMAP];
IF OBJECT_ID(N'[dbo].[T_VISITORTERMS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_VISITORTERMS];CREATE SYNONYM [dbo].[T_VISITORTERMS] FOR [default].[main_ac_x_215].[dbo].[T_VISITORTERMS];
IF OBJECT_ID(N'[dbo].[T_WGDBZ]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_WGDBZ];CREATE SYNONYM [dbo].[T_WGDBZ] FOR [default].[main_ac_x_215].[dbo].[T_WGDBZ];
IF OBJECT_ID(N'[dbo].[T_WGDFMT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_WGDFMT];CREATE SYNONYM [dbo].[T_WGDFMT] FOR [default].[main_ac_x_215].[dbo].[T_WGDFMT];
IF OBJECT_ID(N'[dbo].[T_WGDLED]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_WGDLED];CREATE SYNONYM [dbo].[T_WGDLED] FOR [default].[main_ac_x_215].[dbo].[T_WGDLED];
IF OBJECT_ID(N'[dbo].[T_WGDTMPR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_WGDTMPR];CREATE SYNONYM [dbo].[T_WGDTMPR] FOR [default].[main_ac_x_215].[dbo].[T_WGDTMPR];
IF OBJECT_ID(N'[dbo].[T_WIDGET]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_WIDGET];CREATE SYNONYM [dbo].[T_WIDGET] FOR [default].[main_ac_x_215].[dbo].[T_WIDGET];
IF OBJECT_ID(N'[dbo].[T_ZN]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZN];CREATE SYNONYM [dbo].[T_ZN] FOR [default].[main_ac_x_215].[dbo].[T_ZN];
IF OBJECT_ID(N'[dbo].[T_ZNACSGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNACSGR];CREATE SYNONYM [dbo].[T_ZNACSGR] FOR [default].[main_ac_x_215].[dbo].[T_ZNACSGR];
IF OBJECT_ID(N'[dbo].[T_ZNAPB]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNAPB];CREATE SYNONYM [dbo].[T_ZNAPB] FOR [default].[main_ac_x_215].[dbo].[T_ZNAPB];
IF OBJECT_ID(N'[dbo].[T_ZNAPBUSRIO]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNAPBUSRIO];CREATE SYNONYM [dbo].[T_ZNAPBUSRIO] FOR [default].[main_ac_x_215].[dbo].[T_ZNAPBUSRIO];
IF OBJECT_ID(N'[dbo].[T_ZNCRD]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNCRD];CREATE SYNONYM [dbo].[T_ZNCRD] FOR [default].[main_ac_x_215].[dbo].[T_ZNCRD];
IF OBJECT_ID(N'[dbo].[T_ZNDR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNDR];CREATE SYNONYM [dbo].[T_ZNDR] FOR [default].[main_ac_x_215].[dbo].[T_ZNDR];
IF OBJECT_ID(N'[dbo].[T_ZNELVT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNELVT];CREATE SYNONYM [dbo].[T_ZNELVT] FOR [default].[main_ac_x_215].[dbo].[T_ZNELVT];
IF OBJECT_ID(N'[dbo].[T_ZNFAL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNFAL];CREATE SYNONYM [dbo].[T_ZNFAL] FOR [default].[main_ac_x_215].[dbo].[T_ZNFAL];
IF OBJECT_ID(N'[dbo].[T_ZNFALINPSNS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNFALINPSNS];CREATE SYNONYM [dbo].[T_ZNFALINPSNS] FOR [default].[main_ac_x_215].[dbo].[T_ZNFALINPSNS];
IF OBJECT_ID(N'[dbo].[T_ZNFLK]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNFLK];CREATE SYNONYM [dbo].[T_ZNFLK] FOR [default].[main_ac_x_215].[dbo].[T_ZNFLK];
IF OBJECT_ID(N'[dbo].[T_ZNFLRS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNFLRS];CREATE SYNONYM [dbo].[T_ZNFLRS] FOR [default].[main_ac_x_215].[dbo].[T_ZNFLRS];
IF OBJECT_ID(N'[dbo].[T_ZNFUL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNFUL];CREATE SYNONYM [dbo].[T_ZNFUL] FOR [default].[main_ac_x_215].[dbo].[T_ZNFUL];
IF OBJECT_ID(N'[dbo].[T_ZNINP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNINP];CREATE SYNONYM [dbo].[T_ZNINP] FOR [default].[main_ac_x_215].[dbo].[T_ZNINP];
IF OBJECT_ID(N'[dbo].[T_ZNITAL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNITAL];CREATE SYNONYM [dbo].[T_ZNITAL] FOR [default].[main_ac_x_215].[dbo].[T_ZNITAL];
IF OBJECT_ID(N'[dbo].[T_ZNLUL]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNLUL];CREATE SYNONYM [dbo].[T_ZNLUL] FOR [default].[main_ac_x_215].[dbo].[T_ZNLUL];
IF OBJECT_ID(N'[dbo].[T_ZNMST]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNMST];CREATE SYNONYM [dbo].[T_ZNMST] FOR [default].[main_ac_x_215].[dbo].[T_ZNMST];
IF OBJECT_ID(N'[dbo].[T_ZNOCCP]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNOCCP];CREATE SYNONYM [dbo].[T_ZNOCCP] FOR [default].[main_ac_x_215].[dbo].[T_ZNOCCP];
IF OBJECT_ID(N'[dbo].[T_ZNOCCP_LSTUSREVT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNOCCP_LSTUSREVT];CREATE SYNONYM [dbo].[T_ZNOCCP_LSTUSREVT] FOR [default].[main_ac_x_215].[dbo].[T_ZNOCCP_LSTUSREVT];
IF OBJECT_ID(N'[dbo].[T_ZNRC]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNRC];CREATE SYNONYM [dbo].[T_ZNRC] FOR [default].[main_ac_x_215].[dbo].[T_ZNRC];
IF OBJECT_ID(N'[dbo].[T_ZNRCHIS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNRCHIS];CREATE SYNONYM [dbo].[T_ZNRCHIS] FOR [default].[main_ac_x_215].[dbo].[T_ZNRCHIS];
IF OBJECT_ID(N'[dbo].[T_ZNRCTRCK]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNRCTRCK];CREATE SYNONYM [dbo].[T_ZNRCTRCK] FOR [default].[main_ac_x_215].[dbo].[T_ZNRCTRCK];
IF OBJECT_ID(N'[dbo].[T_ZNTAPB]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNTAPB];CREATE SYNONYM [dbo].[T_ZNTAPB] FOR [default].[main_ac_x_215].[dbo].[T_ZNTAPB];
IF OBJECT_ID(N'[dbo].[T_ZNTMAPB]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNTMAPB];CREATE SYNONYM [dbo].[T_ZNTMAPB] FOR [default].[main_ac_x_215].[dbo].[T_ZNTMAPB];
IF OBJECT_ID(N'[dbo].[T_ZNTRCK]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNTRCK];CREATE SYNONYM [dbo].[T_ZNTRCK] FOR [default].[main_ac_x_215].[dbo].[T_ZNTRCK];
IF OBJECT_ID(N'[dbo].[T_ZNTRGACT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNTRGACT];CREATE SYNONYM [dbo].[T_ZNTRGACT] FOR [default].[main_ac_x_215].[dbo].[T_ZNTRGACT];
IF OBJECT_ID(N'[dbo].[T_ZNUSR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ZNUSR];CREATE SYNONYM [dbo].[T_ZNUSR] FOR [default].[main_ac_x_215].[dbo].[T_ZNUSR];
IF OBJECT_ID(N'[dbo].[TEMP_ACSGRUSR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[TEMP_ACSGRUSR];CREATE SYNONYM [dbo].[TEMP_ACSGRUSR] FOR [default].[main_ac_x_215].[dbo].[TEMP_ACSGRUSR];
IF OBJECT_ID(N'[dbo].[TEMP_DOUBLEAUTHUSR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[TEMP_DOUBLEAUTHUSR];CREATE SYNONYM [dbo].[TEMP_DOUBLEAUTHUSR] FOR [default].[main_ac_x_215].[dbo].[TEMP_DOUBLEAUTHUSR];
IF OBJECT_ID(N'[dbo].[TEMP_OPERATOR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[TEMP_OPERATOR];CREATE SYNONYM [dbo].[TEMP_OPERATOR] FOR [default].[main_ac_x_215].[dbo].[TEMP_OPERATOR];

Ejecutar la consulta en la base de datos auxiliar.

Copia por completo la consulta CREATE SYNONYM generada previamente. Conéctate al servidor de base de datos auxiliar que se va a agregar, escribe la consulta como se muestra a continuación y ejecútala. Se almacenará en Synonyms del esquema AC de la base de datos auxiliar.

use [<Sub DB AC Database>];

IF OBJECT_ID(N'[dbo].[T_ACSGR]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ACSGR];CREATE SYNONYM [dbo].[T_ACSGR] FOR [default].[main_ac_x_215].[dbo].[T_ACSGR];
IF OBJECT_ID(N'[dbo].[T_ACSGRLVLS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ACSGRLVLS];CREATE SYNONYM [dbo].[T_ACSGRLVLS] FOR [default].[main_ac_x_215].[dbo].[T_ACSGRLVLS];
IF OBJECT_ID(N'[dbo].[T_ACSGRSENT]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ACSGRSENT];CREATE SYNONYM [dbo].[T_ACSGRSENT] FOR [default].[main_ac_x_215].[dbo].[T_ACSGRSENT];
IF OBJECT_ID(N'[dbo].[T_ACSGRUSS]', 'SN') IS NOT NULL DROP SYNONYM [dbo].[T_ACSGRUSS];CREATE SYNONYM [dbo].[T_ACSGRUSS] FOR [default].[main_ac_x_215].[dbo].[T_ACSGRUSS];
...