Impex and ASPPlayground - help

[mnapuran]

I have a fresh install of VB 3.7.4 patch level 1. I also have an existing ASPPlayground SQL v1.99.24 SP4.

I have downloaded and installed the lateset Impex, and updated the config to include the VB mysql login information.

The Import options shows up at the top of AdminCP, but I get an error "Connection to source server failed. Check username and password".

Do I have to make the connection via SQL to ASPPlayground? Or can I export the data and somehow make it available to Impex? Right now the 2 machines are at different locations.

Thanks for any help!

[Jerry]

Do I have to make the connection via SQL to ASPPlayground? Or can I export the data and somehow make it available to Impex? Right now the 2 machines are at different locations.


ImpEx will need to be able to connect to both databases, typically (due to remote connection security) that means they have to be on the same machine.

[mnapuran]

How would that be possible if VB is going to be on a Linux/CentOS box, and ASPPlayground is on a Win2003 Server?

[Jerry]

PHP on one of the machines will need to have MySQL and MSSQL support to be able to connect to both of the databases at the same time.

[mnapuran]

So no way to do this using a SQL export for the source?

[Jerry]

So no way to do this using a SQL export for the source?

What do you mean ?

[mnapuran]

I mean... no way we can just export the data from the SQL server or create .SQL files and have the import tool use that as the source?

[Jerry]

I mean... no way we can just export the data from the SQL server or create .SQL files and have the import tool use that as the source?

A SQL file is a textual representation of a database, a back up, and being MSSQL it would be a proprietary binary file.

ImpEx only works by connecting directly to a database server (for database based systems).