6 replies to this topic

[foxp2]

SSMA : http://forums.oscommerce.com/statuses/id/1372/

do you have the same results ?

http://echoscystem.com/report/report_2012_01_12T11_56_23/mainindex.html (Report works only with Internet Explorer - due to Active-X)

[geoffreywalton]

Gave up trying to get these links to display, suspect this is why you have no responses.

Cheers

G

[Harald Ponce de Leon]

Hi Laurent..

Try again with MyISAM. The foreign key relationships would need to be setup manually.

Are you interested in working on MSSQL? I have PostgreSQL working for Setup and Admin in my github repo, which can help build queries for MSSQL.

Kind regards,

[foxp2]

Harald Ponce de Leon, on 15 January 2012, 21:18, said:

The foreign key relationships would need to be setup manually.

ok, i'll use Sybase PowerAmc.

Harald Ponce de Leon, on 15 January 2012, 21:18, said:

Try again with MyISAM

there is no problem with MyISAM. i've done this migration before.
I prefer to work with a real relationnal database (more easy later to work with Object-relational mapping tool included in Visual Studio - linqtosql)

Harald Ponce de Leon, on 15 January 2012, 21:18, said:

Are you interested in working on MSSQL?

yes and SQLAzure.

Harald Ponce de Leon, on 15 January 2012, 21:18, said:

I have PostgreSQL working for Setup and Admin in my github repo, which can help build queries for MSSQL.

http://echoscystem.com/oscom3pgsql/

[Harald Ponce de Leon]

Hi Laurent..

foxp2, on 15 January 2012, 23:06, said:

yes and SQLAzure.

That's great! @Mark Evans has also done some work here - it would be great to see MSSQL catch up to the queries made so far for PostgreSQL

I have a store procedure ready for the Admin Countries listing - will provide this in a package tomorrow.

Kind regards,

[foxp2]

@Harald Ponce de Leon :

Harald Ponce de Leon, on 15 January 2012, 23:57, said:

@Mark Evans has also done some work here

here ? where ?
what i have seen about that : https://github.com/oscsparky/oscommerce2/tree/sql_server ?

Harald Ponce de Leon, on 15 January 2012, 23:57, said:

- it would be great to see MSSQL catch up to the queries made so far for PostgreSQL

surely !

Harald Ponce de Leon, on 15 January 2012, 23:57, said:

I have a store procedure ready for the Admin Countries listing - will provide this in a package tomorrow.

great, you can you can copy/paste store procedure here

Kind regards,

[Harald Ponce de Leon]

Hi Laurent..

I just checked and have already committed the queries for the Admin Countries application to my github repo:

https://github.com/haraldpdl/oscommerce/tree/master/osCommerce/OM/Core/Site/Admin/Application/Countries/SQL/Microsoft/SqlServer

Here are the statements for the stored procedures:

DROP PROCEDURE CountriesGetAll;
GO
CREATE PROCEDURE CountriesGetAll @PAGESET INT, @MAXRESULTS INT AS
WITH CountriesList AS
(
    SELECT *, (select COUNT(*) from osc_zones where zone_country_id = countries_id) as total_zones,
    ROW_NUMBER() OVER (ORDER BY countries_name) AS 'RowNumber'
    FROM osc_countries
)
SELECT *
FROM CountriesList
WHERE RowNumber BETWEEN (@PAGESET - 1) * @MAXRESULTS + 1 AND @PAGESET * @MAXRESULTS;

SELECT COUNT(*) as total
FROM osc_countries;
GO

DROP PROCEDURE CountriesGet;
GO
CREATE PROCEDURE CountriesGet @ID INT AS
SELECT *
FROM osc_countries
WHERE countries_id = @ID;

SELECT count(*) as total_zones
FROM osc_zones
WHERE zone_country_id = @ID;
GO

I work primarily on a Mac. I'll check my Windows box tomorrow for more code.

Kind regards,