Tag: sqlserver
-
Migrating data from SQL Server to PostgreSQL
Prerequisites Steps Python Code for testing connection Sample content of .env file Installed python packages Use requirements.txt file to install necessary packages. Content of the file listed below:
-
Changing int data type to bigint in SQL Server
The challenges involved in changing int identity column (i.e. int identity(1,1)) to bigint depends on size of the database and references to identity key in other tables and objects such as user defined procedure/function, sequence and indexes (cluster non cluster). Let’s try changing identity column data type from int to bigint using SQL Server AdventureWorksLT2022…