Can't generate scripts from LocalDB in SQL Management Studio

Question

I can't export scripts from my LocalDB database (localdb)\v11.0. (SQL Express is fine)

The error I get is

Save or Publish Scripts Report

Getting the list of objects from 'XXX'. Failed

System.IndexOutOfRangeException: Index was outside the bounds of the array. at Microsoft.SqlServer.Management.SqlScriptPublish.GeneratePublishPage.worker_DoWork(Object sender, DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

This is using SQL Server 2008 R2.

Does anyone know what is causing this?

@ErikEJ Nope. My workmate is using 2008 R2 without any issues though. — Tom, May 12 '14 at 09:54
@ErikEJ His version is newer than mine on closer inspection. I have 10.50.1617.0 and he has 10.50.20500.0 — Tom, May 12 '14 at 11:31
Well, latest build is 10.50.4305, so you have some old software — ErikEJ, May 12 '14 at 11:37
@ErikEJ While it wasn't immediately obvious how to update 2008, I installed SSMS 2014 which solved my issue. If you want to add as an answer I'll accept it — Tom, May 12 '14 at 16:22

score 3 · Accepted Answer · answered May 12 '14 at 20:07

3

As LocalDb is SQL Server 2012, you should use SSMS 2012 or later for this scripting task

answered May 12 '14 at 20:07

ErikEJ

40,951
5
75
115

I agree with ErikEJ. There's no reason not to use SSMS 2012 as it's backward compatible and is freely downloadable. – David Atkinson May 12 '14 at 21:21

Can't generate scripts from LocalDB in SQL Management Studio

1 Answers1