SBA Database Location?

  • Thread starter Ron Anthony Quinn
  • Start date

R

Ron Anthony Quinn

I have SBA on my laptop in which the motherboard failed. I put the HD in an
external USB enclosure and was able to save the contents of the HD. I
installed SBA on a desktop computer in my office and need to move the
database from my old HD to the desktop computer.

Where can I find the database on the old HD? Is it a simple matter of
moving it from the old HD to the new desktop? The backup I have is a couple
of weeks old and I want to try and not lose the recent data.

Any suggestions?

Cheers!
 
Ad

Advertisements

J

Jesper [MS]

Hi Ron

If you're talking about SBA 2006 then the actual data files are located in:
"C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTSMLBIZ\Data\".
In MOA 2007 the folder is:
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\" (where "1" can
be another number if you have multiple instances of SQL Server).

The files you want to copy are called "[company name].sbd" and "[company
name].sbl".
After you have copied them to your new installation you just need to
"attach" them to the SQL server.
You can do this through the Data Tools in SBA/MOA.

Then to open the company, you need a new company file (sbc-file) which is
the shortcut that points to the database.
You can use the "Rebuild company-file" button in the Data Tools to generate
a new sbc-file that points to the database.

Let me know if that helps.
 
R

Ron Anthony Quinn

Thanks for the information...

I went through the steps you provided in which I copied over the
[companyname].sbc file, then opened Data Tools and Attached the the same
file, then went to Rebuild. When I tried to open an "Existing Company", I
got an error that says, "This shortcuts points to a company that has been
moved during upgrade or integration. Please use the shortcut that was
created when the company was moved or create a new shortcut from Data Tools."

Ugh. Any other suggestions that may help?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
Hi Ron

If you're talking about SBA 2006 then the actual data files are located in:
"C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTSMLBIZ\Data\".
In MOA 2007 the folder is:
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\" (where "1" can
be another number if you have multiple instances of SQL Server).

The files you want to copy are called "[company name].sbd" and "[company
name].sbl".
After you have copied them to your new installation you just need to
"attach" them to the SQL server.
You can do this through the Data Tools in SBA/MOA.

Then to open the company, you need a new company file (sbc-file) which is
the shortcut that points to the database.
You can use the "Rebuild company-file" button in the Data Tools to generate
a new sbc-file that points to the database.

Let me know if that helps.
 
J

Jesper [MS]

This is because the sbc-file that you copied is pointing to the old location
and this is interepreted by MOA 2007 as the company has been moved (hence
the message).
You should use the sbc-file that is created when you Rebuild from the Data
Tools.

Alternately you can simply open the sbc-file in Notepad and edit the
information in it. If you know the computer name and exact database name
(i.e. from the rebuild-dialog where you see a list of databases), you can
just manually change the sbc-file.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ron Anthony Quinn said:
Thanks for the information...

I went through the steps you provided in which I copied over the
[companyname].sbc file, then opened Data Tools and Attached the the same
file, then went to Rebuild. When I tried to open an "Existing Company", I
got an error that says, "This shortcuts points to a company that has been
moved during upgrade or integration. Please use the shortcut that was
created when the company was moved or create a new shortcut from Data
Tools."

Ugh. Any other suggestions that may help?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
Hi Ron

If you're talking about SBA 2006 then the actual data files are located
in:
"C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTSMLBIZ\Data\".
In MOA 2007 the folder is:
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\" (where "1"
can
be another number if you have multiple instances of SQL Server).

The files you want to copy are called "[company name].sbd" and "[company
name].sbl".
After you have copied them to your new installation you just need to
"attach" them to the SQL server.
You can do this through the Data Tools in SBA/MOA.

Then to open the company, you need a new company file (sbc-file) which is
the shortcut that points to the database.
You can use the "Rebuild company-file" button in the Data Tools to
generate
a new sbc-file that points to the database.

Let me know if that helps.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ron Anthony Quinn said:
I have SBA on my laptop in which the motherboard failed. I put the HD
in
an
external USB enclosure and was able to save the contents of the HD. I
installed SBA on a desktop computer in my office and need to move the
database from my old HD to the desktop computer.

Where can I find the database on the old HD? Is it a simple matter of
moving it from the old HD to the new desktop? The backup I have is a
couple
of weeks old and I want to try and not lose the recent data.

Any suggestions?

Cheers!
 
R

Ron Anthony Quinn

Well... I have tried it both ways. I have manually edited the file and I
have used the file created from the rebuild and I get that same message
either way. It's pointing to the correct machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
This is because the sbc-file that you copied is pointing to the old location
and this is interepreted by MOA 2007 as the company has been moved (hence
the message).
You should use the sbc-file that is created when you Rebuild from the Data
Tools.

Alternately you can simply open the sbc-file in Notepad and edit the
information in it. If you know the computer name and exact database name
(i.e. from the rebuild-dialog where you see a list of databases), you can
just manually change the sbc-file.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ron Anthony Quinn said:
Thanks for the information...

I went through the steps you provided in which I copied over the
[companyname].sbc file, then opened Data Tools and Attached the the same
file, then went to Rebuild. When I tried to open an "Existing Company", I
got an error that says, "This shortcuts points to a company that has been
moved during upgrade or integration. Please use the shortcut that was
created when the company was moved or create a new shortcut from Data
Tools."

Ugh. Any other suggestions that may help?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
Hi Ron

If you're talking about SBA 2006 then the actual data files are located
in:
"C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTSMLBIZ\Data\".
In MOA 2007 the folder is:
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\" (where "1"
can
be another number if you have multiple instances of SQL Server).

The files you want to copy are called "[company name].sbd" and "[company
name].sbl".
After you have copied them to your new installation you just need to
"attach" them to the SQL server.
You can do this through the Data Tools in SBA/MOA.

Then to open the company, you need a new company file (sbc-file) which is
the shortcut that points to the database.
You can use the "Rebuild company-file" button in the Data Tools to
generate
a new sbc-file that points to the database.

Let me know if that helps.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


I have SBA on my laptop in which the motherboard failed. I put the HD
in
an
external USB enclosure and was able to save the contents of the HD. I
installed SBA on a desktop computer in my office and need to move the
database from my old HD to the desktop computer.

Where can I find the database on the old HD? Is it a simple matter of
moving it from the old HD to the new desktop? The backup I have is a
couple
of weeks old and I want to try and not lose the recent data.

Any suggestions?

Cheers!
 
J

Jesper [MS]

Ok, I see that I was mistaken on how it checks for this scenario - it
actually looks at a field in the database itself and not in the sbc-file.

When we upgrade a database from SBA 2006 to MOA 2007 we copy the whole
database from the old SQL instance "MICROSOFTSMLBIZ" to the new instance
"MSSMLBIZ" (this is because 2006 used MSDE 2000 while 2007 uses SQL Express
and they can be installed side-by-side).
So we copy the database and then "stamp" the old database so that we can
recognize that it has been upgraded in case anyone tries to use the old
database (which would usually not be what you wanted). And this is the
message you get when the database has been stamped that way.

So I'm guessing that the database you copied must already have been
upgraded/moved to 2007 and the database you really want is probably
somewhere else.
On the HD from the failed computer, you probably had both SBA 2006 and MOA
2007 and had already upgraded to 2007?
If that is the case then the data files would have been moved to the 2007
folders which is here: "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\"
Take a look at this folder on the HD from the failed computer and see if you
find the files there.

If you do, then please copy them to the new computer instead - you might
have to delete the database you already attached, using the delete
functionality in the Data Tools.


--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ron Anthony Quinn said:
Well... I have tried it both ways. I have manually edited the file and I
have used the file created from the rebuild and I get that same message
either way. It's pointing to the correct machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
This is because the sbc-file that you copied is pointing to the old
location
and this is interepreted by MOA 2007 as the company has been moved (hence
the message).
You should use the sbc-file that is created when you Rebuild from the
Data
Tools.

Alternately you can simply open the sbc-file in Notepad and edit the
information in it. If you know the computer name and exact database name
(i.e. from the rebuild-dialog where you see a list of databases), you can
just manually change the sbc-file.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ron Anthony Quinn said:
Thanks for the information...

I went through the steps you provided in which I copied over the
[companyname].sbc file, then opened Data Tools and Attached the the
same
file, then went to Rebuild. When I tried to open an "Existing
Company", I
got an error that says, "This shortcuts points to a company that has
been
moved during upgrade or integration. Please use the shortcut that was
created when the company was moved or create a new shortcut from Data
Tools."

Ugh. Any other suggestions that may help?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Hi Ron

If you're talking about SBA 2006 then the actual data files are
located
in:
"C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTSMLBIZ\Data\".
In MOA 2007 the folder is:
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\" (where "1"
can
be another number if you have multiple instances of SQL Server).

The files you want to copy are called "[company name].sbd" and
"[company
name].sbl".
After you have copied them to your new installation you just need to
"attach" them to the SQL server.
You can do this through the Data Tools in SBA/MOA.

Then to open the company, you need a new company file (sbc-file) which
is
the shortcut that points to the database.
You can use the "Rebuild company-file" button in the Data Tools to
generate
a new sbc-file that points to the database.

