Setting up an SQL-Server
Thread poster: Iris Kleinophorst

Iris Kleinophorst  Identity Verified
Germany
Local time: 23:19
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?

TIA
Iris


 
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)  Identity Verified
Netherlands
Local time: 23:19
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]


 
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

Advanced search






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »
SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search