Activity overview
Latest activity by mordy
Problem comparing 2005 with 2000 when varchar(max) in source
Been searching for a while but can't find any reference to this problem but I'm trying to compare a 2005 DB with a 2000 DB which is currently empty. The source DB (2005) has some tables with colum...
Just wanted to thank Brian and Daniel for their help in working up a solution, we test ran our prototype last night and it worked like a charm [image] / comments
Just wanted to thank Brian and Daniel for their help in working up a solution, we test ran our prototype last night and it worked like a charm
Thanks Brian, I'll give that approach a try.
Edit: The evaluation popup is causing the webservice to fail as it cannot display UI elements [image] Thanks for your help in trying to get this prototype working but I think I'll have to rethink my strategy on this project.
Regards,
Mike / comments
Thanks Brian, I'll give that approach a try.
Edit: The evaluation popup is causing the webservice to fail as it cannot display UI elements Thanks for your help in trying to get this prototype w...
Hi Brian, my initial plan was to host a webservice that had access to the database I would use as the template and from a local application on a client machine to have an application to synchronise the structure of a database with this master-template in order that we could easily reflect changes to MSDE databases running on client machines - our master database will be behind a firewall so I only really have port 80 to work with which is why the webservice is probably going to be my best option for peeking through it to register the master database to use as my template for the comparison.
Plan A was a simple function in the webservice to register the database and return the created database object to the local client application which would then use it as the template to check against its' own local copy and synchronise any changes thereby radically simplifying deployment of new versions to the client by ensuring their local MSDE databases were always in synch with our release versions - it's become very easy to deploy new software revisions with .NET but there's always that nagging fear that we've added a column to a table and broken integrity with the local databases come release day and my evaluation project is to establish whether we can incorporate SQLCompare into a tool to take away this worry [image]
The reflection seems to be something the framework is doing - that's a little above where I'm at on the .NET learning curve at the moment, in a nutshell what I need the webservice to return to the client application is a registered database object containing the structure of the 'template' database on our DB server. / comments
Hi Brian, my initial plan was to host a webservice that had access to the database I would use as the template and from a local application on a client machine to have an application to synchronise...
Problem returning database from webservice method
Hi there, as part of our evaluation I'm trying to return the master database for a SQLCompare application from a web service function but I've run into a problem, the compiler is returning the foll...
the options.ignorefulltextindexing seems to be what I was after. / comments
the options.ignorefulltextindexing seems to be what I was after.
Evaluation question
Hi there, I'm currently evaluating your product regarding a project I have to synchronise the data and structure from a master database using SQL Server 2000 to a local 'clone' database in MSDE but...