Let me know if that helps.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
I have SBA on my laptop in which the motherboard failed. I put the
HD
in
an
external USB enclosure and was able to save the contents of the HD.
I
installed SBA on a desktop computer in my office and need to move
the
database from my old HD to the desktop computer.

Where can I find the database on the old HD? Is it a simple matter
of
moving it from the old HD to the new desktop? The backup I have is
a
couple
of weeks old and I want to try and not lose the recent data.

Any suggestions?

Cheers!
 
Ad

Advertisements

R

Ron Anthony Quinn

Well, the dba from the old failed computer is MOA Professional 2007 and I am
(trying) to move it to an office desktop into MOA Professional 2007. The dba
in question was never part of SBA 2006. My company (I own) just moved from
QuickBooks 2006 to MOA Professional 2007 on 01 January 2007. It's just been
a nightmare to try and get the dba from the old hard drive to the new
computer.

So given that it's never been SBA 2006, are there any other suggestions?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
Ok, I see that I was mistaken on how it checks for this scenario - it
actually looks at a field in the database itself and not in the sbc-file.

When we upgrade a database from SBA 2006 to MOA 2007 we copy the whole
database from the old SQL instance "MICROSOFTSMLBIZ" to the new instance
"MSSMLBIZ" (this is because 2006 used MSDE 2000 while 2007 uses SQL Express
and they can be installed side-by-side).
So we copy the database and then "stamp" the old database so that we can
recognize that it has been upgraded in case anyone tries to use the old
database (which would usually not be what you wanted). And this is the
message you get when the database has been stamped that way.

So I'm guessing that the database you copied must already have been
upgraded/moved to 2007 and the database you really want is probably
somewhere else.
On the HD from the failed computer, you probably had both SBA 2006 and MOA
2007 and had already upgraded to 2007?
If that is the case then the data files would have been moved to the 2007
folders which is here: "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\"
Take a look at this folder on the HD from the failed computer and see if you
find the files there.

If you do, then please copy them to the new computer instead - you might
have to delete the database you already attached, using the delete
functionality in the Data Tools.


--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ron Anthony Quinn said:
Well... I have tried it both ways. I have manually edited the file and I
have used the file created from the rebuild and I get that same message
either way. It's pointing to the correct machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
This is because the sbc-file that you copied is pointing to the old
location
and this is interepreted by MOA 2007 as the company has been moved (hence
the message).
You should use the sbc-file that is created when you Rebuild from the
Data
Tools.

Alternately you can simply open the sbc-file in Notepad and edit the
information in it. If you know the computer name and exact database name
(i.e. from the rebuild-dialog where you see a list of databases), you can
just manually change the sbc-file.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Thanks for the information...

I went through the steps you provided in which I copied over the
[companyname].sbc file, then opened Data Tools and Attached the the
same
file, then went to Rebuild. When I tried to open an "Existing
Company", I
got an error that says, "This shortcuts points to a company that has
been
moved during upgrade or integration. Please use the shortcut that was
created when the company was moved or create a new shortcut from Data
Tools."

Ugh. Any other suggestions that may help?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Hi Ron

If you're talking about SBA 2006 then the actual data files are
located
in:
"C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTSMLBIZ\Data\".
In MOA 2007 the folder is:
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\" (where "1"
can
be another number if you have multiple instances of SQL Server).

The files you want to copy are called "[company name].sbd" and
"[company
name].sbl".
After you have copied them to your new installation you just need to
"attach" them to the SQL server.
You can do this through the Data Tools in SBA/MOA.

Then to open the company, you need a new company file (sbc-file) which
is
the shortcut that points to the database.
You can use the "Rebuild company-file" button in the Data Tools to
generate
a new sbc-file that points to the database.

Let me know if that helps.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
I have SBA on my laptop in which the motherboard failed. I put the
HD
in
an
external USB enclosure and was able to save the contents of the HD.
I
installed SBA on a desktop computer in my office and need to move
the
database from my old HD to the desktop computer.

Where can I find the database on the old HD? Is it a simple matter
of
moving it from the old HD to the new desktop? The backup I have is
a
couple
of weeks old and I want to try and not lose the recent data.

Any suggestions?

Cheers!
 
R

Ron Anthony Quinn

Also... somehow I forgot to mention that this MOA 2007 dba that'as on the old
hard drive was integrated with BCM. If I think I am correct, does this dba
live in a different location?

I really have to get this running today as I have lost 3 days of work at
this point trying to move this dba over to a new machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Ron Anthony Quinn said:
Well, the dba from the old failed computer is MOA Professional 2007 and I am
(trying) to move it to an office desktop into MOA Professional 2007. The dba
in question was never part of SBA 2006. My company (I own) just moved from
QuickBooks 2006 to MOA Professional 2007 on 01 January 2007. It's just been
a nightmare to try and get the dba from the old hard drive to the new
computer.

So given that it's never been SBA 2006, are there any other suggestions?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
Ok, I see that I was mistaken on how it checks for this scenario - it
actually looks at a field in the database itself and not in the sbc-file.

When we upgrade a database from SBA 2006 to MOA 2007 we copy the whole
database from the old SQL instance "MICROSOFTSMLBIZ" to the new instance
"MSSMLBIZ" (this is because 2006 used MSDE 2000 while 2007 uses SQL Express
and they can be installed side-by-side).
So we copy the database and then "stamp" the old database so that we can
recognize that it has been upgraded in case anyone tries to use the old
database (which would usually not be what you wanted). And this is the
message you get when the database has been stamped that way.

So I'm guessing that the database you copied must already have been
upgraded/moved to 2007 and the database you really want is probably
somewhere else.
On the HD from the failed computer, you probably had both SBA 2006 and MOA
2007 and had already upgraded to 2007?
If that is the case then the data files would have been moved to the 2007
folders which is here: "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\"
Take a look at this folder on the HD from the failed computer and see if you
find the files there.

If you do, then please copy them to the new computer instead - you might
have to delete the database you already attached, using the delete
functionality in the Data Tools.


--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ron Anthony Quinn said:
Well... I have tried it both ways. I have manually edited the file and I
have used the file created from the rebuild and I get that same message
either way. It's pointing to the correct machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

This is because the sbc-file that you copied is pointing to the old
location
and this is interepreted by MOA 2007 as the company has been moved (hence
the message).
You should use the sbc-file that is created when you Rebuild from the
Data
Tools.

Alternately you can simply open the sbc-file in Notepad and edit the
information in it. If you know the computer name and exact database name
(i.e. from the rebuild-dialog where you see a list of databases), you can
just manually change the sbc-file.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Thanks for the information...

I went through the steps you provided in which I copied over the
[companyname].sbc file, then opened Data Tools and Attached the the
same
file, then went to Rebuild. When I tried to open an "Existing
Company", I
got an error that says, "This shortcuts points to a company that has
been
moved during upgrade or integration. Please use the shortcut that was
created when the company was moved or create a new shortcut from Data
Tools."

Ugh. Any other suggestions that may help?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Hi Ron

If you're talking about SBA 2006 then the actual data files are
located
in:
"C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTSMLBIZ\Data\".
In MOA 2007 the folder is:
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\" (where "1"
can
be another number if you have multiple instances of SQL Server).

The files you want to copy are called "[company name].sbd" and
"[company
name].sbl".
After you have copied them to your new installation you just need to
"attach" them to the SQL server.
You can do this through the Data Tools in SBA/MOA.

Then to open the company, you need a new company file (sbc-file) which
is
the shortcut that points to the database.
You can use the "Rebuild company-file" button in the Data Tools to
generate
a new sbc-file that points to the database.

Let me know if that helps.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
I have SBA on my laptop in which the motherboard failed. I put the
HD
in
an
external USB enclosure and was able to save the contents of the HD.
I
installed SBA on a desktop computer in my office and need to move
the
database from my old HD to the desktop computer.

Where can I find the database on the old HD? Is it a simple matter
of
moving it from the old HD to the new desktop? The backup I have is
a
couple
of weeks old and I want to try and not lose the recent data.

Any suggestions?

Cheers!
 
R

Ron Anthony Quinn

So there are no questions, here's the setup:

- Old hard drive on laptop with failed hard drive contained a MOA Pro 2007
dba and a BCM 2007 dba. They were integrated.
- Moving the MOA Pro 2007 dba to another PC so that we can keep doing my
company's accounting. MOA Pro 2007 is installed on this PC along with Office
2003. BCM has not been installed as of yet.
- In \My Documents\Small Business Accounting\Companies, the
networknerdsllc_2007.sbc files contents show:
database=NetworkNerds2007
server=NERD-M200\MSSMLBIZ,5356
- In \Program Files\Microsoft SQL Server\Mssql.1\Mssql\Data, the .sbd and
..sbl files I have are networknerds.sbd/.sbl and networknerds1.sbd.sbl.
- Under \Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager I have NetworkNerds2007.ldf/.mdf

The objective is to get the MOA 2007 dba from the old hard drive to the
alternate PC with MOA 2007 installed so I can continue to run my business.

I don't like to make comparisons, but with Quickbooks, it would have been as
easy as moving the (1) data file and opening the program. I am on Day Three
(3) of trying to move the MOA Pro 2007 dba from one computer to another and
have not experienced any degree of success. We made the switch on 01 January
2007 from QB to MOA 2007.

I cannot help but think that there HAS to be a way to accomplish this task.
At this point it would have been quicker to go back to QB and recreate the
year from scratch.

