Dear Unity support,
I have my old system disk connected externally via USB 2.0 and we need to migrate our asset server data (projects/useraccounts) over from it, to the new internal SSD system drive.
What steps should be taken to ensure this process is a smooth and relatively straightforward one?
Our studio can not afford excessive downtime and we must become operational again within a matter of days.
Thank you in advance.
Warm Regards,
Paul W.
Director/CEO
Subspark Media
www.subspark.com
Bump. This is a serious problem, is this not the official Unity support forums? Some experienced assistance would greatly be appreciated.
Thanks again,
Paul.
Its the forums yeah, the community ones though.
But as for transfering: normally you use the command line connection to it and then export the current database in psql and import it on the other end again.
I think there is a thread on it and potentially some documentation too.
Dear Dreamora,
I found This page and This one too.
However it’s rather unintuitive. If a generous community member would be kind enough to walk me through the steps I would need to take in detail I would be forever grateful.
Cheers,
Paul.
Does anyone know what order of steps we need to take to get our old asset server database off our old system HD (now external and no longer system) and integrate it back into our current installation of Asset Server on our machine’s new system SSD?
I’m not sure that Asset Server 2 is going to remain our source control/project management tool of choice if this kind of overhead is to be expected under circumstances as common as ours.
I ask here because the user/pass I licensed Unity 3x Pro under won’t log into premium support. I’m slightly confused as to why support seems so hard to come by. I mean no disrespect but my observation is that the reality is quite contrary to the support base we hear everyone speak about so favorably. What gives?
The premium support is if you have a support contract.
As Pro owner you go through the same support@unity3d.com as free users too.
As for getting the data out there: if you don’t boot on the device potentially not that easy at all. you should have exported it before doing that.
But the good thing is its just a psql database so you can basically also just go the path of copying the whole folder if you want, then you don’t have to login or anything and if nothing is in your new database yet there is not much of a problem either.
Optimally - thats my point of view - you would never install the AS onto a physical system. Do yourself the favor to install it on a virtual system, that way you can totally painless transfer it to anywhere you want and need it including a host or a dedicated server machine. Even I have it on a VMWare VM and that although its normally not going to move, just cause it makes the installation completely “machine independent”
So does this mean I can copy the original database from the old system drive into the same location on the new system drive and Asset Server will see the projects like nothing had ever changed?
If so where the heck is the database located? 
We have about 5 projects all linked into Asset Server
Cheers, and thank you kindly for your help and recommendations so far. big help, Dreamora! 
Where it is depends on the operating system.
The AS documentations (please don’t ask me which page it was in detail, I check them once when I setup a new AS just to be sure to know all currently known troublemakers …) contains the paths where the data go I think.
On Windows no idea whee it puts the database in detail. tried to find it in a fast lookup but didn’t see it I fear.
On Linux it was somewhere down the etc/ route from what I recall (a general system folder not user bound)
No idea where it is on OSX as I never tried to get that somewhere else.
No no, much appreciated. You’ve been a big help already. I’ll have no problem hunting down the database locale now that I know one exists.
Thank you very much again.
Cheers!
Paul.
Dear dreamora and anyone who may be under the same circumstance as I was, the solution was truly simple.
I discovered our original database located at H:\Program Files (x86)\Unity\Asset Server H:\ was originally C:\ when the drive was the active system disk but is now an external Hard Drive.
I made sure the new Unity Asset Server (on C:) drive was still operating in the background.
Inside this H:\Program Files (x86)\Unity\Asset Server there is a batch command called as_backup.cmd
I opened a command window and dragged the as_backup.cmd file into it. I then tapped one space in to seperate the output location where I wanted to dump the old database. I chose C:\ASBackup.
So my entire command instruction looked like so:
“H:\Program Files (x86)\Unity\AssetServer\bin\as_backup.cmd” C:\ASBackup
I then hit Enter. It then asked me to accept the administrator privileges check. I typed “Y”.
It began to dump each project (.aaaa files) one after the other into the destination I chose on my active system drive.
I then opened my local Unity and ran it from my system SSD and was able to connect to the old project tree from the new location and off I went as if nothing had been altered. The only small thing of minor concern was that the entire project tree was in the change list as modified. Seeing I had the latest project version open when I connected to the server anyway, I discarded all the local changes that showed up and viola we have a complete restoration of our entire collection of projects on the new system.
Thank you for your kind generosity and support, Dreamora. I hope this thread is useful to others with similar needs.
Cheers!
Thanks for the well written up share, I’m sure others will appreciate it