Copy Database To Different Host/db Corrupts Stored Procedures

[dazzknowles]

Hi,

When I use the “Copy Database To Different Host/DB” tool, it “corrupts” stored procedures, but only the parts that contain database and table names. For example:

SELECT *

FROM xyz.abc;

Will be written on the target db as:

SELECT *

FROM xbc;

Also as a feature request, could this tool have the added option to create the database on the target server if it doesn't already exist and similarly drop it first if it already does?

Dazz.

[peterlaursen]

You should ALWAYS tell the program version you are using (and research a little in the release notes of recent versions)!

The issue is not reproducable with version 6.05 beta 3. In the 6.05 tree we did another SP-related fix..

So please try 6.05 beta3!

If problems persist then please attach an EXACT case: what is is before and what it became after copy!

[Author]

Posts