Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1018
  • Last Modified:

Import the same organization in CRM 2011

Hi,
I have a CRM 2011 Enterprise and I want  import the same organization  (with other name) in to the same server, this procedure work in CRM 4.0, but in CRM 2011 I have an error.
I already read in a post that the problem is the organizationid, but I canĀ“t know how can change it. The post talk about change organizationid before import it.
Any idea?

Thanks!
0
esteban_gnra
Asked:
esteban_gnra
  • 2
1 Solution
 
dequajaCommented:
Solution from: http://social.microsoft.com/Forums/en-US/crmdeployment/thread/b8dfb946-bb02-4fb9-a92f-22ffb8b7071c/



SELECT 'ALTER TABLE '+QUOTENAME(name)+' NOCHECK CONSTRAINT ALL'
FROM sysobjects WHERE xtype='U' and uid=1

declare @newid uniqueidentifier

select @newid = newid()

 SELECT  
        'Update ' + c.TABLE_SCHEMA + '.' + c.TABLE_NAME + ' set ' + c.COLUMN_NAME +' =''' + +cast(@newid as varchar(40))+''''
    FROM INFORMATION_SCHEMA.Columns c
        INNER JOIN INFORMATION_SCHEMA.Tables t
        ON c.TABLE_NAME = t.TABLE_NAME
        AND t.TABLE_TYPE = 'BASE TABLE'
    WHERE DATA_TYPE = 'uniqueidentifier'  and column_name='organizationid'
   
SELECT 'ALTER TABLE '+QUOTENAME(name)+' CHECK CONSTRAINT ALL'
FROM sysobjects WHERE xtype='U' and uid=1



These 3 scripts return set of sql scripts which must be executed to change te organizationid.

After this change you can import the organization to CRM.

0
 
esteban_gnraAuthor Commented:
thanks, I install a new server temporaly to import
0
 
esteban_gnraAuthor Commented:
ok
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now