How can I easily import all my settings (advanced) from my 4.30 NopCommerce to 4.50,
I dont see any import feature anywhere for it.
Do I have to manually edit the 900+ settings?
MERGE [nop_db_450].[dbo].[Setting] AS t
USING (
SELECT * FROM [nop_db_430].[dbo].[Setting]
) AS s ON t.Name = s.Name
WHEN MATCHED THEN
UPDATE SET t.[Value] = s.[Value];
MERGE [nop_defaults_450].[dbo].[Setting] AS t
USING (
SELECT * FROM [default_4_30].[dbo].[Setting]
) AS s ON t.Name = s.Name
WHEN MATCHED THEN
UPDATE SET t.[Value] = s.[Value]
WHEN NOT MATCHED THEN
INSERT ([Name], [Value], [StoreId])
VALUES (s.[Name], s.[Value], s.[StoreId]);
MERGE [nop_defaults_450].[dbo].[Setting] AS t
USING (
SELECT * FROM [default_4_30].[dbo].[Setting]
) AS s ON t.Name = s.Name
WHEN MATCHED THEN
UPDATE SET t.[Value] = s.[Value]
WHEN NOT MATCHED THEN
INSERT ([Name], [Value], [StoreId])
VALUES (s.[Name], s.[Value], s.[StoreId]);