• Do you want to do the compare inside or outside of SQL Server? That is do you want a file you would import into the remote SQL server (perhaps as a new DB) and do the compare within SQL Server or do you want to export the local information to a flat file and do a flat file compare?

    Also what is the amount of data (not schema) that you need to compare (in the KB, MB or GB?)?

    You might want to take a look at SQL Compare from Red Gate