Moving DB between SQL instances

#1

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

#2

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

#3

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

#4

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

#5

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

#6

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

#7

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

#8

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

#9

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

#10

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