SQL database

Hi,

I have just converted an access database and placed it in
the SQL database for CRM with all relationships and data i
had from the old database. The records are all in place in
the correct database (companyname_MSCRM) but i still can
not seem to get any of the data into CRM itself... what am
i doing wrong?

Laz
Sat Dec 18 01:16:37 CST 2004

How did you get the data in there from the Access Database?

You need to use an import application (SDK) that utilizes the CRM security
service so that the CRM specific security attributes are added to the
record.

Jason


"dave" <anonymous@discussions.microsoft.com> wrote in message
news:128c01c4e451$27b984d0$a601280a@phx.gbl...
> Hi,
>
> I have just converted an access database and placed it in
> the SQL database for CRM with all relationships and data i
> had from the old database. The records are all in place in
> the correct database (companyname_MSCRM) but i still can
> not seem to get any of the data into CRM itself... what am
> i doing wrong?

Guy
Sun Dec 19 06:32:37 CST 2004

If you dumped the data in their yourself - i.e. directly into the sql
database, it won't work and this method is completely unsupported.
You can either:
- use the sdk and develop your own code that calls the appropriate web
services to add the data to the database
- use the Data Migration Framework Tool (available for download)
Guy.
"dave" <anonymous@discussions.microsoft.com> wrote in message
news:128c01c4e451$27b984d0$a601280a@phx.gbl...
> Hi,
>
> I have just converted an access database and placed it in
> the SQL database for CRM with all relationships and data i
> had from the old database. The records are all in place in
> the correct database (companyname_MSCRM) but i still can
> not seem to get any of the data into CRM itself... what am
> i doing wrong?

dave
Tue Dec 21 11:31:46 CST 2004

I used the data migration framework as i installed this
off the media pack i got with CRM. I was told i had to
copy it into the cdf_mscrm database and then run the
migration tool which should transfer it to the correct
database but this did not work.


>-----Original Message-----
>If you dumped the data in their yourself - i.e. directly
into the sql
>database, it won't work and this method is completely
unsupported.
>You can either:
>- use the sdk and develop your own code that calls the
appropriate web
>services to add the data to the database
>- use the Data Migration Framework Tool (available for
download)
>Guy.
>"dave" <anonymous@discussions.microsoft.com> wrote in
message
>news:128c01c4e451$27b984d0$a601280a@phx.gbl...
>> Hi,
>>
>> I have just converted an access database and placed it
in
>> the SQL database for CRM with all relationships and
data i
>> had from the old database. The records are all in place
in
>> the correct database (companyname_MSCRM) but i still can
>> not seem to get any of the data into CRM itself... what
am
>> i doing wrong?
>
>
>.
>