Who's On?

	Membership:
	Latest: Zac Shields
	Past 24 Hours: 1
	Prev. 24 Hours: 1
	Overall: 5210

	People Online:
	Visitors: 228
	Members: 0
	Total: 228

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Copy bookmarks from one environment to another

7 Replies

0 Subscribed to this topic

13 Subscribed to this forum

Sort:

Author

Messages

chad208

Advanced Member

Posts: 25

11/12/2008 1:38 PM

We have two (2) environments running on our test system. One of the environments is running an 8.0.3 version of Self Service and another is running 9.0.

Does anyone know of a method I can utilize to copy Portal bookmarks from one environment to another. Thanks in advance.

John Henley

Posts: 3353

11/12/2008 7:12 PM

You should be able to dump to a CSV file using LO921, then load into the other environment using LO920.
You'll probably want to massage the CSV file in-between to make sure you are only loading bookmarks you want, since you would otherwise be loading/creating duplicates in your 9.0 portal.

chad208

Advanced Member

Posts: 25

11/12/2008 7:23 PM

I believe when we went to LSF 9 and upgraded Portal LO921 was removed as we do not have the LO921 form. Is this incorrect?

Kwane McNeal

Veteran Member

Posts: 479

11/12/2008 7:30 PM

Chad,
John's directions to you were correct. On the 8.0.3 side, use the LO921 to dump the bookmarks. The form is still available to you, so you should have no issues using it. On the 9.0.0.x side, then load them with LO920. You are correct, on the LSF9 side you do NOT have LO921.

The other method is to copy the tables via dbcopy. That is the method the migration uses. This will give you EXACT copies, BUT has the risks of reintroducing the invalid 8.0.3 bookmarks into LSF9, so you would have some clean up there also.

All in all, John's method is safer, and my method is faster.

Kwane

John Henley

Posts: 3353

11/12/2008 7:34 PM

Sorry, I misread your initial post, I thought it implied you had 8.0.3 version of environment for the 8.0.3 self service.

John Henley

Posts: 3353

11/12/2008 7:37 PM

You could use MS Addins to dump from LOBKMARK to create a CSV file you could then upload via LO920.

Kwane, I think it would be sqldbcopy, not dbcopy, since he has TWO LOGANS, i.e. two different environments.

Kwane McNeal

Veteran Member

Posts: 479

11/12/2008 7:51 PM

John,
Nope. Check out $GENDIR/ug81/copybkmrkdata.pl

For Chad, he would a dbdump/dbload, as the tables have no changes in structure.

Kwane

John Henley

Posts: 3353

11/12/2008 8:57 PM

When you run that migration script ($GENDIR/ug81/copybkmrkdata.pl), both LOGAN803 and LOGAN (lsf9) are installed in the same environment. dbcopy only works if the product lines are in the same environment. To copy across environments, you need to use sqldbcopy.

Regardless, depending on what he's trying to do, he probably shouldn't be copying the table data anyway, but should use LO920 for loading into the new environment to get new bookmark numbers, etc. To copy directly via the table would potentially corrupt his bookmarks.