Urgent! SQL -Toolkit: Compare databases over internet

Brian Donahue

Hi Petter,

You can't return a 'database' object through a webservice because the
SQL Compare Engine objects aren't serializable into XML. I believe that we
write our own serialization routines as a workaround in the native Framework
serialization.

Here is an idea though, and I've tried it so I know it works... you can
set up a webservice on the remote machine that registers a database and
saves a snapshot using the 'SaveToDisk' method. Then you can have the
webservice read that file as bytes with a FileStream, convert the bytes to
Base64 and return a base64string to the web service consumer.

Then the consumer can convert the base64 string back to bytes, save the
snapshot, and load it using the LoadFromDisk method of the Database object.

That's the best way I can figure out to transfer a database across the
Internet without a SQL Server connection, using just a web service.

Any comments?

Regards,

Brian Donahue
Red Gate Technical Support

"petter forss" <petter.forss@spray.se> wrote in message
news:PWwAs2OOEHA.1224@server53...
> Is it possible to compare a database with another over internet? I have a
> master db, and want all differences made in another one, is it possible to
> match and update through a snp-file (database snapshot file). ... (SQL
> compare can do some of this I saw in a FAQ I think..)
>
> .. or fill a database object with info via a webservice and then do a
> compare ?
>
> Best Regards,
> Petter
>
>
>