Video: how to migrate the Tabbles database to a different Sql Server instance; how to backup and restore the database.

how to migrate the Tabbles database to a different Sql Server

(Articolo in Inglese Americano. ) Per ragioni di convenienza del visitatore, il contenuto è mostrato sotto nella lingua alternativa. Puoi cliccare sul link per cambiare la lingua attiva.

Dear Tabbles followers, today we have another video how-to which answers the frequent questions: “what if I reinstall Windows?” “what if buy a new computer?” “What if I reinstall SQL Server?”.  In all these cases, how do you preserve your tags? Or if you have many Tabbles users, how do you reimport the tags of all your users into the new environment?

(Later in this post, we will also answer the question “how do I backup and restore my database?“)

All these cases have one thing in common: you have a new installation of Sql Server, and you need to move your existing database from the old instance of SQL Server to the new instance. So the question is how to do that; how to migrate the tabbles database to a new instance of Sql Server.

And here is a 5-minutes video providing the answer: (be sure to turn on annotations to see the subtitles!)

Note: at a certain point in the video, the following script is run:

use tabbles;
EXEC sp_change_users_login 'update_one', 'tabblesClient', 'tabblesClient';

You can just copy and paste the above script into Sql Server Management Studio.

How to backup and restore the database

Note that restoring a database backup is simply a special case of the above video, where the destination and source Sql Servers are the same. So this video also explains how to backup and restore the Tabbles database: just detach the current tabbles.mdf, and attach your backup of tabbles.mdf, as explained in the video.

 

Scarica

Tabbles 4.2.0 (~ 19MB)
Compatibile con: Vista, 7, 8, 8.1, 10. Per l’utilizzo in LAN richiede Microsoft Sql Server Express 2008 o superiore.

Write us!

Do you have questions about Tabbles, or just want to say hi? Drop us a line and we'll get back to you:

Your Name (required)

Your Email (required)

Subject (required)

Your Message (required)

Subscribe to our Newsletter

WP User Control Widget

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close