search

genval-ai / reference

Public facing reference content, used for getting started with a new repository.
Apache License 2.0
0 stars 0 forks source link

Convert from SQL Server to PostgreSQL #61

Open paulfryer opened 11 hours ago

paulfryer commented 11 hours ago

PostgreSQL Version

15.3

SQL Server Version

2022

Special Instructions

No response

Processing Instructions

Included in the scope of this request is a bunch of SQL Server files (SQL) for table definitions and stored procedures. Your job it so look at them then consider how they should be implemented in PostgreSQL. Use the versions from the user input. All your work should be placed in the following folder: sqlserver-to-postgress-migration

I want you to first build individual SQL files for each PostgreSQL table and individual SQL files for each PostgreSQL Stored Procedure. You can store them in: sqlserver-to-postgress-migration/postgress/tables and sqlserver-to-postgress-migration/postgress/procedures

Finally, after you have built the PostgreSQL version of the SQL tables and procedures, I need you to build a migration application. You should build it in .NET 8.0 as a console application. It should take in the connection string to both the source SQL Server database and the target PostgreSQL database. It should iterate through all the tables, migrating it from the source to the destination. Store the source code for the migration application here: sqlserver-to-postgress-migration\migration-app

After you do all that I want you to build me a report that describes what you did, challenges, open issues, outcomes, and anything else important, store the report here: sqlserver-to-postgress-migration\migration-report.md

Scope Patterns

adventureworks/*

Source Branch

main

genval-github-integration[bot] commented 11 hours ago

Pre Refactor Summary

Property Value
Proposed Branch Name feature/sqlserver-to-postgres-migration
Total Files in Scope 7
Estimated Input Tokens 2806

Details

Scope Patterns

```text adventureworks/* ```

Files in Scope

| File | Estimated Tokens | |------|------------------| | adventureworks/tables/SalesOrderHeader.sql | 275 | | adventureworks/tables/Product.sql | 228 | | adventureworks/procedures/usp_GetSalesOrdersByDateRange.sql | 142 | | adventureworks/tables/Person.sql | 127 | | adventureworks/procedures/usp_GetCustomersByTerritory.sql | 91 | | adventureworks/tables/Customer.sql | 81 | | adventureworks/procedures/usp_UpdateProductListPrices.sql | 74 |

genval-github-integration[bot] commented 11 hours ago
File Name Action Summary of Changes
sqlserver-to-postgress-migration/postgress/tables/SalesOrderHeader.sql CREATE Created PostgreSQL version of SalesOrderHeader table
sqlserver-to-postgress-migration/postgress/tables/Customer.sql CREATE Created PostgreSQL version of Customer table
sqlserver-to-postgress-migration/postgress/tables/Person.sql CREATE Created PostgreSQL version of Person table
sqlserver-to-postgress-migration/postgress/tables/Product.sql CREATE Created PostgreSQL version of Product table
sqlserver-to-postgress-migration/postgress/procedures/usp_UpdateProductListPrices.sql CREATE Created PostgreSQL version of usp_UpdateProductListPrices procedure
sqlserver-to-postgress-migration/postgress/procedures/usp_GetCustomersByTerritory.sql CREATE Created PostgreSQL version of usp_GetCustomersByTerritory procedure
sqlserver-to-postgress-migration/postgress/procedures/usp_GetSalesOrdersByDateRange.sql CREATE Created PostgreSQL version of usp_GetSalesOrdersByDateRange procedure
sqlserver-to-postgress-migration/migration-app/Program.cs CREATE Created .NET 8.0 console application for migration
sqlserver-to-postgress-migration/migration-app/sqlserver-to-postgress-migration.csproj CREATE Created project file for the migration application
sqlserver-to-postgress-migration/migration-report.md CREATE Created migration report