How can we help you today? How can we help you today?

Compare and User Instances

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
0

Comments

4 comments

Sort by
  • mackenziemi
    By the way we are using Bundle 5
    mackenziemi
    0
  • 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
    richardjm
    0
  • 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]
    mackenziemi
    0
  • 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.
    richardjm
    0

Add comment

Please sign in to leave a comment.