Forum Discussion
Deni_Beslic
Dec 01, 2023Copper Contributor
Migration of SQL Sequences from one DB server to another?
Hello, I have a user requesting to migrate 6 SQL sequences from one SQL DB to another (it is the same DB but the DB was migrated prior to creating sequences and now they want them there). Is that ev...
- Dec 01, 2023
"Migration of sequence"? A really strange term for this use case.
"Effort"? What for an effort, it's done within a minute? Write 6 CREATE SEQUENCE scripts, end of the story.
See CREATE SEQUENCE (Transact-SQL) - SQL Server | Microsoft Learn
olafhelper
Dec 01, 2023Bronze Contributor
"Migration of sequence"? A really strange term for this use case.
"Effort"? What for an effort, it's done within a minute? Write 6 CREATE SEQUENCE scripts, end of the story.
See CREATE SEQUENCE (Transact-SQL) - SQL Server | Microsoft Learn