Import all settings (advanced) from 4.30 to 4.50

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?

you can execute this sql query. this will update nop v4.50 settings by the value of nop v4.30 if found. note: replace nop_db_450 with your nop v4.50 DB name & replace nop_db_430 with your nop v4.30 DB name

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];

addition: here is the query for an update if found and insert if not found

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]);

Giving it a try Thank you very much!
Rashed Khan wrote: