How to move a file based database to a SQL Server?

Question

We're currently running SDL Trados Studio using the File Based database option. We would like to move it to our SQL Server. What is the procedure? 
 
 Thank you

Lydia Simplicio · Answer

Hi Marc Pelletier 
 So that I understand you correctly, you are looking to store your TM's on a SQL db- and not Studio (which must to be installed on your local client) so that you can collaborate more easily with in-house/external translators? 
 If this is the case, the best (only?) solution I believe would be Groupshare- 
 Therefore I have tagged my colleague serafino graziosi (sgraziosi@sdl.com) who I am sure will be able to help you in a lot more detail. 
 
 Kr 
 Steve

Paul · Answer

Unknown said: Right now we have users opening the DBs remotely via a file share. We would like to store the database on an SQL server instead, where the rest of our databases are. Is this possible? 
 Hi Marc Pelletier yes this is possible. But it will still only be a shared file based TM with all the same limitations you have at the moment. The only way to really share TMs is with what we call Server-based TMs and this would be as Steve mentioned, through the use of GroupShare. 
 Alternatively you could create your own TM format using the APIs and share them anywhere you like... but it may be better to take a solution like GroupShare.

Paul · Answer

Hi Marc Pelletier , 
 
Yes... a Studio TM is only a simple database with no locking controls at all. So if you have multiple users reading and writing the same file you risk corruption. The "Add Server-based TM" in Studio is really referring to SDL Trados GroupShare. It does not mean putting a file-based TM onto a Server of your own. So even if you use a SQL server for TMs your users will still access the TM by selecting "Add File-based TM". 
 
GroupShare is designed to allow unlimited users to access a single TM. 
 
Regards 
 
Paul

Trados Studio > 1. Trados Studio

How to move a file based database to a SQL Server?