Перенос данных со старой версии DB на новую Перед последующей работой сделайте Backup Databases.
Далее, по пунктам.
1) Переименовываем таблицы в DataBase: "MuOnline", которые нам надо перенести: AccountCharacter, Character, Guild, GuildMember, MEMB_INFO, MEMB_STAT, OptionData, VI_CURR_INFO, warehouse.
Пример: С "Character" на "Character2" и т.д.
2) Создаём ещё одну DataBase: "MuOnline2"
3) Ресторим новые DB в DataBase: "MuOnline2"
4) Заходим в DataBase: "MuOnline" -> Tables(Правый Клик) -> Свойства -> Все задачи -> Import Data.
5) Далее -> Выбираем DataBase: "MuOnline" -> Выбираем пункт: "Use Windows Authentication" -> Далее.
6) Выбираем DataBase: "MuOnline2" -> Далее.
7) Выбираем пункт: "Copy table(s) and view(s) from the source database" -> Далее.
8 ) Ставим галочки напротив тех таблиц, которые нам надо перенести -> Далее -> Далее -> Готово -> ОК -> Done.
Таблицы, которые нужно перенести: AccountCharacter, Character, Guild, GuildMember, MEMB_INFO, MEMB_STAT, OptionData, VI_CURR_INFO, warehouse.
9) Пуск -> Все программы -> Microsoft SQL Server -> Query Analyzer.
10) Теперь для каждой таблицы прописываем этот скрипт:
--------------------------------------------------------------------------
Use MuOnline2;
Delete From TableName
---------------------------------------------------------------------------
Пример:
---------------------------------------------------------------------------
Use MuOnline2;
Delete From MEMB_INFO
---------------------------------------------------------------------------
P.S. -> Повторить процедуру для всех таблиц: AccountCharacter, Character, Guild, GuildMember, MEMB_INFO, MEMB_STAT, OptionData, VI_CURR_INFO, warehouse.
11) Теперь в "Query Analyzer" прописываем этот скрипт:
--------------------------------------------------------------------------
Use MuOnline2;
Insert Into AccountCharacter (Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC)
Select AccountCharacter2.Id, AccountCharacter2.GameID1, AccountCharacter2.GameID2, AccountCharacter2.GameID3, AccountCharacter2.GameID4, AccountCharacter2.GameID5, AccountCharacter2.GameIDC from AccountCharacter2
GO
Insert Into Character (AccountID, Name, cLevel, LevelUpPoint, Class, Experience, Strength, Dexterity,Vitality, Energy, Inventory, MagicList, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, MDate, LDate, CtlCode, DbVersion, Quest)
Select Character2.AccountID, Character2.Name, Character2.cLevel, Character2.LevelUpPoint, Character2.Class, Character2.Experience, Character2.Strength, Character2.Dexterity,Character2.Vitality, Character2.Energy, Character2.Inventory, Character2.MagicList, Character2.Money, Character2.Life, Character2.MaxLife, Character2.Mana, Character2.MaxMana, Character2.MapNumber, Character2.MapPosX, Character2.MapPosY, Character2.MapDir, Character2.PkCount, Character2.PkLevel, Character2.PkTime, Character2.MDate, Character2.LDate, Character2.CtlCode, Character2.DbVersion, Character2.Quest from Character2
GO
Insert Into Guild ( G_Name, G_Mark, G_Score, G_Master, G_Count, G_Notice)
Select Guild2.G_Name, Guild2.G_Mark, Guild2.G_Score, Guild2.G_Master, Guild2.G_Count, Guild2.G_Notice from Guild2
GO
Insert Into GuildMember ( Name, G_Name, G_Level)
Select GuildMember2.Name, GuildMember2.G_Name, GuildMember2.G_Level from GuildMember2
GO
Insert Into MEMB_INFO ( memb___id, memb__pwd, memb_name, sno__numb, post_code, addr_info, addr_deta, tel__numb, phon_numb, mail_addr, fpas_ques, fpas_answ, job__code, appl_days, modi_days, out__days, true_days, mail_chek, bloc_code, ctl1_code)
Select MEMB_INFO2.memb___id, MEMB_INFO2.memb__pwd, MEMB_INFO2.memb_name, MEMB_INFO2.sno__numb, MEMB_INFO2.post_code, MEMB_INFO2.addr_info, MEMB_INFO2.addr_deta, MEMB_INFO2.tel__numb, MEMB_INFO2.phon_numb, MEMB_INFO2.mail_addr, MEMB_INFO2.fpas_ques, MEMB_INFO2.fpas_answ, MEMB_INFO2.job__code, MEMB_INFO2.appl_days, MEMB_INFO2.modi_days, MEMB_INFO2.out__days, MEMB_INFO2.true_days, MEMB_INFO2.mail_chek, MEMB_INFO2.bloc_code, MEMB_INFO2.ctl1_code from MEMB_INFO2
GO
Insert Into MEMB_STAT ( memb___id, ConnectStat, ServerName, IP, ConnectTM, DisConnectTM)
Select MEMB_STAT2.memb___id, MEMB_STAT2.ConnectStat, MEMB_STAT2.ServerName, MEMB_STAT2.IP, MEMB_STAT2.ConnectTM, MEMB_STAT2.DisConnectTM from MEMB_STAT2
GO
Insert Into OptionData (Name, Skillkey, GameOption, Qkey, Wkey, Ekey, ChatWindow)
Select OptionData2.Name, OptionData2.Skillkey, OptionData2.GameOption, OptionData2.Qkey, OptionData2.Wkey, OptionData2.Ekey, OptionData2.ChatWindow from OptionData2
GO
Insert Into VI_CURR_INFO ( ends_days, chek_code, used_time, memb___id, memb_name, memb_guid, sno__numb, Bill_Section, Bill_Value, Bill_Hour,Surplus_Point, Surplus_Minute, Increase_Days)
Select VI_CURR_INFO2.ends_days, VI_CURR_INFO2.chek_code, VI_CURR_INFO2.used_time, VI_CURR_INFO2.memb___id, VI_CURR_INFO2.memb_name, VI_CURR_INFO2.memb_guid, VI_CURR_INFO2.sno__numb, VI_CURR_INFO2.Bill_Section, VI_CURR_INFO2.Bill_Value, VI_CURR_INFO2.Bill_Hour, VI_CURR_INFO2.Surplus_Point, VI_CURR_INFO2.Surplus_Minute, VI_CURR_INFO2.Increase_Days from VI_CURR_INFO2
GO
Insert Into warehouse ( AccountID, Items, Money, EndUseDate, DbVersion, pw)
Select warehouse2.AccountID, warehouse2.Items, warehouse2.Money, warehouse2.EndUseDate, warehouse2.DbVersion, warehouse2.pw from warehouse2
GO
---------------------------------------------------------------------------
12) После проделанной работы, делаем Backup Database: "MuOnline2".
13) Удаляем DataBase: "MuOnline2".
14) Ресторим новую DB в DataBase: "MuOnline".
15) Готово.
