Setting up an SQL-Server
Thread poster: Iris Kleinophorst

Iris Kleinophorst  Identity Verified
Germany
Local time: 22:14
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

xxx2nl  Identity Verified
Netherlands
Local time: 22:14
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






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 »
SDL Trados Studio 2017 only €435 / $519
Get the cheapest prices for SDL Trados Studio 2017 on ProZ.com

Join this translator’s group buy brought to you by ProZ.com and buy SDL Trados Studio 2017 Freelance for only €435 / $519 / £345 / ¥63000 You will also receive FREE access to Studio 2019 when released.

More info »



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