Please help!

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Ron Anthony Quinn said:
Also... somehow I forgot to mention that this MOA 2007 dba that'as on the old
hard drive was integrated with BCM. If I think I am correct, does this dba
live in a different location?

I really have to get this running today as I have lost 3 days of work at
this point trying to move this dba over to a new machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Ron Anthony Quinn said:
Well, the dba from the old failed computer is MOA Professional 2007 and I am
(trying) to move it to an office desktop into MOA Professional 2007. The dba
in question was never part of SBA 2006. My company (I own) just moved from
QuickBooks 2006 to MOA Professional 2007 on 01 January 2007. It's just been
a nightmare to try and get the dba from the old hard drive to the new
computer.

So given that it's never been SBA 2006, are there any other suggestions?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
Ok, I see that I was mistaken on how it checks for this scenario - it
actually looks at a field in the database itself and not in the sbc-file.

When we upgrade a database from SBA 2006 to MOA 2007 we copy the whole
database from the old SQL instance "MICROSOFTSMLBIZ" to the new instance
"MSSMLBIZ" (this is because 2006 used MSDE 2000 while 2007 uses SQL Express
and they can be installed side-by-side).
So we copy the database and then "stamp" the old database so that we can
recognize that it has been upgraded in case anyone tries to use the old
database (which would usually not be what you wanted). And this is the
message you get when the database has been stamped that way.

So I'm guessing that the database you copied must already have been
upgraded/moved to 2007 and the database you really want is probably
somewhere else.
On the HD from the failed computer, you probably had both SBA 2006 and MOA
2007 and had already upgraded to 2007?
If that is the case then the data files would have been moved to the 2007
folders which is here: "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\"
Take a look at this folder on the HD from the failed computer and see if you
find the files there.

If you do, then please copy them to the new computer instead - you might
have to delete the database you already attached, using the delete
functionality in the Data Tools.


--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Well... I have tried it both ways. I have manually edited the file and I
have used the file created from the rebuild and I get that same message
either way. It's pointing to the correct machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

This is because the sbc-file that you copied is pointing to the old
location
and this is interepreted by MOA 2007 as the company has been moved (hence
the message).
You should use the sbc-file that is created when you Rebuild from the
Data
Tools.

Alternately you can simply open the sbc-file in Notepad and edit the
information in it. If you know the computer name and exact database name
(i.e. from the rebuild-dialog where you see a list of databases), you can
just manually change the sbc-file.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Thanks for the information...

I went through the steps you provided in which I copied over the
[companyname].sbc file, then opened Data Tools and Attached the the
same
file, then went to Rebuild. When I tried to open an "Existing
Company", I
got an error that says, "This shortcuts points to a company that has
been
moved during upgrade or integration. Please use the shortcut that was
created when the company was moved or create a new shortcut from Data
Tools."

Ugh. Any other suggestions that may help?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Hi Ron

If you're talking about SBA 2006 then the actual data files are
located
in:
"C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTSMLBIZ\Data\".
In MOA 2007 the folder is:
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\" (where "1"
can
be another number if you have multiple instances of SQL Server).

The files you want to copy are called "[company name].sbd" and
"[company
name].sbl".
After you have copied them to your new installation you just need to
"attach" them to the SQL server.
You can do this through the Data Tools in SBA/MOA.

Then to open the company, you need a new company file (sbc-file) which
is
the shortcut that points to the database.
You can use the "Rebuild company-file" button in the Data Tools to
generate
a new sbc-file that points to the database.

Let me know if that helps.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
I have SBA on my laptop in which the motherboard failed. I put the
HD
in
an
external USB enclosure and was able to save the contents of the HD.
I
installed SBA on a desktop computer in my office and need to move
the
database from my old HD to the desktop computer.

Where can I find the database on the old HD? Is it a simple matter
of
moving it from the old HD to the new desktop? The backup I have is
a
couple
of weeks old and I want to try and not lose the recent data.

Any suggestions?

Cheers!
 
J

Jesper [MS]

Yes, I didn't mention this but the exact same scenario happens when
integrating with BCM - the data is copied into the other database (the BCM
database in this case) and the old database is stamped.
So if you can find the BCM database that is where your data really is.
It sounds like that is the database located here:
...\Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager\NetworkNerds2007.ldf/.mdf

Since this is a BCM database (with MOA data included) you need to use the
Data Tools in BCM to attach it again.

I'm sorry for the trouble you have getting the data up and running again.
Once you know where the data is, moving it around is normally a fairly
simple operation - of course backup/restore is often the best approach
instead.
But I hope this will help you.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ron Anthony Quinn said:
So there are no questions, here's the setup:

- Old hard drive on laptop with failed hard drive contained a MOA Pro 2007
dba and a BCM 2007 dba. They were integrated.
- Moving the MOA Pro 2007 dba to another PC so that we can keep doing my
company's accounting. MOA Pro 2007 is installed on this PC along with
Office
2003. BCM has not been installed as of yet.
- In \My Documents\Small Business Accounting\Companies, the
networknerdsllc_2007.sbc files contents show:
database=NetworkNerds2007
server=NERD-M200\MSSMLBIZ,5356
- In \Program Files\Microsoft SQL Server\Mssql.1\Mssql\Data, the .sbd and
.sbl files I have are networknerds.sbd/.sbl and networknerds1.sbd.sbl.
- Under \Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager I have NetworkNerds2007.ldf/.mdf

The objective is to get the MOA 2007 dba from the old hard drive to the
alternate PC with MOA 2007 installed so I can continue to run my business.

I don't like to make comparisons, but with Quickbooks, it would have been
as
easy as moving the (1) data file and opening the program. I am on Day
Three
(3) of trying to move the MOA Pro 2007 dba from one computer to another
and
have not experienced any degree of success. We made the switch on 01
January
2007 from QB to MOA 2007.

I cannot help but think that there HAS to be a way to accomplish this
task.
At this point it would have been quicker to go back to QB and recreate the
year from scratch.

Please help!

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Ron Anthony Quinn said:
Also... somehow I forgot to mention that this MOA 2007 dba that'as on the
old
hard drive was integrated with BCM. If I think I am correct, does this
dba
live in a different location?

I really have to get this running today as I have lost 3 days of work at
this point trying to move this dba over to a new machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Ron Anthony Quinn said:
Well, the dba from the old failed computer is MOA Professional 2007 and
I am
(trying) to move it to an office desktop into MOA Professional 2007.
The dba
in question was never part of SBA 2006. My company (I own) just moved
from
QuickBooks 2006 to MOA Professional 2007 on 01 January 2007. It's just
been
a nightmare to try and get the dba from the old hard drive to the new
computer.

So given that it's never been SBA 2006, are there any other
suggestions?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Ok, I see that I was mistaken on how it checks for this scenario - it
actually looks at a field in the database itself and not in the
sbc-file.

When we upgrade a database from SBA 2006 to MOA 2007 we copy the
whole
database from the old SQL instance "MICROSOFTSMLBIZ" to the new
instance
"MSSMLBIZ" (this is because 2006 used MSDE 2000 while 2007 uses SQL
Express
and they can be installed side-by-side).
So we copy the database and then "stamp" the old database so that we
can
recognize that it has been upgraded in case anyone tries to use the
old
database (which would usually not be what you wanted). And this is
the
message you get when the database has been stamped that way.

So I'm guessing that the database you copied must already have been
upgraded/moved to 2007 and the database you really want is probably
somewhere else.
On the HD from the failed computer, you probably had both SBA 2006
and MOA
2007 and had already upgraded to 2007?
If that is the case then the data files would have been moved to the
2007
folders which is here: "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\"
Take a look at this folder on the HD from the failed computer and see
if you
find the files there.

If you do, then please copy them to the new computer instead - you
might
have to delete the database you already attached, using the delete
functionality in the Data Tools.


--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
Well... I have tried it both ways. I have manually edited the file
and I
have used the file created from the rebuild and I get that same
message
either way. It's pointing to the correct machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

This is because the sbc-file that you copied is pointing to the
old
location
and this is interepreted by MOA 2007 as the company has been moved
(hence
the message).
You should use the sbc-file that is created when you Rebuild from
the
Data
Tools.

Alternately you can simply open the sbc-file in Notepad and edit
the
information in it. If you know the computer name and exact
database name
(i.e. from the rebuild-dialog where you see a list of databases),
you can
just manually change the sbc-file.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
Thanks for the information...

I went through the steps you provided in which I copied over the
[companyname].sbc file, then opened Data Tools and Attached the
the
same
file, then went to Rebuild. When I tried to open an "Existing
Company", I
got an error that says, "This shortcuts points to a company that
has
been
moved during upgrade or integration. Please use the shortcut
that was
created when the company was moved or create a new shortcut from
Data
Tools."

Ugh. Any other suggestions that may help?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Hi Ron

If you're talking about SBA 2006 then the actual data files are
located
in:
"C:\Program Files\Microsoft SQL
Server\MSSQL$MICROSOFTSMLBIZ\Data\".
In MOA 2007 the folder is:
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\"
(where "1"
can
be another number if you have multiple instances of SQL
Server).

The files you want to copy are called "[company name].sbd" and
"[company
name].sbl".
After you have copied them to your new installation you just
need to
"attach" them to the SQL server.
You can do this through the Data Tools in SBA/MOA.

Then to open the company, you need a new company file
(sbc-file) which
is
the shortcut that points to the database.
You can use the "Rebuild company-file" button in the Data Tools
to
generate
a new sbc-file that points to the database.

Let me know if that helps.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
I have SBA on my laptop in which the motherboard failed. I
put the
HD
in
an
external USB enclosure and was able to save the contents of
the HD.
I
installed SBA on a desktop computer in my office and need to
move
the
database from my old HD to the desktop computer.

Where can I find the database on the old HD? Is it a simple
matter
of
moving it from the old HD to the new desktop? The backup I
have is
a
couple
of weeks old and I want to try and not lose the recent data.

Any suggestions?

Cheers!
 
R

Ron Anthony Quinn

So then once i get BCM 2003 installed on this machine, I should be able to
move the data (you were correct in the location) and load it.

Question. Once BCM is installed and I move the dba, do all I need to do is
attach the data via BCM Data Tools? Once that is done, all I need to do is
open MOA 2007? Or is there another step in MOA 2007? Will I need to point
MOA 2007 to the dba location?

I'm very green with this software, so thanks for your help. Backups in the
future will be more frequent. I was on the road for a few weeks and just
didn't backup to removable media. I normally backup to my office server.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
Yes, I didn't mention this but the exact same scenario happens when
integrating with BCM - the data is copied into the other database (the BCM
database in this case) and the old database is stamped.
So if you can find the BCM database that is where your data really is.
It sounds like that is the database located here:
..\Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager\NetworkNerds2007.ldf/.mdf

Since this is a BCM database (with MOA data included) you need to use the
Data Tools in BCM to attach it again.

I'm sorry for the trouble you have getting the data up and running again.
Once you know where the data is, moving it around is normally a fairly
simple operation - of course backup/restore is often the best approach
instead.
But I hope this will help you.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ron Anthony Quinn said:
So there are no questions, here's the setup:

- Old hard drive on laptop with failed hard drive contained a MOA Pro 2007
dba and a BCM 2007 dba. They were integrated.
- Moving the MOA Pro 2007 dba to another PC so that we can keep doing my
company's accounting. MOA Pro 2007 is installed on this PC along with
Office
2003. BCM has not been installed as of yet.
- In \My Documents\Small Business Accounting\Companies, the
networknerdsllc_2007.sbc files contents show:
database=NetworkNerds2007
server=NERD-M200\MSSMLBIZ,5356
- In \Program Files\Microsoft SQL Server\Mssql.1\Mssql\Data, the .sbd and
.sbl files I have are networknerds.sbd/.sbl and networknerds1.sbd.sbl.
- Under \Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager I have NetworkNerds2007.ldf/.mdf

The objective is to get the MOA 2007 dba from the old hard drive to the
alternate PC with MOA 2007 installed so I can continue to run my business.

I don't like to make comparisons, but with Quickbooks, it would have been
as
easy as moving the (1) data file and opening the program. I am on Day
Three
(3) of trying to move the MOA Pro 2007 dba from one computer to another
and
have not experienced any degree of success. We made the switch on 01
January
2007 from QB to MOA 2007.

I cannot help but think that there HAS to be a way to accomplish this
task.
At this point it would have been quicker to go back to QB and recreate the
year from scratch.

Please help!

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Ron Anthony Quinn said:
Also... somehow I forgot to mention that this MOA 2007 dba that'as on the
old
hard drive was integrated with BCM. If I think I am correct, does this
dba
live in a different location?

I really have to get this running today as I have lost 3 days of work at
this point trying to move this dba over to a new machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Well, the dba from the old failed computer is MOA Professional 2007 and
I am
(trying) to move it to an office desktop into MOA Professional 2007.
The dba
in question was never part of SBA 2006. My company (I own) just moved
from
QuickBooks 2006 to MOA Professional 2007 on 01 January 2007. It's just
been
a nightmare to try and get the dba from the old hard drive to the new
computer.

So given that it's never been SBA 2006, are there any other
suggestions?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Ok, I see that I was mistaken on how it checks for this scenario - it
actually looks at a field in the database itself and not in the
sbc-file.

When we upgrade a database from SBA 2006 to MOA 2007 we copy the
whole
database from the old SQL instance "MICROSOFTSMLBIZ" to the new
instance
"MSSMLBIZ" (this is because 2006 used MSDE 2000 while 2007 uses SQL
Express
and they can be installed side-by-side).
So we copy the database and then "stamp" the old database so that we
can
recognize that it has been upgraded in case anyone tries to use the
old
database (which would usually not be what you wanted). And this is
the
message you get when the database has been stamped that way.

So I'm guessing that the database you copied must already have been
upgraded/moved to 2007 and the database you really want is probably
somewhere else.
On the HD from the failed computer, you probably had both SBA 2006
and MOA
2007 and had already upgraded to 2007?
If that is the case then the data files would have been moved to the
2007
folders which is here: "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\"
Take a look at this folder on the HD from the failed computer and see
if you
find the files there.

If you do, then please copy them to the new computer instead - you
might
have to delete the database you already attached, using the delete
functionality in the Data Tools.


--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
Well... I have tried it both ways. I have manually edited the file
and I
have used the file created from the rebuild and I get that same
message
either way. It's pointing to the correct machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

This is because the sbc-file that you copied is pointing to the
old
location
and this is interepreted by MOA 2007 as the company has been moved
(hence
the message).
You should use the sbc-file that is created when you Rebuild from
the
Data
Tools.

Alternately you can simply open the sbc-file in Notepad and edit
the
information in it. If you know the computer name and exact
database name
(i.e. from the rebuild-dialog where you see a list of databases),
you can
just manually change the sbc-file.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
Thanks for the information...

I went through the steps you provided in which I copied over the
[companyname].sbc file, then opened Data Tools and Attached the
the
same
file, then went to Rebuild. When I tried to open an "Existing
Company", I
got an error that says, "This shortcuts points to a company that
has
been
moved during upgrade or integration. Please use the shortcut
that was
created when the company was moved or create a new shortcut from
Data
Tools."

Ugh. Any other suggestions that may help?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Hi Ron

If you're talking about SBA 2006 then the actual data files are
located
in:
"C:\Program Files\Microsoft SQL
Server\MSSQL$MICROSOFTSMLBIZ\Data\".
In MOA 2007 the folder is:
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\"
(where "1"
can
be another number if you have multiple instances of SQL
Server).

The files you want to copy are called "[company name].sbd" and
"[company
name].sbl".
After you have copied them to your new installation you just
need to
"attach" them to the SQL server.
You can do this through the Data Tools in SBA/MOA.

Then to open the company, you need a new company file
(sbc-file) which
is
the shortcut that points to the database.
You can use the "Rebuild company-file" button in the Data Tools
to
generate
a new sbc-file that points to the database.

Let me know if that helps.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
I have SBA on my laptop in which the motherboard failed. I
put the
HD
in
an
external USB enclosure and was able to save the contents of
the HD.
I
installed SBA on a desktop computer in my office and need to
move
the
database from my old HD to the desktop computer.

Where can I find the database on the old HD? Is it a simple
matter
of
moving it from the old HD to the new desktop? The backup I
have is
a
couple
of weeks old and I want to try and not lose the recent data.

Any suggestions?

Cheers!
 
Ad

Advertisements

J

Jesper [MS]

Yes, I think the best approach is to install BCM and use that to attach the
data files.

You will need an sbc-file for MOA that points to this database.
If you don't have one already or don't want to edit one manually, you should
just use the Rebuild option in the MOA Data Tools which should recognize the
BCM database as a MOA database and let you select it in the list of
databases.
Let me know if you run into any issues.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ron Anthony Quinn said:
So then once i get BCM 2003 installed on this machine, I should be able to
move the data (you were correct in the location) and load it.

Question. Once BCM is installed and I move the dba, do all I need to do
is
attach the data via BCM Data Tools? Once that is done, all I need to do
is
open MOA 2007? Or is there another step in MOA 2007? Will I need to
point
MOA 2007 to the dba location?

I'm very green with this software, so thanks for your help. Backups in
the
future will be more frequent. I was on the road for a few weeks and just
didn't backup to removable media. I normally backup to my office server.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
Yes, I didn't mention this but the exact same scenario happens when
integrating with BCM - the data is copied into the other database (the
BCM
database in this case) and the old database is stamped.
So if you can find the BCM database that is where your data really is.
It sounds like that is the database located here:
..\Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager\NetworkNerds2007.ldf/.mdf

Since this is a BCM database (with MOA data included) you need to use the
Data Tools in BCM to attach it again.

I'm sorry for the trouble you have getting the data up and running again.
Once you know where the data is, moving it around is normally a fairly
simple operation - of course backup/restore is often the best approach
instead.
But I hope this will help you.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ron Anthony Quinn said:
So there are no questions, here's the setup:

- Old hard drive on laptop with failed hard drive contained a MOA Pro
2007
dba and a BCM 2007 dba. They were integrated.
- Moving the MOA Pro 2007 dba to another PC so that we can keep doing
my
company's accounting. MOA Pro 2007 is installed on this PC along with
Office
2003. BCM has not been installed as of yet.
- In \My Documents\Small Business Accounting\Companies, the
networknerdsllc_2007.sbc files contents show:
database=NetworkNerds2007
server=NERD-M200\MSSMLBIZ,5356
- In \Program Files\Microsoft SQL Server\Mssql.1\Mssql\Data, the .sbd
and
.sbl files I have are networknerds.sbd/.sbl and networknerds1.sbd.sbl.
- Under \Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager I have
NetworkNerds2007.ldf/.mdf

The objective is to get the MOA 2007 dba from the old hard drive to the
alternate PC with MOA 2007 installed so I can continue to run my
business.

I don't like to make comparisons, but with Quickbooks, it would have
been
as
easy as moving the (1) data file and opening the program. I am on Day
Three
(3) of trying to move the MOA Pro 2007 dba from one computer to another
and
have not experienced any degree of success. We made the switch on 01
January
2007 from QB to MOA 2007.

I cannot help but think that there HAS to be a way to accomplish this
task.
At this point it would have been quicker to go back to QB and recreate
the
year from scratch.

Please help!

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Also... somehow I forgot to mention that this MOA 2007 dba that'as on
the
old
hard drive was integrated with BCM. If I think I am correct, does
this
dba
live in a different location?

I really have to get this running today as I have lost 3 days of work
at
this point trying to move this dba over to a new machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Well, the dba from the old failed computer is MOA Professional 2007
and
I am
(trying) to move it to an office desktop into MOA Professional 2007.
The dba
in question was never part of SBA 2006. My company (I own) just
moved
from
QuickBooks 2006 to MOA Professional 2007 on 01 January 2007. It's
just
been
a nightmare to try and get the dba from the old hard drive to the
new
computer.

So given that it's never been SBA 2006, are there any other
suggestions?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Ok, I see that I was mistaken on how it checks for this scenario -
it
actually looks at a field in the database itself and not in the
sbc-file.

When we upgrade a database from SBA 2006 to MOA 2007 we copy the
whole
database from the old SQL instance "MICROSOFTSMLBIZ" to the new
instance
"MSSMLBIZ" (this is because 2006 used MSDE 2000 while 2007 uses
SQL
Express
and they can be installed side-by-side).
So we copy the database and then "stamp" the old database so that
we
can
recognize that it has been upgraded in case anyone tries to use
the
old
database (which would usually not be what you wanted). And this is
the
message you get when the database has been stamped that way.

So I'm guessing that the database you copied must already have
been
upgraded/moved to 2007 and the database you really want is
probably
somewhere else.
On the HD from the failed computer, you probably had both SBA 2006
and MOA
2007 and had already upgraded to 2007?
If that is the case then the data files would have been moved to
the
2007
folders which is here: "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\"
Take a look at this folder on the HD from the failed computer and
see
if you
find the files there.

If you do, then please copy them to the new computer instead - you
might
have to delete the database you already attached, using the delete
functionality in the Data Tools.


--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
Well... I have tried it both ways. I have manually edited the
file
and I
have used the file created from the rebuild and I get that same
message
either way. It's pointing to the correct machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

This is because the sbc-file that you copied is pointing to the
old
location
and this is interepreted by MOA 2007 as the company has been
moved
(hence
the message).
You should use the sbc-file that is created when you Rebuild
from
the
Data
Tools.

Alternately you can simply open the sbc-file in Notepad and
edit
the
information in it. If you know the computer name and exact
database name
(i.e. from the rebuild-dialog where you see a list of
databases),
you can
just manually change the sbc-file.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
Thanks for the information...

I went through the steps you provided in which I copied over
the
[companyname].sbc file, then opened Data Tools and Attached
the
the
same
file, then went to Rebuild. When I tried to open an
"Existing
Company", I
got an error that says, "This shortcuts points to a company
that
has
been
moved during upgrade or integration. Please use the shortcut
that was
created when the company was moved or create a new shortcut
from
Data
Tools."

Ugh. Any other suggestions that may help?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Hi Ron

If you're talking about SBA 2006 then the actual data files
are
located
in:
"C:\Program Files\Microsoft SQL
Server\MSSQL$MICROSOFTSMLBIZ\Data\".
In MOA 2007 the folder is:
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\"
(where "1"
can
be another number if you have multiple instances of SQL
Server).

The files you want to copy are called "[company name].sbd"
and
"[company
name].sbl".
After you have copied them to your new installation you just
need to
"attach" them to the SQL server.
You can do this through the Data Tools in SBA/MOA.

Then to open the company, you need a new company file
(sbc-file) which
is
the shortcut that points to the database.
You can use the "Rebuild company-file" button in the Data
Tools
to
generate
a new sbc-file that points to the database.

Let me know if that helps.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


in
message
I have SBA on my laptop in which the motherboard failed. I
put the
HD
in
an
external USB enclosure and was able to save the contents
of
the HD.
I
installed SBA on a desktop computer in my office and need
to
move
the
database from my old HD to the desktop computer.

Where can I find the database on the old HD? Is it a
simple
matter
of
moving it from the old HD to the new desktop? The backup
I
have is
a
couple
of weeks old and I want to try and not lose the recent
data.

Any suggestions?

Cheers!
 
R

Ron Anthony Quinn

Thanks for all your help! I am eternally grateful if it all works. I will
install BCM this evening when I get back to my office and let you know.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
Yes, I think the best approach is to install BCM and use that to attach the
data files.

You will need an sbc-file for MOA that points to this database.
If you don't have one already or don't want to edit one manually, you should
just use the Rebuild option in the MOA Data Tools which should recognize the
BCM database as a MOA database and let you select it in the list of
databases.
Let me know if you run into any issues.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ron Anthony Quinn said:
So then once i get BCM 2003 installed on this machine, I should be able to
move the data (you were correct in the location) and load it.

Question. Once BCM is installed and I move the dba, do all I need to do
is
attach the data via BCM Data Tools? Once that is done, all I need to do
is
open MOA 2007? Or is there another step in MOA 2007? Will I need to
point
MOA 2007 to the dba location?

I'm very green with this software, so thanks for your help. Backups in
the
future will be more frequent. I was on the road for a few weeks and just
didn't backup to removable media. I normally backup to my office server.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
Yes, I didn't mention this but the exact same scenario happens when
integrating with BCM - the data is copied into the other database (the
BCM
database in this case) and the old database is stamped.
So if you can find the BCM database that is where your data really is.
It sounds like that is the database located here:
..\Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager\NetworkNerds2007.ldf/.mdf

Since this is a BCM database (with MOA data included) you need to use the
Data Tools in BCM to attach it again.

I'm sorry for the trouble you have getting the data up and running again.
Once you know where the data is, moving it around is normally a fairly
simple operation - of course backup/restore is often the best approach
instead.
But I hope this will help you.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


So there are no questions, here's the setup:

- Old hard drive on laptop with failed hard drive contained a MOA Pro
2007
dba and a BCM 2007 dba. They were integrated.
- Moving the MOA Pro 2007 dba to another PC so that we can keep doing
my
company's accounting. MOA Pro 2007 is installed on this PC along with
Office
2003. BCM has not been installed as of yet.
- In \My Documents\Small Business Accounting\Companies, the
networknerdsllc_2007.sbc files contents show:
database=NetworkNerds2007
server=NERD-M200\MSSMLBIZ,5356
- In \Program Files\Microsoft SQL Server\Mssql.1\Mssql\Data, the .sbd
and
.sbl files I have are networknerds.sbd/.sbl and networknerds1.sbd.sbl.
- Under \Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager I have
NetworkNerds2007.ldf/.mdf

The objective is to get the MOA 2007 dba from the old hard drive to the
alternate PC with MOA 2007 installed so I can continue to run my
business.

I don't like to make comparisons, but with Quickbooks, it would have
been
as
easy as moving the (1) data file and opening the program. I am on Day
Three
(3) of trying to move the MOA Pro 2007 dba from one computer to another
and
have not experienced any degree of success. We made the switch on 01
January
2007 from QB to MOA 2007.

I cannot help but think that there HAS to be a way to accomplish this
task.
At this point it would have been quicker to go back to QB and recreate
the
year from scratch.

Please help!

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Also... somehow I forgot to mention that this MOA 2007 dba that'as on
the
old
hard drive was integrated with BCM. If I think I am correct, does
this
dba
live in a different location?

I really have to get this running today as I have lost 3 days of work
at
this point trying to move this dba over to a new machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Well, the dba from the old failed computer is MOA Professional 2007
and
I am
(trying) to move it to an office desktop into MOA Professional 2007.
The dba
in question was never part of SBA 2006. My company (I own) just
moved
from
QuickBooks 2006 to MOA Professional 2007 on 01 January 2007. It's
just
been
a nightmare to try and get the dba from the old hard drive to the
new
computer.

So given that it's never been SBA 2006, are there any other
suggestions?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Ok, I see that I was mistaken on how it checks for this scenario -
it
actually looks at a field in the database itself and not in the
sbc-file.

When we upgrade a database from SBA 2006 to MOA 2007 we copy the
whole
database from the old SQL instance "MICROSOFTSMLBIZ" to the new
instance
"MSSMLBIZ" (this is because 2006 used MSDE 2000 while 2007 uses
SQL
Express
and they can be installed side-by-side).
So we copy the database and then "stamp" the old database so that
we
can
recognize that it has been upgraded in case anyone tries to use
the
old
database (which would usually not be what you wanted). And this is
the
message you get when the database has been stamped that way.

