How to save chat history in SQL Server

To save chat history in SQL Server you need to do the following:

For version 3.2 and above

1. Download the Squiggle-X.X Scripts.zip and extract it
2. Open Squiggle.exe.config in notepad
3. Copy the contents of ConnectionString.txt file and replace them in Squiggle.exe.config
4. Adjust the connection string parameters i.e. username/password, server, etc. according to your environment
5. Connect to SQL Server using management console and create the history database using SquiggleHistory.sql file
6. Now run Squiggle and enable status and chat history. Your history will be logged in SQL Server

For version 3.1 and earlier

1. Download the Squiggle-X.X Scripts.zip and extract it
2. Copy the HistoryEntities.Sql.ssdl file into Squiggle folder (Where Squiggle.exe is located)
3. Open Squiggle.exe.config in notepad
4. Copy the contents of ConnectionString.txt file and replace them in Squiggle.exe.config
5. Adjust the connection string parameters i.e. username/password, server, etc. according to your environment
6. Connect to SQL Server using management console and create the history database using SquiggleHistory.sql file
7. Now run Squiggle and enable status and chat history. Your history will be logged in SQL Server