proceedSQLScripts: please see NopCommerceStore\Install\
install.aspx.cs file.
DatabaseUpgrade.sql - file containing sql commands, for example:
--Nop_StoreIntegration_ProductsIdsConnector TABLE
IF NOT EXISTS
(
SELECT 1
FROM sysobjects
WHERE id = OBJECT_ID(N'[dbo].[Nop_StoreIntegration_ProductsIdsConnector]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1
)
BEGIN
CREATE TABLE [dbo].[Nop_StoreIntegration_ProductsIdsConnector]
(
[StoreId] [int] CONSTRAINT UQ_Nop_StoreIntegration_ProductsIdsConnector_StoreId UNIQUE NOT NULL,
[OneCId] [nvarchar](16) CONSTRAINT UQ_Nop_StoreIntegration_ProductsIdsConnector_OneCId UNIQUE NOT NULL
)
END
GO
--Nop_StoreIntegration_ProductsIdsConnector_Insert PROCEDURE
IF EXISTS
(
SELECT *
FROM dbo.sysobjects
WHERE id = OBJECT_ID(N'[dbo].[Nop_StoreIntegration_ProductsIdsConnector_Insert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1
)
DROP PROCEDURE [dbo].[Nop_StoreIntegration_ProductsIdsConnector_Insert]
GO
CREATE PROCEDURE [dbo].[Nop_StoreIntegration_ProductsIdsConnector_Insert]
(
@StoreId int,
@OneCId nvarchar(16)
)
AS
BEGIN
INSERT
INTO [Nop_StoreIntegration_ProductsIdsConnector]
(
[StoreId],
[OneCId]
)
VALUES
(
@StoreId,
@OneCId
)
END
GO
On my site file is located in the following location NopCommerceStore\StoreIntegration\Scripts. When I need to change the database structure I
change DatabaseUpgrade.sql file over FTP and I remotely call the
ChangeDatabase() web method from another my application.
This way I can remotely change the structure of the database which is located at the hosting.
I also need to add new column to the database table. how do i update dataacess/bussinesslogic please see https://www.nopcommerce.com/boards/t/2654/new-product-fields.aspx
also use "Search Forums".