So I'm guessing that the database you copied must already have
been
upgraded/moved to 2007 and the database you really want is
probably
somewhere else.
On the HD from the failed computer, you probably had both SBA 2006
and MOA
2007 and had already upgraded to 2007?
If that is the case then the data files would have been moved to
the
2007
folders which is here: "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\"
Take a look at this folder on the HD from the failed computer and
see
if you
find the files there.

If you do, then please copy them to the new computer instead - you
might
have to delete the database you already attached, using the delete
functionality in the Data Tools.


--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
Well... I have tried it both ways. I have manually edited the
file
and I
have used the file created from the rebuild and I get that same
message
either way. It's pointing to the correct machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

This is because the sbc-file that you copied is pointing to the
old
location
and this is interepreted by MOA 2007 as the company has been
moved
(hence
the message).
You should use the sbc-file that is created when you Rebuild
from
the
Data
Tools.

Alternately you can simply open the sbc-file in Notepad and
edit
the
information in it. If you know the computer name and exact
database name
(i.e. from the rebuild-dialog where you see a list of
databases),
you can
just manually change the sbc-file.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
Thanks for the information...

I went through the steps you provided in which I copied over
the
[companyname].sbc file, then opened Data Tools and Attached
the
the
same
file, then went to Rebuild. When I tried to open an
"Existing
Company", I
got an error that says, "This shortcuts points to a company
that
has
been
moved during upgrade or integration. Please use the shortcut
that was
created when the company was moved or create a new shortcut
from
Data
Tools."

Ugh. Any other suggestions that may help?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


"Jesper [MS]" wrote:
 
R

Ron Anthony Quinn

Well, I got BCM installed for OL2003... now how do I attach it and have MOA
2007 see it? I have gone through all the BCM tools and can find no way of
accomplishing this objective?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Ron Anthony Quinn said:
Thanks for all your help! I am eternally grateful if it all works. I will
install BCM this evening when I get back to my office and let you know.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
Yes, I think the best approach is to install BCM and use that to attach the
data files.

You will need an sbc-file for MOA that points to this database.
If you don't have one already or don't want to edit one manually, you should
just use the Rebuild option in the MOA Data Tools which should recognize the
BCM database as a MOA database and let you select it in the list of
databases.
Let me know if you run into any issues.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ron Anthony Quinn said:
So then once i get BCM 2003 installed on this machine, I should be able to
move the data (you were correct in the location) and load it.

Question. Once BCM is installed and I move the dba, do all I need to do
is
attach the data via BCM Data Tools? Once that is done, all I need to do
is
open MOA 2007? Or is there another step in MOA 2007? Will I need to
point
MOA 2007 to the dba location?

I'm very green with this software, so thanks for your help. Backups in
the
future will be more frequent. I was on the road for a few weeks and just
didn't backup to removable media. I normally backup to my office server.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Yes, I didn't mention this but the exact same scenario happens when
integrating with BCM - the data is copied into the other database (the
BCM
database in this case) and the old database is stamped.
So if you can find the BCM database that is where your data really is.
It sounds like that is the database located here:
..\Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager\NetworkNerds2007.ldf/.mdf

Since this is a BCM database (with MOA data included) you need to use the
Data Tools in BCM to attach it again.

I'm sorry for the trouble you have getting the data up and running again.
Once you know where the data is, moving it around is normally a fairly
simple operation - of course backup/restore is often the best approach
instead.
But I hope this will help you.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


So there are no questions, here's the setup:

- Old hard drive on laptop with failed hard drive contained a MOA Pro
2007
dba and a BCM 2007 dba. They were integrated.
- Moving the MOA Pro 2007 dba to another PC so that we can keep doing
my
company's accounting. MOA Pro 2007 is installed on this PC along with
Office
2003. BCM has not been installed as of yet.
- In \My Documents\Small Business Accounting\Companies, the
networknerdsllc_2007.sbc files contents show:
database=NetworkNerds2007
server=NERD-M200\MSSMLBIZ,5356
- In \Program Files\Microsoft SQL Server\Mssql.1\Mssql\Data, the .sbd
and
.sbl files I have are networknerds.sbd/.sbl and networknerds1.sbd.sbl.
- Under \Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager I have
NetworkNerds2007.ldf/.mdf

The objective is to get the MOA 2007 dba from the old hard drive to the
alternate PC with MOA 2007 installed so I can continue to run my
business.

I don't like to make comparisons, but with Quickbooks, it would have
been
as
easy as moving the (1) data file and opening the program. I am on Day
Three
(3) of trying to move the MOA Pro 2007 dba from one computer to another
and
have not experienced any degree of success. We made the switch on 01
January
2007 from QB to MOA 2007.

I cannot help but think that there HAS to be a way to accomplish this
task.
At this point it would have been quicker to go back to QB and recreate
the
year from scratch.

Please help!

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Also... somehow I forgot to mention that this MOA 2007 dba that'as on
the
old
hard drive was integrated with BCM. If I think I am correct, does
this
dba
live in a different location?

I really have to get this running today as I have lost 3 days of work
at
this point trying to move this dba over to a new machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Well, the dba from the old failed computer is MOA Professional 2007
and
I am
(trying) to move it to an office desktop into MOA Professional 2007.
The dba
in question was never part of SBA 2006. My company (I own) just
moved
from
QuickBooks 2006 to MOA Professional 2007 on 01 January 2007. It's
just
been
a nightmare to try and get the dba from the old hard drive to the
new
computer.

So given that it's never been SBA 2006, are there any other
suggestions?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Ok, I see that I was mistaken on how it checks for this scenario -
it
actually looks at a field in the database itself and not in the
sbc-file.

When we upgrade a database from SBA 2006 to MOA 2007 we copy the
whole
database from the old SQL instance "MICROSOFTSMLBIZ" to the new
instance
"MSSMLBIZ" (this is because 2006 used MSDE 2000 while 2007 uses
SQL
Express
and they can be installed side-by-side).
So we copy the database and then "stamp" the old database so that
we
can
recognize that it has been upgraded in case anyone tries to use
the
old
database (which would usually not be what you wanted). And this is
the
message you get when the database has been stamped that way.

So I'm guessing that the database you copied must already have
been
upgraded/moved to 2007 and the database you really want is
probably
somewhere else.
On the HD from the failed computer, you probably had both SBA 2006
and MOA
2007 and had already upgraded to 2007?
If that is the case then the data files would have been moved to
the
2007
folders which is here: "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\"
Take a look at this folder on the HD from the failed computer and
see
if you
find the files there.

If you do, then please copy them to the new computer instead - you
might
have to delete the database you already attached, using the delete
functionality in the Data Tools.


--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
Well... I have tried it both ways. I have manually edited the
file
and I
have used the file created from the rebuild and I get that same
message
either way. It's pointing to the correct machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

This is because the sbc-file that you copied is pointing to the
old
location
and this is interepreted by MOA 2007 as the company has been
moved
(hence
the message).
You should use the sbc-file that is created when you Rebuild
from
the
Data
Tools.

Alternately you can simply open the sbc-file in Notepad and
edit
the
information in it. If you know the computer name and exact
database name
(i.e. from the rebuild-dialog where you see a list of
databases),
you can
just manually change the sbc-file.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
Thanks for the information...

I went through the steps you provided in which I copied over
the
[companyname].sbc file, then opened Data Tools and Attached
the
the
same
file, then went to Rebuild. When I tried to open an
"Existing
Company", I
got an error that says, "This shortcuts points to a company
that
has
been
moved during upgrade or integration. Please use the shortcut
that was
created when the company was moved or create a new shortcut
from
Data
 
R

Ron Anthony Quinn

I have posted that I still cannot get the dba attached for BCM and MOA '07.
Any help is appreciated PLEASE. Day 4 with no accounting and this is making
my head hurt. :)

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
Yes, I think the best approach is to install BCM and use that to attach the
data files.

You will need an sbc-file for MOA that points to this database.
If you don't have one already or don't want to edit one manually, you should
just use the Rebuild option in the MOA Data Tools which should recognize the
BCM database as a MOA database and let you select it in the list of
databases.
Let me know if you run into any issues.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ron Anthony Quinn said:
So then once i get BCM 2003 installed on this machine, I should be able to
move the data (you were correct in the location) and load it.

Question. Once BCM is installed and I move the dba, do all I need to do
is
attach the data via BCM Data Tools? Once that is done, all I need to do
is
open MOA 2007? Or is there another step in MOA 2007? Will I need to
point
MOA 2007 to the dba location?

I'm very green with this software, so thanks for your help. Backups in
the
future will be more frequent. I was on the road for a few weeks and just
didn't backup to removable media. I normally backup to my office server.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
Yes, I didn't mention this but the exact same scenario happens when
integrating with BCM - the data is copied into the other database (the
BCM
database in this case) and the old database is stamped.
So if you can find the BCM database that is where your data really is.
It sounds like that is the database located here:
..\Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager\NetworkNerds2007.ldf/.mdf

Since this is a BCM database (with MOA data included) you need to use the
Data Tools in BCM to attach it again.

