If you are creating a GlobalSearch list with a small number of entries, it is easy to create the list using just the GlobalSearch client. If you are creating a list based on a SQL database, using an Assembly Bound list is often a viable solution as well. However, if you want to create a more permanent list with a large number of values that is not dynamically updated, or add a large number of values to an existing list, then doing a bulk import may be easier.

...

The steps in this article can cause irreversible damage to your database if followed improperly. Make sure you back up your SQL database prior to beginning. If you have any questions about your current SQL backup plan, please consult your database administrator or IT. For more information about backing up your GlobalSearch databases, please consult the following documentation:

http://knowledge.square-9.com/display/public/GSW45/Back+Up+GlobalSearch

Ensure the Import and Export Wizard is installed

The Import and Export Wizard is included with the SQL Server Data Tools (SSDT). Chances are, if you have SQL Server Management Studio, you have the Import and Export Wizard installed as well. If you need to download it, consult the following link:

https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017

Make sure you already have the list in GlobalSearch

...

For more information about creating GlobalSearch lists, please consult the following documentation:

http://knowledge.square-9.com/display/public/GSW45/Create+Field+Lists

Step 1: Get the list IDs for the lists you want to update.

...