Compare and User Instances

mackenziemi

Hey everyone

I am working changing one of our applications that uses the RedGate SQL Compare stuff over using "User Instance" databases. When I go to use the Database.Register method I can't see a way to tell the ConnecitonProperties object to use the User Instance not the actual server. Is there a way to do this?

Thanks
MacKenzie

mackenziemi

By the way we are using Bundle 5

richardjm

You can specify the server as SERVER\INSTANCE and that should connect to the named instance on the machine e.g.

richard\sql2005

HTH

mackenziemi

I tried that. When I do it that way it connects to actual instance not the user instance and hence it can't see the database that I am trying to modify because it is only on the user instance. Any other workarounds?

Thanks
MacKenzie[/quote]

richardjm

User instances are a SQL Express feature if I'm understanding you correctly. Currently we don't support user instanes and have no plans to in the near future. I'll raise it as a request so we have it in the system.