[RELEASE] FULL FILE SERVER 8.1 ~

Quote:

Originally Posted by Mslolita i did this not working... i am using sql 2012 Code: SET IDENTITY INSERT [telecaster8.1].dbo.[character] ON INSERT INTO [Telecaster7.4].dbo.[character] ( [pet] [int] NOT NULL, [main_title] [int] NOT NULL, [sub_title_0] [int] NOT NULL, [sub_title_1] [int] NOT NULL, [sub_title_2] [int] NOT NULL, [sub_title_3] [int] NOT NULL, [sub_title_4] [int] NOT NULL, [remain_title_time] [int] NOT NULL, [arena_point] [int] NOT NULL, [arena_block_time] [datetime] NOT NULL, [arena_penalty_count] [int] NOT NULL, [arena_penalty_dec_time] [datetime] NOT NULL, [arena_mvp_count] [int] NOT NULL, [arena_record_0_0] [int] NOT NULL, [arena_record_0_1] [int] NOT NULL, [arena_record_1_0] [int] NOT NULL, [arena_record_1_1] [int] NOT NULL, [arena_record_2_0] [int] NOT NULL, [arena_record_2_1] [int] NOT NULL, [alias] [nvarchar](61) NOT NULL, ( SELECT ( [pet] [int] NOT NULL, [main_title] [int] NOT NULL, [sub_title_0] [int] NOT NULL, [sub_title_1] [int] NOT NULL, [sub_title_2] [int] NOT NULL, [sub_title_3] [int] NOT NULL, [sub_title_4] [int] NOT NULL, [remain_title_time] [int] NOT NULL, [arena_point] [int] NOT NULL, [arena_block_time] [datetime] NOT NULL, [arena_penalty_count] [int] NOT NULL, [arena_penalty_dec_time] [datetime] NOT NULL, [arena_mvp_count] [int] NOT NULL, [arena_record_0_0] [int] NOT NULL, [arena_record_0_1] [int] NOT NULL, [arena_record_1_0] [int] NOT NULL, [arena_record_1_1] [int] NOT NULL, [arena_record_2_0] [int] NOT NULL, [arena_record_2_1] [int] NOT NULL, [alias] [nvarchar](61) NOT NULL, ( FROM [telecaster81] .dbo.[Character] Error: Code: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'IDENTITY'. Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'ON'. Msg 102, Level 15, State 1, Line 5 Incorrect syntax near 'int'. Msg 102, Level 15, State 1, Line 29 Incorrect syntax near 'int'.

SET IDENTITY INSERT [telecaster8.1].dbo.[character] ON

INSERT INTO [Telecaster7.4].dbo.[character]
([pet],
[main_title],
[sub_title_0],
[sub_title_1],
[sub_title_2],
	[sub_title_3],
	[sub_title_4],
	[remain_title_time],
	[arena_point],
	[arena_block_time],
	[arena_penalty_count],
	[arena_penalty_dec_time],
	[arena_mvp_count],
	[arena_record_0_0],
	[arena_record_0_1],
	[arena_record_1_0],
	[arena_record_1_1],
	[arena_record_2_0],
	[arena_record_2_1],
	[alias])

SELECT 

[pet],
[main_title],
[sub_title_0],
[sub_title_1],
[sub_title_2],
	[sub_title_3],
	[sub_title_4],
	[remain_title_time],
	[arena_point],
	[arena_block_time],
	[arena_penalty_count],
	[arena_penalty_dec_time],
	[arena_mvp_count],
	[arena_record_0_0],
	[arena_record_0_1],
	[arena_record_1_0],
	[arena_record_1_1],
	[arena_record_2_0],
	[arena_record_2_1],
	[alias]

FROM [telecaster81] .dbo.[Character] AS Character
SET IDENTITY INSERT [telecaster8.1].dbo.[character] OFF

Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'IDENTITY'.
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'ON'.
Msg 156, Level 15, State 1, Line 49
Incorrect syntax near the keyword 'IDENTITY'.
Msg 156, Level 15, State 1, Line 49
Incorrect syntax near the keyword 'OFF'.

Quote:

Originally Posted by salamator Use it: Code: SET IDENTITY INSERT [telecaster8.1].dbo.[character] ON INSERT INTO [Telecaster7.4].dbo.[character] ([pet], [main_title], [sub_title_0], [sub_title_1], [sub_title_2], [sub_title_3], [sub_title_4], [remain_title_time], [arena_point], [arena_block_time], [arena_penalty_count], [arena_penalty_dec_time], [arena_mvp_count], [arena_record_0_0], [arena_record_0_1], [arena_record_1_0], [arena_record_1_1], [arena_record_2_0], [arena_record_2_1], [alias]) SELECT [pet], [main_title], [sub_title_0], [sub_title_1], [sub_title_2], [sub_title_3], [sub_title_4], [remain_title_time], [arena_point], [arena_block_time], [arena_penalty_count], [arena_penalty_dec_time], [arena_mvp_count], [arena_record_0_0], [arena_record_0_1], [arena_record_1_0], [arena_record_1_1], [arena_record_2_0], [arena_record_2_1], [alias] FROM [telecaster81] .dbo.[Character] AS Character SET IDENTITY INSERT [telecaster8.1].dbo.[character] OFF

Quote:

Originally Posted by Mslolita i am getting this error.. Code: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'IDENTITY'. Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'ON'. Msg 156, Level 15, State 1, Line 49 Incorrect syntax near the keyword 'IDENTITY'. Msg 156, Level 15, State 1, Line 49 Incorrect syntax near the keyword 'OFF'.

SET IDENTITY_INSERT [dbo].[Character] ON
INSERT INTO [Telecaster7.4].dbo.[character]
([pet],
[main_title],
[sub_title_0],
[sub_title_1],
[sub_title_2],
	[sub_title_3],
	[sub_title_4],
	[remain_title_time],
	[arena_point],
	[arena_block_time],
	[arena_penalty_count],
	[arena_penalty_dec_time],
	[arena_mvp_count],
	[arena_record_0_0],
	[arena_record_0_1],
	[arena_record_1_0],
	[arena_record_1_1],
	[arena_record_2_0],
	[arena_record_2_1],
	[alias])

SELECT 

[pet],
[main_title],
[sub_title_0],
[sub_title_1],
[sub_title_2],
	[sub_title_3],
	[sub_title_4],
	[remain_title_time],
	[arena_point],
	[arena_block_time],
	[arena_penalty_count],
	[arena_penalty_dec_time],
	[arena_mvp_count],
	[arena_record_0_0],
	[arena_record_0_1],
	[arena_record_1_0],
	[arena_record_1_1],
	[arena_record_2_0],
	[arena_record_2_1],
	[alias]

FROM [telecaster81] .dbo.[Character] AS Character
SET IDENTITY_INSERT [dbo].[Character] OFF

Msg 207, Level 16, State 1, Line 4
Invalid column name 'main_title'.
Msg 207, Level 16, State 1, Line 5
Invalid column name 'sub_title_0'.
Msg 207, Level 16, State 1, Line 6
Invalid column name 'sub_title_1'.
Msg 207, Level 16, State 1, Line 7
Invalid column name 'sub_title_2'.
Msg 207, Level 16, State 1, Line 8
Invalid column name 'sub_title_3'.
Msg 207, Level 16, State 1, Line 9
Invalid column name 'sub_title_4'.
Msg 207, Level 16, State 1, Line 10
Invalid column name 'remain_title_time'.
Msg 207, Level 16, State 1, Line 11
Invalid column name 'arena_point'.
Msg 207, Level 16, State 1, Line 12
Invalid column name 'arena_block_time'.
Msg 207, Level 16, State 1, Line 13
Invalid column name 'arena_penalty_count'.
Msg 207, Level 16, State 1, Line 14
Invalid column name 'arena_penalty_dec_time'.
Msg 207, Level 16, State 1, Line 15
Invalid column name 'arena_mvp_count'.
Msg 207, Level 16, State 1, Line 16
Invalid column name 'arena_record_0_0'.
Msg 207, Level 16, State 1, Line 17
Invalid column name 'arena_record_0_1'.
Msg 207, Level 16, State 1, Line 18
Invalid column name 'arena_record_1_0'.
Msg 207, Level 16, State 1, Line 19
Invalid column name 'arena_record_1_1'.
Msg 207, Level 16, State 1, Line 20
Invalid column name 'arena_record_2_0'.
Msg 207, Level 16, State 1, Line 21
Invalid column name 'arena_record_2_1'.
Msg 207, Level 16, State 1, Line 22
Invalid column name 'alias'.

Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'pet'.

Quote:

Originally Posted by salamator Ops... Code: SET IDENTITY_INSERT [dbo].[Character] ON INSERT INTO [Telecaster7.4].dbo.[character] ([pet], [main_title], [sub_title_0], [sub_title_1], [sub_title_2], [sub_title_3], [sub_title_4], [remain_title_time], [arena_point], [arena_block_time], [arena_penalty_count], [arena_penalty_dec_time], [arena_mvp_count], [arena_record_0_0], [arena_record_0_1], [arena_record_1_0], [arena_record_1_1], [arena_record_2_0], [arena_record_2_1], [alias]) SELECT [pet], [main_title], [sub_title_0], [sub_title_1], [sub_title_2], [sub_title_3], [sub_title_4], [remain_title_time], [arena_point], [arena_block_time], [arena_penalty_count], [arena_penalty_dec_time], [arena_mvp_count], [arena_record_0_0], [arena_record_0_1], [arena_record_1_0], [arena_record_1_1], [arena_record_2_0], [arena_record_2_1], [alias] FROM [telecaster81] .dbo.[Character] AS Character SET IDENTITY_INSERT [dbo].[Character] OFF

Quote:

Originally Posted by thndr It seems like going through this much trouble and not knowing as much as is needed to be known about SQL that more time could have been saved just inserting the new columns into 7.4 manually. With "add column" It would be done already.

Quote:

Originally Posted by thndr Well thats all that SQL is doing is adding the columns from 8.1 that are not in your 7.4 dbo.character table and putting them in there. There is no data to select and add from the 8.1 database an insert into the 7.4 data base except for the columns. Until there are characters made in the 8.4 database there is no data, that is why people told you to populate the new columns with 0's for now because there is no data to add until you apply a title or gain arena points on said characters in the 7.4 data base the data is 0 As soon as you apply a title or something else for the new content add then the table will update the 0's

Quote:

Originally Posted by ismokedrow To be honest you guys are just playing with fire attempting to import old data (well at-least from 7.3) but even back in 7.3 to 7.4 several Dev's encounter dead-locking or random crashing usually related to a bad import or conversion import.

Quote:

Originally Posted by thndr To import all of the data from your 7.4 Telecaster into your 8.1 Telecaster it is much more extensive then just importing the Character table into 8.1 there is a lot of character data that is not contained in just the character table. It is far easier to update the 7.4 Telecaster to work with the 8.1 Arcadia by adding the new table content and data into the 7.4 Telecaster. By adding the missing columns now when Arcadia runs a SMP to update the data in the character table it can. Again like Drow said it may go a lot deeper than just table data being able to be updated. I know he ran into trouble working with their server. I am not sure on how all the program-ability works yet as there may be new SMPs in the new Telecaster that you would lose if you update the old one. We know that somehow they do it on the retail servers as they maintain character data through all of the epics so far but they probably have better SQL written to update the SMPs as well. I am going to work on it a little bit and I will let you know what I find out.