Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gdekok
Starting Member
2 Posts |
 Posted - 2007-03-28 : 09:36:25
|
| We are considering to implement Microsoft CRM 3.0 in our (small) organization. But we already have some customer information in another system (Unit4). We want to duplicate this information to our new CRM-system. This data will be read-only in the CRM-application. Both the applications are installed on different servers with their own SQL databases(server 2000 and server 2005)How can we duplicate the customer information from the unit4-system to Microsoft CRM? Can we simply link those databases using ?ODBC? (I heard something about ODBC but don’t know what it really is.) Could someone clearly explain me what we have to do to make a construction as described above. (you don't have to give me all details) Is this construction possible anyway?Thanks! |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Gelder
Starting Member
7 Posts |
Posted - 2007-03-28 : 13:30:58
|
| try to be more clear what you are trying to do there are a few way and it depends what type of product the source data is on if there are both sql server you can use the sp_addlinkedserver to link the two databases or if even the opendatasource for a one of transfer, or if the data is in a excel spreadsheet of oracle db try the openrowset optionHope that helps a little:-) |
 |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-28 : 14:24:21
|
| You can use transactional replication or database mirroring...MohammedU |
|
|
|
gdekok
Starting Member
2 Posts |
Posted - 2007-03-29 : 04:38:50
|
| Thanks for the reply's. I'm sorry but I'm totally noob in SQL. I just wanted to know if there are possibility’s to resolve the our problem.The Unit4-system contains customerdata, such as name, adress, Credit limit, etc. We'd like to have this information also available(read-only) in the CRM-system. Both the applications have their own different tables in different databases on different servers.But anyway, thanks a lot! |
|
|
|
|
|
|
linking 2 databases