I'm sorry for the trouble you have getting the data up and running again.
Once you know where the data is, moving it around is normally a fairly
simple operation - of course backup/restore is often the best approach
instead.
But I hope this will help you.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


So there are no questions, here's the setup:

- Old hard drive on laptop with failed hard drive contained a MOA Pro
2007
dba and a BCM 2007 dba. They were integrated.
- Moving the MOA Pro 2007 dba to another PC so that we can keep doing
my
company's accounting. MOA Pro 2007 is installed on this PC along with
Office
2003. BCM has not been installed as of yet.
- In \My Documents\Small Business Accounting\Companies, the
networknerdsllc_2007.sbc files contents show:
database=NetworkNerds2007
server=NERD-M200\MSSMLBIZ,5356
- In \Program Files\Microsoft SQL Server\Mssql.1\Mssql\Data, the .sbd
and
.sbl files I have are networknerds.sbd/.sbl and networknerds1.sbd.sbl.
- Under \Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager I have
NetworkNerds2007.ldf/.mdf

The objective is to get the MOA 2007 dba from the old hard drive to the
alternate PC with MOA 2007 installed so I can continue to run my
business.

I don't like to make comparisons, but with Quickbooks, it would have
been
as
easy as moving the (1) data file and opening the program. I am on Day
Three
(3) of trying to move the MOA Pro 2007 dba from one computer to another
and
have not experienced any degree of success. We made the switch on 01
January
2007 from QB to MOA 2007.

I cannot help but think that there HAS to be a way to accomplish this
task.
At this point it would have been quicker to go back to QB and recreate
the
year from scratch.

Please help!

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Also... somehow I forgot to mention that this MOA 2007 dba that'as on
the
old
hard drive was integrated with BCM. If I think I am correct, does
this
dba
live in a different location?

I really have to get this running today as I have lost 3 days of work
at
this point trying to move this dba over to a new machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Well, the dba from the old failed computer is MOA Professional 2007
and
I am
(trying) to move it to an office desktop into MOA Professional 2007.
The dba
in question was never part of SBA 2006. My company (I own) just
moved
from
QuickBooks 2006 to MOA Professional 2007 on 01 January 2007. It's
just
been
a nightmare to try and get the dba from the old hard drive to the
new
computer.

So given that it's never been SBA 2006, are there any other
suggestions?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Ok, I see that I was mistaken on how it checks for this scenario -
it
actually looks at a field in the database itself and not in the
sbc-file.

When we upgrade a database from SBA 2006 to MOA 2007 we copy the
whole
database from the old SQL instance "MICROSOFTSMLBIZ" to the new
instance
"MSSMLBIZ" (this is because 2006 used MSDE 2000 while 2007 uses
SQL
Express
and they can be installed side-by-side).
So we copy the database and then "stamp" the old database so that
we
can
recognize that it has been upgraded in case anyone tries to use
the
old
database (which would usually not be what you wanted). And this is
the
message you get when the database has been stamped that way.

So I'm guessing that the database you copied must already have
been
upgraded/moved to 2007 and the database you really want is
probably
somewhere else.
On the HD from the failed computer, you probably had both SBA 2006
and MOA
2007 and had already upgraded to 2007?
If that is the case then the data files would have been moved to
the
2007
folders which is here: "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\"
Take a look at this folder on the HD from the failed computer and
see
if you
find the files there.

If you do, then please copy them to the new computer instead - you
might
have to delete the database you already attached, using the delete
functionality in the Data Tools.


--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
Well... I have tried it both ways. I have manually edited the
file
and I
have used the file created from the rebuild and I get that same
message
either way. It's pointing to the correct machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

This is because the sbc-file that you copied is pointing to the
old
location
and this is interepreted by MOA 2007 as the company has been
moved
(hence
the message).
You should use the sbc-file that is created when you Rebuild
from
the
Data
Tools.

Alternately you can simply open the sbc-file in Notepad and
edit
the
information in it. If you know the computer name and exact
database name
(i.e. from the rebuild-dialog where you see a list of
databases),
you can
just manually change the sbc-file.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
Thanks for the information...

I went through the steps you provided in which I copied over
the
[companyname].sbc file, then opened Data Tools and Attached
the
the
same
file, then went to Rebuild. When I tried to open an
"Existing
Company", I
got an error that says, "This shortcuts points to a company
that
has
been
moved during upgrade or integration. Please use the shortcut
that was
created when the company was moved or create a new shortcut
from
Data
Tools."

Ugh. Any other suggestions that may help?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


"Jesper [MS]" wrote:
 
R

Ron Anthony Quinn

Hi Jesper... I have not seen a post from you in helping me get my MOA 2007
back online. Day Five is tomorrow with no accounting. If I can't get this
back online via your assistance, who can I call to get help? I will have to
make the move back to QB soon if I can't get my data back online. It can't
possibly be this hard, can it?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Ron Anthony Quinn said:
I have posted that I still cannot get the dba attached for BCM and MOA '07.
Any help is appreciated PLEASE. Day 4 with no accounting and this is making
my head hurt. :)

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
Yes, I think the best approach is to install BCM and use that to attach the
data files.

You will need an sbc-file for MOA that points to this database.
If you don't have one already or don't want to edit one manually, you should
just use the Rebuild option in the MOA Data Tools which should recognize the
BCM database as a MOA database and let you select it in the list of
databases.
Let me know if you run into any issues.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ron Anthony Quinn said:
So then once i get BCM 2003 installed on this machine, I should be able to
move the data (you were correct in the location) and load it.

Question. Once BCM is installed and I move the dba, do all I need to do
is
attach the data via BCM Data Tools? Once that is done, all I need to do
is
open MOA 2007? Or is there another step in MOA 2007? Will I need to
point
MOA 2007 to the dba location?

I'm very green with this software, so thanks for your help. Backups in
the
future will be more frequent. I was on the road for a few weeks and just
didn't backup to removable media. I normally backup to my office server.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Yes, I didn't mention this but the exact same scenario happens when
integrating with BCM - the data is copied into the other database (the
BCM
database in this case) and the old database is stamped.
So if you can find the BCM database that is where your data really is.
It sounds like that is the database located here:
..\Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager\NetworkNerds2007.ldf/.mdf

Since this is a BCM database (with MOA data included) you need to use the
Data Tools in BCM to attach it again.

I'm sorry for the trouble you have getting the data up and running again.
Once you know where the data is, moving it around is normally a fairly
simple operation - of course backup/restore is often the best approach
instead.
But I hope this will help you.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


So there are no questions, here's the setup:

- Old hard drive on laptop with failed hard drive contained a MOA Pro
2007
dba and a BCM 2007 dba. They were integrated.
- Moving the MOA Pro 2007 dba to another PC so that we can keep doing
my
company's accounting. MOA Pro 2007 is installed on this PC along with
Office
2003. BCM has not been installed as of yet.
- In \My Documents\Small Business Accounting\Companies, the
networknerdsllc_2007.sbc files contents show:
database=NetworkNerds2007
server=NERD-M200\MSSMLBIZ,5356
- In \Program Files\Microsoft SQL Server\Mssql.1\Mssql\Data, the .sbd
and
.sbl files I have are networknerds.sbd/.sbl and networknerds1.sbd.sbl.
- Under \Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager I have
NetworkNerds2007.ldf/.mdf

The objective is to get the MOA 2007 dba from the old hard drive to the
alternate PC with MOA 2007 installed so I can continue to run my
business.

I don't like to make comparisons, but with Quickbooks, it would have
been
as
easy as moving the (1) data file and opening the program. I am on Day
Three
(3) of trying to move the MOA Pro 2007 dba from one computer to another
and
have not experienced any degree of success. We made the switch on 01
January
2007 from QB to MOA 2007.

I cannot help but think that there HAS to be a way to accomplish this
task.
At this point it would have been quicker to go back to QB and recreate
the
year from scratch.

Please help!

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Also... somehow I forgot to mention that this MOA 2007 dba that'as on
the
old
hard drive was integrated with BCM. If I think I am correct, does
this
dba
live in a different location?

I really have to get this running today as I have lost 3 days of work
at
this point trying to move this dba over to a new machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Well, the dba from the old failed computer is MOA Professional 2007
and
I am
(trying) to move it to an office desktop into MOA Professional 2007.
The dba
in question was never part of SBA 2006. My company (I own) just
moved
from
QuickBooks 2006 to MOA Professional 2007 on 01 January 2007. It's
just
been
a nightmare to try and get the dba from the old hard drive to the
new
computer.

So given that it's never been SBA 2006, are there any other
suggestions?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Ok, I see that I was mistaken on how it checks for this scenario -
it
actually looks at a field in the database itself and not in the
sbc-file.

When we upgrade a database from SBA 2006 to MOA 2007 we copy the
whole
database from the old SQL instance "MICROSOFTSMLBIZ" to the new
instance
"MSSMLBIZ" (this is because 2006 used MSDE 2000 while 2007 uses
SQL
Express
and they can be installed side-by-side).
So we copy the database and then "stamp" the old database so that
we
can
recognize that it has been upgraded in case anyone tries to use
the
old
database (which would usually not be what you wanted). And this is
the
message you get when the database has been stamped that way.

