Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sybase Replication Server - Create user error

Status
Not open for further replies.

xhan13nyuwe

IS-IT--Management
Mar 10, 2011
1
0
0
ID
i have this problem with replication server :

when i create user from Client application the replication server and replicate database became suspend.

to insert login in replicate server database i am using bcp out and in, the step is :

Primary Database
-----------------
1. Dump Primary database = primary.dump
2. bcp out (master.syslogins)
3. in text file that bcp out created delete row suid number 1 and 2 (sa and probe)

Replicate Database
-------------------
4. sp_configure 'allow updates',1
5. bcp in (master.syslogins)
6. sp_configure 'allow updates',0
7. Restore database=primary.dump

Replication Server
-----------------
7. Create primary database definition and master database definition
8. Create replicate database subscription and replicate master database
subscription. With Materialization Method = Bulk
9. Activate
10. Validate

All status= Valid

with this settings i have been replicate data with no problem or error at all , but the only error is where client application create user. when i create user and

check syslogins table in master database compare it between primary and replicate database there is a difference in suid example:

create user
user id: newuser
pass :newuser

Primary database
----------------
suid name
1 sa
2 probe
3 user1
4 user2
7 user3
8 user4
9 newuser

replicate database
----------------
suid name
1 sa
2 probe
3 user1
4 user2
5 newuser
7 user3
8 user4


you can see in primary database newuser login became suid number 9 but in replicate database newuser login became suid number 5.

what im ask here , is there something wrong with my step or something must to add, remove with my step or the whole idea to copy login to replicate database is wrong ?

can someone help me, thanks before and sorry for my bad english

thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top