Forum Discussion
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 even possible or worth the effort since it is only 6 of them in question? Should I tell them to recreate them in a new server?
Thank you.
"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
"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