So I'm guessing that the database you copied must already have
been
upgraded/moved to 2007 and the database you really want is
probably
somewhere else.
On the HD from the failed computer, you probably had both SBA 2006
and MOA
2007 and had already upgraded to 2007?
If that is the case then the data files would have been moved to
the
2007
folders which is here: "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\"
Take a look at this folder on the HD from the failed computer and
see
if you
find the files there.

If you do, then please copy them to the new computer instead - you
might
have to delete the database you already attached, using the delete
functionality in the Data Tools.


--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
Well... I have tried it both ways. I have manually edited the
file
and I
have used the file created from the rebuild and I get that same
message
either way. It's pointing to the correct machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

This is because the sbc-file that you copied is pointing to the
old
location
and this is interepreted by MOA 2007 as the company has been
moved
(hence
the message).
You should use the sbc-file that is created when you Rebuild
from
the
Data
Tools.

Alternately you can simply open the sbc-file in Notepad and
edit
the
information in it. If you know the computer name and exact
database name
(i.e. from the rebuild-dialog where you see a list of
databases),
you can
just manually change the sbc-file.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
Thanks for the information...

I went through the steps you provided in which I copied over
the
[companyname].sbc file, then opened Data Tools and Attached
the
the
same
file, then went to Rebuild. When I tried to open an
"Existing
Company", I
got an error that says, "This shortcuts points to a company
that
has
been
moved during upgrade or integration. Please use the shortcut
that was
created when the company was moved or create a new shortcut
from
 
Ad

Advertisements

J

Jesper [MS]

Hi

No usually it is as simple as restoring a backup or reattaching the files.

If I understand you correctly then you have the files now and just need to
know how to use BCM to attach them.
I don't have BCM right here so I don't know where they have the data tools -
I'm pretty sure the are there somewhere.
Do you have a help file in your BCM installation which explains how to
attach the files? Or perhaps a support number - I'm sure direct help from
support would have solved this problem in one call. It's really a problem
that is easiest to solve hands-on.
But if you can find the BCM Data Tools I'm pretty sure that will solve the
rest of the problem.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ron Anthony Quinn said:
Hi Jesper... I have not seen a post from you in helping me get my MOA 2007
back online. Day Five is tomorrow with no accounting. If I can't get
this
back online via your assistance, who can I call to get help? I will have
to
make the move back to QB soon if I can't get my data back online. It
can't
possibly be this hard, can it?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Ron Anthony Quinn said:
I have posted that I still cannot get the dba attached for BCM and MOA
'07.
Any help is appreciated PLEASE. Day 4 with no accounting and this is
making
my head hurt. :)

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


Jesper said:
Yes, I think the best approach is to install BCM and use that to attach
the
data files.

You will need an sbc-file for MOA that points to this database.
If you don't have one already or don't want to edit one manually, you
should
just use the Rebuild option in the MOA Data Tools which should
recognize the
BCM database as a MOA database and let you select it in the list of
databases.
Let me know if you run into any issues.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


So then once i get BCM 2003 installed on this machine, I should be
able to
move the data (you were correct in the location) and load it.

Question. Once BCM is installed and I move the dba, do all I need to
do
is
attach the data via BCM Data Tools? Once that is done, all I need to
do
is
open MOA 2007? Or is there another step in MOA 2007? Will I need to
point
MOA 2007 to the dba location?

I'm very green with this software, so thanks for your help. Backups
in
the
future will be more frequent. I was on the road for a few weeks and
just
didn't backup to removable media. I normally backup to my office
server.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Yes, I didn't mention this but the exact same scenario happens when
integrating with BCM - the data is copied into the other database
(the
BCM
database in this case) and the old database is stamped.
So if you can find the BCM database that is where your data really
is.
It sounds like that is the database located here:
..\Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager\NetworkNerds2007.ldf/.mdf

Since this is a BCM database (with MOA data included) you need to
use the
Data Tools in BCM to attach it again.

I'm sorry for the trouble you have getting the data up and running
again.
Once you know where the data is, moving it around is normally a
fairly
simple operation - of course backup/restore is often the best
approach
instead.
But I hope this will help you.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


message
So there are no questions, here's the setup:

- Old hard drive on laptop with failed hard drive contained a MOA
Pro
2007
dba and a BCM 2007 dba. They were integrated.
- Moving the MOA Pro 2007 dba to another PC so that we can keep
doing
my
company's accounting. MOA Pro 2007 is installed on this PC along
with
Office
2003. BCM has not been installed as of yet.
- In \My Documents\Small Business Accounting\Companies, the
networknerdsllc_2007.sbc files contents show:
database=NetworkNerds2007
server=NERD-M200\MSSMLBIZ,5356
- In \Program Files\Microsoft SQL Server\Mssql.1\Mssql\Data, the
.sbd
and
.sbl files I have are networknerds.sbd/.sbl and
networknerds1.sbd.sbl.
- Under \Documents and Settings\RQuinn\Local Settings\Application
Data\Microsoft\Business Contact Manager I have
NetworkNerds2007.ldf/.mdf

The objective is to get the MOA 2007 dba from the old hard drive
to the
alternate PC with MOA 2007 installed so I can continue to run my
business.

I don't like to make comparisons, but with Quickbooks, it would
have
been
as
easy as moving the (1) data file and opening the program. I am on
Day
Three
(3) of trying to move the MOA Pro 2007 dba from one computer to
another
and
have not experienced any degree of success. We made the switch on
01
January
2007 from QB to MOA 2007.

I cannot help but think that there HAS to be a way to accomplish
this
task.
At this point it would have been quicker to go back to QB and
recreate
the
year from scratch.

Please help!

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Also... somehow I forgot to mention that this MOA 2007 dba
that'as on
the
old
hard drive was integrated with BCM. If I think I am correct,
does
this
dba
live in a different location?

I really have to get this running today as I have lost 3 days of
work
at
this point trying to move this dba over to a new machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Well, the dba from the old failed computer is MOA Professional
2007
and
I am
(trying) to move it to an office desktop into MOA Professional
2007.
The dba
in question was never part of SBA 2006. My company (I own)
just
moved
from
QuickBooks 2006 to MOA Professional 2007 on 01 January 2007.
It's
just
been
a nightmare to try and get the dba from the old hard drive to
the
new
computer.

So given that it's never been SBA 2006, are there any other
suggestions?

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

Ok, I see that I was mistaken on how it checks for this
scenario -
it
actually looks at a field in the database itself and not in
the
sbc-file.

When we upgrade a database from SBA 2006 to MOA 2007 we copy
the
whole
database from the old SQL instance "MICROSOFTSMLBIZ" to the
new
instance
"MSSMLBIZ" (this is because 2006 used MSDE 2000 while 2007
uses
SQL
Express
and they can be installed side-by-side).
So we copy the database and then "stamp" the old database so
that
we
can
recognize that it has been upgraded in case anyone tries to
use
the
old
database (which would usually not be what you wanted). And
this is
the
message you get when the database has been stamped that way.

So I'm guessing that the database you copied must already
have
been
upgraded/moved to 2007 and the database you really want is
probably
somewhere else.
On the HD from the failed computer, you probably had both SBA
2006
and MOA
2007 and had already upgraded to 2007?
If that is the case then the data files would have been moved
to
the
2007
folders which is here: "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\"
Take a look at this folder on the HD from the failed computer
and
see
if you
find the files there.

If you do, then please copy them to the new computer
instead - you
might
have to delete the database you already attached, using the
delete
functionality in the Data Tools.


--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


in
message
Well... I have tried it both ways. I have manually edited
the
file
and I
have used the file created from the rebuild and I get that
same
message
either way. It's pointing to the correct machine.

--
Ron Anthony Quinn
Chief Nerd Officer
Network Nerds, LLC


:

This is because the sbc-file that you copied is pointing
to the
old
location
and this is interepreted by MOA 2007 as the company has
been
moved
(hence
the message).
You should use the sbc-file that is created when you
Rebuild
from
the
Data
Tools.

Alternately you can simply open the sbc-file in Notepad
and
edit
the
information in it. If you know the computer name and exact
database name
(i.e. from the rebuild-dialog where you see a list of
databases),
you can
just manually change the sbc-file.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


"Ron Anthony Quinn" <[email protected](donotspam)>
wrote in
message
Thanks for the information...

I went through the steps you provided in which I copied
over
the
[companyname].sbc file, then opened Data Tools and
Attached
the
the
same
file, then went to Rebuild. When I tried to open an
"Existing
Company", I
got an error that says, "This shortcuts points to a
company
that
has
been
moved during upgrade or integration. Please use the
shortcut
that was
created when the company was moved or create a new
shortcut
from
 
Ad

Advertisements

C

Chris Schatte

Ron,
To add here,
Had this problem earlier. My solution was to install the original apps,
restore to this configuration (if integrated you would need to be the BCM db
owner) then did the upgrade to OA Pro. To integrate with BCM 07 you will need
to do this from BCM to OA. If using BCM update and Office 2003 here is a new
sp:
http://blogs.msdn.com/bcm/archive/2...-contact-manager-for-outlook-2003-update.aspx

Chris Schatte
--
Accounting 07:
http://www.microsoft.com/office/com...dg=microsoft.public.sba.general&lang=en&cr=US
My spaces blog:
http://ms-sba-user.spaces.live.com/
Office Accounting 2007
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top