Issue moving database to another PC

Posted by CarlosM on September 6, 2007, 10:14 am

Please log in for more thread options

Please need help with the following.

Running Headquarter at a different location. At the store, there are two
PCs. One of them (PC1) is the main one that has the database and
Headquarters Client. The other one (PC2) just points to (PC1) to connect to
the database with a drive mapping.

PC1 is giving problems and want to make PC2 the main one with the database
and communicates with Headquarter. I backed up the database from PC1 and
copied it to PC2. Then, I unplugged PC1 from the network and changed system
settings, such as hostname and IP, on PC2 to match PC1 so that HQ can
communicate with PC2 (now PC1). When I run the SO Administrator to change
the SQL server to Local, I get a connection error "it cannot find the
database". And until I can connect to a database it does not give me the
option to restore database. I uninstall everything and reinstalled it and it
still SO Administrator trys to look for the database on the other PC which I
unplugged.

What are the proper steps to make the change keep in mind that the HQ needs
to communicate with PC2?

I appreciate the help and need to make this change before the main PC crashes.

Thanks in advance.

Posted by convoluted on September 7, 2007, 12:02 am

Please log in for more thread options

Hi Carlos...you need to create the database locally not by copying it but by
restoring from the backup you created from the original PC1; this backup will
be in the form of a bck extension file; copy that bck file on the local drive
of your new database server; thenin SO Administrator connect locally to any
database (ie master), then go to database - create - restore from the bck
file you copied locally; this will recreate the database on local - hope this
helps....

"CarlosM" wrote:

> Please need help with the following.

> Running Headquarter at a different location. At the store, there are two

> PCs. One of them (PC1) is the main one that has the database and

> Headquarters Client. The other one (PC2) just points to (PC1) to connect to

> the database with a drive mapping.

> PC1 is giving problems and want to make PC2 the main one with the database

> and communicates with Headquarter. I backed up the database from PC1 and

> copied it to PC2. Then, I unplugged PC1 from the network and changed system

> settings, such as hostname and IP, on PC2 to match PC1 so that HQ can

> communicate with PC2 (now PC1). When I run the SO Administrator to change

> the SQL server to Local, I get a connection error "it cannot find the

> database". And until I can connect to a database it does not give me the

> option to restore database. I uninstall everything and reinstalled it and it

> still SO Administrator trys to look for the database on the other PC which I

> unplugged.

> What are the proper steps to make the change keep in mind that the HQ needs

> to communicate with PC2?

> I appreciate the help and need to make this change before the main PC crashes.

> Thanks in advance.

Posted by CarlosM on September 7, 2007, 11:24 am

Please log in for more thread options

Ok, I understand all that. But how about the database name, hostname, and IP
in terms of communicating with HQ.

"convoluted" wrote:

> Hi Carlos...you need to create the database locally not by copying it but by

> restoring from the backup you created from the original PC1; this backup will

> be in the form of a bck extension file; copy that bck file on the local drive

> of your new database server; thenin SO Administrator connect locally to any

> database (ie master), then go to database - create - restore from the bck

> file you copied locally; this will recreate the database on local - hope this

> helps....

> "CarlosM" wrote:

> > Please need help with the following.

> >

> > Running Headquarter at a different location. At the store, there are two

> > PCs. One of them (PC1) is the main one that has the database and

> > Headquarters Client. The other one (PC2) just points to (PC1) to connect to

> > the database with a drive mapping.

> >

> > PC1 is giving problems and want to make PC2 the main one with the database

> > and communicates with Headquarter. I backed up the database from PC1 and

> > copied it to PC2. Then, I unplugged PC1 from the network and changed system

> > settings, such as hostname and IP, on PC2 to match PC1 so that HQ can

> > communicate with PC2 (now PC1). When I run the SO Administrator to change

> > the SQL server to Local, I get a connection error "it cannot find the

> > database". And until I can connect to a database it does not give me the

> > option to restore database. I uninstall everything and reinstalled it and

> > still SO Administrator trys to look for the database on the other PC which I

> > unplugged.

> >

> > What are the proper steps to make the change keep in mind that the HQ needs

> > to communicate with PC2?

> >

> > I appreciate the help and need to make this change before the main PC

crashes.

> >

> > Thanks in advance.

> >

Posted by convoluted on September 7, 2007, 7:48 pm

Please log in for more thread options

The database name must be the same as the original (HQ will look for the
original store ID when store connects); I don't think the internal IP or
hostname will make a difference for HQ....if you also moved the HQ Client to
the new machine test the db connection there as well to make sure it sees the
local db....

"CarlosM" wrote:

> Ok, I understand all that. But how about the database name, hostname, and IP

> in terms of communicating with HQ.

> "convoluted" wrote:

> > Hi Carlos...you need to create the database locally not by copying it but by

> > restoring from the backup you created from the original PC1; this backup

will

> > be in the form of a bck extension file; copy that bck file on the local

drive

> > of your new database server; thenin SO Administrator connect locally to any

> > database (ie master), then go to database - create - restore from the bck

> > file you copied locally; this will recreate the database on local - hope

this

> > helps....

> >

> > "CarlosM" wrote:

> >

> > > Please need help with the following.

> > >

> > > Running Headquarter at a different location. At the store, there are two

> > > PCs. One of them (PC1) is the main one that has the database and

> > > Headquarters Client. The other one (PC2) just points to (PC1) to connect

> > > the database with a drive mapping.

> > >

> > > PC1 is giving problems and want to make PC2 the main one with the database

> > > and communicates with Headquarter. I backed up the database from PC1 and

> > > copied it to PC2. Then, I unplugged PC1 from the network and changed

system

> > > settings, such as hostname and IP, on PC2 to match PC1 so that HQ can

> > > communicate with PC2 (now PC1). When I run the SO Administrator to change

> > > the SQL server to Local, I get a connection error "it cannot find the

> > > database". And until I can connect to a database it does not give me the

> > > option to restore database. I uninstall everything and reinstalled it and

> > > still SO Administrator trys to look for the database on the other PC which

> > > unplugged.

> > >

> > > What are the proper steps to make the change keep in mind that the HQ

needs

> > > to communicate with PC2?

> > >

> > > I appreciate the help and need to make this change before the main PC

crashes.

> > >

> > > Thanks in advance.

> > >