Moving DB between SQL instances

#11

The only way this is impossible is if they hard coded something to make it
look for the default instance. The app should not care what the instance it
is running on as long as the collations, versions etc are the same.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Tecnica" <abola (AT) nospam (DOT) nospam> wrote

Quote:

Hi,

I work with SQL server at about 4 years, and last week I was confronted
with
a problem post by one of our software provider about a commercial
application
that we run in our office:

- The application has been installed in an SQL instance, and now I need
that
to be moved to another instance in the same SQL server and they said that
was
impossible!

I already moved several databases between SQL instances and I didn’t have
any problem, but they told me that most of the times that process is
impossible. Can anyone help me understand if this is true? Is it really
complicated, sometimes, moving DB between SQL instances?

Thanks,
Rui Reis

#12

Hi Rui...

Wow... this brings back memories of working with 3rd party software and
vendors. As Andrew pointed out... if their application does not support
multiple instances or their application does not listen on nonstandard ports
( I have come across a few of these). Please post back... I would like to
know their reason.

Thanks!
Squirrel
www.lockergnome.com/sqlsquirrel/

"Andrew J. Kelly" wrote:

Quote:

The only way this is impossible is if they hard coded something to make it
look for the default instance. The app should not care what the instance it
is running on as long as the collations, versions etc are the same.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Tecnica" <abola (AT) nospam (DOT) nospam> wrote in message
news:4141A12F-3A7E-468C-8392-1B3C2557D1B7 (AT) microsoft (DOT) com...
Hi,

I work with SQL server at about 4 years, and last week I was confronted
with
a problem post by one of our software provider about a commercial
application
that we run in our office:

- The application has been installed in an SQL instance, and now I need
that
to be moved to another instance in the same SQL server and they said that
was
impossible!

I already moved several databases between SQL instances and I didn’t have
any problem, but they told me that most of the times that process is
impossible. Can anyone help me understand if this is true? Is it really
complicated, sometimes, moving DB between SQL instances?

Thanks,
Rui Reis

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Moving DB between SQL instances

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: Moving DB between SQL instances - 10-04-2008 , 09:26 PM

Re: Moving DB between SQL instances - 06-09-2010 , 11:10 PM