Technical forums » Transit support »
Setting up an SQL-Server
Thread poster: Iris Kleinophorst
Iris Kleinophorst
Iris Kleinophorst  Identity Verified
Germany
Local time: 07:48
Chinese to German
+ ...
Sep 24, 2015

Hi

As I have just set up a new, faster computer, I am thinking about transfering my TermStar databases to an SQL-Server.

Does that really make sense for databases with 15.000 to 30.000 entries? I read somewhere that terminology search in large databases get slower if installed as SQL instead of Access.

And which SQL server would be the most useful one? Would an Express version be sufficient for large databases?

Any experiences or suggestions?<... See more
Hi

As I have just set up a new, faster computer, I am thinking about transfering my TermStar databases to an SQL-Server.

Does that really make sense for databases with 15.000 to 30.000 entries? I read somewhere that terminology search in large databases get slower if installed as SQL instead of Access.

And which SQL server would be the most useful one? Would an Express version be sufficient for large databases?

Any experiences or suggestions?

TIA
Iris ▲ Collapse
 
Post removed: This post was hidden by a moderator or staff member for the following reason: empty post
Post removed: This post was hidden by a moderator or staff member for the following reason: empty post
2nl (X)
2nl (X)  Identity Verified
Netherlands
Local time: 07:48
Been there, done that Sep 24, 2015

Iris Kleinophorst wrote:

And which SQL server would be the most useful one? Would an Express version be sufficient for large databases?

Any experiences or suggestions?



Guten Tag, Iris,

The Express version is indeed all you need. Speed is not an issue. Stability is. At least it was for me. I've installed Transit + SQL on several PCs and in several VMs. After a certain time it started crashing after adding new term pairs. Support told me that this wasn't possible. It was–as a special feature–possible for me.

I switched to another CAT tool that handles Transit projects too.

I don't think that 30,000 entries will be a problem (I had 20x30,000).

Cheers,

Hans

[Edited at 2015-09-24 15:43 GMT]
 
AlSqur (X)
AlSqur (X)
license Aug 5, 2016

You also need an appropriate license for SQL, I guess.
 


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Maya Gorgoshidze[Call to this topic]

You can also contact site staff by submitting a support request »

Setting up an SQL-Server






Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

More info »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »