Under Review

Apex SQL Complete - Ability to duplicate table aliases (for multiple servers/dbs) and update existing aliases in mass

Hi,

I am new to the product and forum so I apologize if this has been addressed previously or there is already a way to do this. I want to be able to duplicate table aliases for multiple servers/dbs. We have several servers (i.e. PROD,TEST,REPORT) that have the same tables. Is there a way to duplicate the aliases so that I don't have to manually create them for each one? Also, if we migrate our dbs to new servers, is there a way to update all of my aliases in an automated fashion?

Thank you,

Mike

mparker
Parents
  • Unknown
    Unknown

    Currently, ApexSQL Complete doesn’t provide a direct way to duplicate table aliases across multiple servers/databases. One workaround is to export your aliases to an XML or configuration file and then import them into another server/database, though this may require manual adjustments. For updating aliases after migrating databases, the same export/import method can help, but there’s no fully automated bulk update feature built into the tool yet. You might consider submitting this as a feature request to ApexSQL for future releases.

Comment
  • Unknown
    Unknown

    Currently, ApexSQL Complete doesn’t provide a direct way to duplicate table aliases across multiple servers/databases. One workaround is to export your aliases to an XML or configuration file and then import them into another server/database, though this may require manual adjustments. For updating aliases after migrating databases, the same export/import method can help, but there’s no fully automated bulk update feature built into the tool yet. You might consider submitting this as a feature request to ApexSQL for future releases.

Children
No Data