import data from sql on a clean install of CRM (new SID)

I performed a clean install on a new server but can not import or restore my
data from my old crm install because the SIDs are differnt and CRM stops
working. What can I do to get data to my new database from the old database.
My main goal is to get my accounts and contacts back. Everything else I can
recreate. Anyone who knows how to solve my issue please lend your
assistance. Thanks in advance.

Jason
Fri Nov 05 00:34:36 CST 2004

If you're just concerned about Accounts and Contacts you should check out
the Data Migration Framework. You could also use the Redeployment Tool but
you would have to still have your old system up and runing somewhere to
export the AD settings.

Jason Hunt
Invoke Systems

This posting is provided "AS IS" with no warranties, and confers no rights.


"Tino" <Tino@discussions.microsoft.com> wrote in message
news:5FE77258-1C0F-4E3D-84B6-BEF0A877E6D5@microsoft.com...
>I performed a clean install on a new server but can not import or restore
>my
> data from my old crm install because the SIDs are differnt and CRM stops
> working. What can I do to get data to my new database from the old
> database.
> My main goal is to get my accounts and contacts back. Everything else I
> can
> recreate. Anyone who knows how to solve my issue please lend your
> assistance. Thanks in advance.
>

RonaldL
Fri Nov 05 03:24:01 CST 2004

I have given you another approach on this at this thread
http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx?pg=1&guid=&sloc=en-us&dg=microsoft.public.crm&fltr=&mid=63c1db67-13bc-4182-be82-bef0e0088b0b

Ronald

"Tino" wrote:

> I performed a clean install on a new server but can not import or restore my
> data from my old crm install because the SIDs are differnt and CRM stops
> working. What can I do to get data to my new database from the old database.
> My main goal is to get my accounts and contacts back. Everything else I can
> recreate. Anyone who knows how to solve my issue please lend your
> assistance. Thanks in advance.
>

Erik
Sat Nov 06 17:11:15 CST 2004

Use the Redeployment Tools.
Gr. Erik


"Tino" <Tino@discussions.microsoft.com> wrote in message
news:5FE77258-1C0F-4E3D-84B6-BEF0A877E6D5@microsoft.com...
>I performed a clean install on a new server but can not import or restore
>my
> data from my old crm install because the SIDs are differnt and CRM stops
> working. What can I do to get data to my new database from the old
> database.
> My main goal is to get my accounts and contacts back. Everything else I
> can
> recreate. Anyone who knows how to solve my issue please lend your
> assistance. Thanks in advance.
>

Ruthie
Wed Jan 12 06:35:01 CST 2005

Hi Tino,

we had exactly the same problem & had no luck with the
redeployment/migration tools. In the end I exported the old db's to Access,
re-created the users & setup in the clean CRM install & imported the data
from Access to the new, clean install (after replacing all the user ID's with
the new ones). I had to fiddle with the SecurityDescriptors so that I could
view the data but it works fine.

"Tino" wrote:

> I performed a clean install on a new server but can not import or restore my
> data from my old crm install because the SIDs are differnt and CRM stops
> working. What can I do to get data to my new database from the old database.
> My main goal is to get my accounts and contacts back. Everything else I can
> recreate. Anyone who knows how to solve my issue please lend your
> assistance. Thanks in advance.
>

Kristina
Wed Jan 12 08:54:28 CST 2005

I think MS has a tool to import data from one CRM install to another (not
the same migration tool)... contact MBS...


"Ruthie" <Ruthie@discussions.microsoft.com> wrote in message
news:98046FE9-3998-41EB-8A39-E0EA3578B31A@microsoft.com...
> Hi Tino,
>
> we had exactly the same problem & had no luck with the
> redeployment/migration tools. In the end I exported the old db's to
> Access,
> re-created the users & setup in the clean CRM install & imported the data
> from Access to the new, clean install (after replacing all the user ID's
> with
> the new ones). I had to fiddle with the SecurityDescriptors so that I
> could
> view the data but it works fine.
>
> "Tino" wrote:
>
>> I performed a clean install on a new server but can not import or restore
>> my
>> data from my old crm install because the SIDs are differnt and CRM stops
>> working. What can I do to get data to my new database from the old
>> database.
>> My main goal is to get my accounts and contacts back. Everything else I
>> can
>> recreate. Anyone who knows how to solve my issue please lend your
>> assistance. Thanks in advance.
>>

John
Wed Jan 12 14:43:45 CST 2005

is this what you need?

http://www.microsoft.com/downloads/details.aspx?FamilyID=bfced393-61db-49af-9a50-4a90b311fa7d&DisplayLang=en

--
John O'Donnell
Microsoft CRM MVP
http://www.microsoft.com/BusinessSolutions/Community/CRMFaqLanding.aspx


"Kristina Ledford" <ledfordk@telspan.com.NOSPAM> wrote in message
news:Og1bfaL%23EHA.1396@tk2msftngp13.phx.gbl...
> I think MS has a tool to import data from one CRM install to another (not
> the same migration tool)... contact MBS...
>
>
> "Ruthie" <Ruthie@discussions.microsoft.com> wrote in message
> news:98046FE9-3998-41EB-8A39-E0EA3578B31A@microsoft.com...
> > Hi Tino,
> >
> > we had exactly the same problem & had no luck with the
> > redeployment/migration tools. In the end I exported the old db's to
> > Access,
> > re-created the users & setup in the clean CRM install & imported the
data
> > from Access to the new, clean install (after replacing all the user ID's
> > with
> > the new ones). I had to fiddle with the SecurityDescriptors so that I
> > could
> > view the data but it works fine.
> >
> > "Tino" wrote:
> >
> >> I performed a clean install on a new server but can not import or
restore
> >> my
> >> data from my old crm install because the SIDs are differnt and CRM
stops
> >> working. What can I do to get data to my new database from the old
> >> database.
> >> My main goal is to get my accounts and contacts back. Everything else
I
> >> can
> >> recreate. Anyone who knows how to solve my issue please lend your
> >> assistance. Thanks in advance.
> >>
>
>