Uninstalling SQL??

[Rictus]

Hi,

I'm really struggling to get my database transferred to a second machine. I was going to use the backup function, copy the back up file to the new machine, then 'restore' from there, but I can't do this because there isn't enough spare disk space on the old machine to create the backup in the first place! So I copied my PT3 and SQL Program folders to an external drive, and form there to machine number 2.

So far, so good, but then I did a so stupid, and installed PT3 on the new machine for ma download, along with SQL. When I try and overwrite the SQL install with the one I've copied, I'm unable to do so at he .dll files will not delete. Because of this, I also cannot just delete the SQL program folder.

Help!!! How do I either 1) remove the SQL install so I can used the copied one or 2) import the relevant data form the copied SQL into the new install so it works in PT3?

Many thanks in advance for any help you can offer - I realise the backup function is probably the ideal fix but I just can't get it done - half the reason I'm trying to migrate to a new machine in the first place!

[kraada]

The dll files don't actually matter for your database. What you care about is the data folder in the PostgreSQL\8.3\ directory.

When the database is stopped on your primary machine, copy off that folder and only that folder. Create a C:\Program Files (x86)\PostgreSQL\8.3\ directory on the new machine and copy the data folder into it.

The install PostgreSQL directly from this installer, and when you get to the screen that gives you the option, untick "Initialize Database Cluster". The install will complete and by default use your old database itself (assuming this is a 64 bit Windows machine - if it's not remove the (x86) bit in the path earlier).

[Rictus]

The dll files don't actually matter for your database. What you care about is the data folder in the PostgreSQL\8.3\ directory.

When the database is stopped on your primary machine, copy off that folder and only that folder. Create a C:\Program Files (x86)\PostgreSQL\8.3\ directory on the new machine and copy the data folder into it.

The install PostgreSQL directly from this installer, and when you get to the screen that gives you the option, untick "Initialize Database Cluster". The install will complete and by default use your old database itself (assuming this is a 64 bit Windows machine - if it's not remove the (x86) bit in the path earlier).

Thank you SO much for the help. OK, I've now completed the process outlined above - I take it my next step is to just download and install PT3 from the site and enter my product code to activate it? Should it then automatically detect and connect with the data I've copied across?

[Rictus]

Thank you SO much for the help. OK, I've now completed the process outlined above - I take it my next step is to just download and install PT3 from the site and enter my product code to activate it? Should it then automatically detect and connect with the data I've copied across?

Apologies for the double post - OK, I installed PT3 and activiated it but the data has not transferred across. Any ideas?

[kraada]

The database should be there but you need to tell PT3 to look for it. Click Database --> Database Management --> New and click the blue Browse link. Locate your database, click on it, click OK then Connect and you should be good to go (you'll probably want to set it as Active and Default).

[Rictus]

The database should be there but you need to tell PT3 to look for it. Click Database --> Database Management --> New and click the blue Browse link. Locate your database, click on it, click OK then Connect and you should be good to go (you'll probably want to set it as Active and Default).

I did try that - I'm getting 'No PT3 databases found' when browsing...

[kraada]

That's odd. Create a support ticket using this link and we'll help you get this sorted.