Moving files between installations?

[kenfox]

Hi,

currenty, I'm installing my final sage server. When finishied, I want to move some of my recodings from the testserver to the new server (both are sage 9). Is it possible to move the recordings together with their meta data?

ken

[Fuzzy]

Originally Posted by kenfox

Hi,

currenty, I'm installing my final sage server. When finishied, I want to move some of my recodings from the testserver to the new server (both are sage 9). Is it possible to move the recordings together with their meta data?

ken

As long as the recording have not been altered post-recording (like converted by something other than sage), then moving them, along with their properties file (if present) will allow the other instance of sage to pick up the appropriate metadata for them. What will NOT come over, though, is the knowledge that they have been recorded - so if there is a favorite for that show, it will not 'know' that it has already recorded that episode, so if it re-airs, it will likely record it again. Also missing will be the actual 'Airing' information (channel and time it was on), because that airing will likely not be present in the destination system's database.

[Narflex]

Originally Posted by Fuzzy

As long as the recording have not been altered post-recording (like converted by something other than sage), then moving them, along with their properties file (if present) will allow the other instance of sage to pick up the appropriate metadata for them. What will NOT come over, though, is the knowledge that they have been recorded - so if there is a favorite for that show, it will not 'know' that it has already recorded that episode, so if it re-airs, it will likely record it again. Also missing will be the actual 'Airing' information (channel and time it was on), because that airing will likely not be present in the destination system's database.

If you also copy the Wiz.bin file, then you will also retain all of that other information as well.

[Tiki]

Originally Posted by Narflex

If you also copy the Wiz.bin file, then you will also retain all of that other information as well.

Yes, but there is currently no way to merge two wiz.bin files. So, if he is running two servers for a while (original v7 server plus new v9 "Test" server), they will have different histories stored in their respective wiz.bins. You can merge the recordings by simply copying them over from one server to the other (meta-data stored in the recording files will get picked-up by the new server), but the watched history and other information doesn't get merged.

[Narflex]

Originally Posted by Tiki

Yes, but there is currently no way to merge two wiz.bin files. So, if he is running two servers for a while (original v7 server plus new v9 "Test" server), they will have different histories stored in their respective wiz.bins. You can merge the recordings by simply copying them over from one server to the other (meta-data stored in the recording files will get picked-up by the new server), but the watched history and other information doesn't get merged.

Guess I missed that part, as you are correct that there's currently no way to merge multiple Wiz.bin files.

[graywolf]

Originally Posted by Narflex

Guess I missed that part, as you are correct that there's currently no way to merge multiple Wiz.bin files.

If anything was on my "Wish List" I guess it would be the ability to merge multiple Wiz.bin files, or export/import from one to another.

Started off with multiple SageTV servers and have been at the point that I'd like to reduce it into 1.

Too bad there wasn't a SQL based interface.

[wnjj]

Originally Posted by graywolf

If anything was on my "Wish List" I guess it would be the ability to merge multiple Wiz.bin files, or export/import from one to another.

Started off with multiple SageTV servers and have been at the point that I'd like to reduce it into 1.

Too bad there wasn't a SQL based interface.

Since I already wrote a program to export wiz.bin to SQL, I'm considering ways to expand on it. If you are fluent in SQL and can get everything merged there, the main need would be an SQL to DB option which shouldn't be too difficult. The tough part would be making sure everything was "proper" for Sage.

I'm also starting to,think about what a GUI-based wiz.bin viewer/editor/merger might look like.

[graywolf]

Originally Posted by wnjj

Since I already wrote a program to export wiz.bin to SQL, I'm considering ways to expand on it. If you are fluent in SQL and can get everything merged there, the main need would be an SQL to DB option which shouldn't be too difficult. The tough part would be making sure everything was "proper" for Sage.

I'm also starting to,think about what a GUI-based wiz.bin viewer/editor/merger might look like.

I wasn' aware of your export Wiz.bin to SQL. Does it work with SageTV 6 or is it just SageTV7/9 compatible?

Can you provide the name/link for it? And your forum link if there is one?

Yes, definitely familar with SQL. Long time Database Administrator/System Admin

Would LOVE to have the SQL => Wiz.bin capability. I could see it opening up so many doors.

[wnjj]

Originally Posted by graywolf

I wasn' aware of your export Wiz.bin to SQL. Does it work with SageTV 6 or is it just SageTV7/9 compatible?

Can you provide the name/link for it? And your forum link if there is one?

Yes, definitely familar with SQL. Long time Database Administrator/System Admin

Would LOVE to have the SQL => Wiz.bin capability. I could see it opening up so many doors.

It should work with any version of the DB. It's here: https://forums.sagetv.com/forums/sho...d.php?p=577768