Setting up an SQL-Server
Thread poster: Iris Kleinophorst
Iris Kleinophorst  Identity Verified
Germany
Local time: 00:54
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


Direct link Reply with quote
 
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: 00:54
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]


Direct link Reply with quote
 
license Aug 5, 2016

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

Direct link Reply with quote
 


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






WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »
BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »



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