sorry, I meant "participant".

yes,the data transfers suppose to be bidirectional

The Data that is entered into you Database (ptp?) needs an initial load into GP?

yes

You want your Database to perform ongoing...

there are about 10000 ptps records.I am working on a development environment. Yes I want to make sure when I go to CRM and check ptp data, to be able...

thanks for the help.

Just to see if I got this idea right, so at the end I will need to schedule the job that will import the data to...

This gives me an idea Thanks, but if you can provide an example on this process or maybe useful links that would be great.

Yes please. Can you provide info on how to do this?

That is not correct. The 3 tables that I sent you currently exist in the application that uses sql server database. The data that I sent you was extracted out...

sorry for the delay in responsing, I attached sample data that will be needed to be pulled into CRM. also I attached the query the I will need to use...

We have CRM implemented at my company, we have an application that deals with partipants data and benefits. what we are trying to do is to integrate the data(firstname, lastname,...

Thanks guys for your help. I did set the max server memory to use by sql server to 14 GB. I think that will help but I dont think...

I cant do that. The copy process will probably takes forever. It is absolutely not an option. But thanks for your input. I am really not sure what to do...

Thanks for all of your input. I will try to split the job. But I was just wondering if there are any thing wrong with the way I am reindexing,...

I dont believe this would work either. I have a couple of tables that are so large and reindexing only one takes over an hour, so even if I split...

I found the error. It was not related to the text type at all. thank you.

Both columns are of type text. the error says cannot insert column of type text.

How can I insert this column into a new table, this column can be more 8000...

Thanks!