[DiscordArchive] Are you planning to trigger it yourself for each character?
[DiscordArchive] Are you planning to trigger it yourself for each character?
Original source
Are you planning to trigger it yourself for each character?
rektbyfaith
01-24-2022, 06:36 PM #1Archived author: Revision • Posted: 2022-01-24T18:36:05.706000+00:00
Original source
Are you planning to trigger it yourself for each character?
Original source
Or just moving everything available in on DB to another that already has entries?
rektbyfaith
01-24-2022, 06:36 PM #2Archived author: Revision • Posted: 2022-01-24T18:36:41.886000+00:00
Original source
Or just moving everything available in on DB to another that already has entries?
Original source
Well what I'm doing is moving characters from an old TC DB I had to my AC server
rektbyfaith
01-24-2022, 06:36 PM #3Archived author: Bench • Posted: 2022-01-24T18:36:42.295000+00:00
Original source
Well what I'm doing is moving characters from an old TC DB I had to my AC server
Original source
New one already has entries, lots of conflicting IDs
rektbyfaith
01-24-2022, 06:36 PM #4Archived author: Bench • Posted: 2022-01-24T18:36:53.841000+00:00
Original source
New one already has entries, lots of conflicting IDs
Original source
I've already gone through and swapped out the DB structure to match AC instead of TC
rektbyfaith
01-24-2022, 06:37 PM #5Archived author: Bench • Posted: 2022-01-24T18:37:07.069000+00:00
Original source
I've already gone through and swapped out the DB structure to match AC instead of TC
Original source
I guess you could run inserts on the new DB and run selects from the old DB to automate everything - I would in that case recommend that you define a new base ID. What I mean is if the highest guid you have in the new DB is 4321, then set the base ID of the copied data at 4330 or something. I don't know of an easy way of doing it but that's what I would do.
rektbyfaith
01-24-2022, 06:38 PM #6Archived author: Revision • Posted: 2022-01-24T18:38:28.901000+00:00
Original source
I guess you could run inserts on the new DB and run selects from the old DB to automate everything - I would in that case recommend that you define a new base ID. What I mean is if the highest guid you have in the new DB is 4321, then set the base ID of the copied data at 4330 or something. I don't know of an easy way of doing it but that's what I would do.
Original source
Like "INSERT INTO new_db_name.characters (columns being copied) (SELECT columns FROM old_db_name.characters) but would the guid in each case I would add on top of it. Like (SELECT entry+500 ... FROM old_db_name.characters) and so on. I would suggest trying it on someting safe to make sure you can produce the result you want.
rektbyfaith
01-24-2022, 06:40 PM #7Archived author: Revision • Posted: 2022-01-24T18:40:03.646000+00:00
Original source
Like "INSERT INTO new_db_name.characters (columns being copied) (SELECT columns FROM old_db_name.characters) but would the guid in each case I would add on top of it. Like (SELECT entry+500 ... FROM old_db_name.characters) and so on. I would suggest trying it on someting safe to make sure you can produce the result you want.
Original source
wait
rektbyfaith
01-24-2022, 06:40 PM #8Archived author: Revision • Posted: 2022-01-24T18:40:28.497000+00:00
Original source
wait
Original source
That's not gonna work properly
rektbyfaith
01-24-2022, 06:40 PM #9Archived author: Revision • Posted: 2022-01-24T18:40:32.203000+00:00
Original source
That's not gonna work properly
Original source
My brain is blanking, been staring too much at SQL.
rektbyfaith
01-24-2022, 06:40 PM #10Archived author: Revision • Posted: 2022-01-24T18:40:45.017000+00:00
Original source
My brain is blanking, been staring too much at SQL.
1 Guest(s)
1 Guest(s)