Installation and deployment Questions on installation, system configuration and deployment to the live server.
Version 4.x > Installation and deployment > Migration of existing users into new Kentico site View modes: 
User avatar
Member
Member
dmco - 2/20/2010 8:01:51 PM
   
Migration of existing users into new Kentico site
Hi there

We are soon to release a new Kentico website for a customer, but we are having problems migrating users from their old system to the new Kentico DB.

I'd like to just insert the records into the db using SQL i.e. not using the API, but the CMS_User table has a not-null column "UserGuid", that I am not sure how to create.
Is there a mechanism for generating this guid at the db level, or some other means of user import that I could use?

We have approx 6000 users.

Thanks

dmco

User avatar
Kentico Support
Kentico Support
kentico_radekm - 3/1/2010 8:31:48 AM
   
RE:Migration of existing users into new Kentico site
Hello.

If you do not want to use API (and Guid.NewGuid() method), you can use NEWID() in you SQL query, which creates a unique value of type uniqueidentifier, e.g. 6F9619FF-8B86-D011-B42D-00C04FC964FF (GUID). You can see more details here: http://msdn.microsoft.com/en-us/library/ms190348.aspx

Best Regards,
Radek Macalik