3

Hi guys got a problem with a database.

I've been asked to perform some indexing and delete queries on a live database, so first of I wanted to get the database to our dev server so I can test out some things before I commit to live.

Unfortunately the dev is SQL Server 2008 and the live is SQL Server 2012. So I've had to try and downgrade the database.

Database is a lovely 33gig. and I've started to use the generate script wizard to create a 2008 version.

Problem is it gets so far then errors on random tables. So far I have no idea what to do to solve the issue. In the advanced settings of the wizard I select schema and data (yup going to be huge)

Error is due to my pc running out of disk space. I have a problem, how do I recreate this DB in 2008 that's both fast and easy? generating the script like that hasn't worked.

Open to ideas guys!

marc_s
  • 9,052
  • 6
  • 46
  • 52
lemunk
  • 143
  • 1
  • 6

1 Answers1

2

One option is third party tools: Red Gate's SQL Compare and SQL Data compare are very good for this sort of thing, and what we use internally. They will let you handle the data table by table, so that might help keep size down. Not sure if they any upper limits on size.

Jamie F
  • 313
  • 2
  • 7