Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

bug in scripting multi filegroup database in Azure SQL Managed Instance to SQL2017EntEdtn

bug in scripting multi filegroup database in Azure SQL Managed Instance to SQL2017EntEdtn
Only primary filegroup and file + log file are scripted. No extra filegroups or files !

Microsoft SQL Server Management Studio 14.0.17289.0
Microsoft Analysis Services Client Tools 14.0.1016.283
Microsoft Data Access Components (MDAC) 10.0.17134.1
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.17134.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.17134

1 vote
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Johan shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Johan commented  ·   ·  Flag as inappropriate

    I've been allowed to use a collegue's VM to test it.
    It DID NOT work.
    Objectbrowser / databases / rightclick - script as create database
    It does not script the extra filegroups and files

  • Johan commented  ·   ·  Flag as inappropriate

    I"ll request a VM to try it, but cannot use it on our production clients due to it being an RC

Feedback and Knowledge Base