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:
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.
Hi, this video tutorial answers the following common questions:
1) I need to have many Tabbles users, each with his own machine, sharing their tags with each other. How can I configure Sql Server to do that?”
2) I am a single user, but I need to access Tabbles from several machines. How can I configure Sql Server for that?”
Obviously, for both scenarios, a Tabbles client needs to be installed on each machine. And all these clients will need to be able to talk to the central Sql Server.
For that to be possible, you need to make your Sql Server accessible from other machines. This video tutorial explains how to do that:
As you can see, it is basically a matter of going into Sql Server Configuration Manager, enabling TCP/IP, and then enabling the Sql Server Browser. Very easy.
Update: on many machines you also need set port 1433 in the TCP/IP options: in the TCP/IP properties dialog, switch to the tab “ip addresses”, and go to “ipAll” section (the last one), and set TCP port = 1433. Please do that as well.
This way, your users can start collaborating, tagging files and sharing their tagging.
this replies to a frequently asked question. Sometimes, when installing the latest version of Tabbles, you are asked to “upgrade the database“. (This is needed because Tabbles 3 is client-server, and upgrading the client does not automatically upgrade the database.)
It turns out you can do that with a couple of clicks. Here is a short video to illustrate that:
As you can see, this is all very similar to what you did when you created the database the first time. Most likely you used Windows Authentication, if you followed the video tutorial. You can do that here as well. Nothing new. 🙂
Note: if you used Sql Authentication to create the database, you can use that here as well (though it is not shown in the video); for that you will need to type the credentials of a user who is an administrator of Sql Server. (It will not work to type the credentials you normally use to login, because those are username and password of your Tabbles user, not of an Sql Server user).
In other news, Tabbles 3.0.33 is out with more bugfixes (in particular, you can now run all auto-tagging rules on a root drive. Previously it would not work.).
Take care and stay tuned for the next how-to video!