CODEWITHSUNDEEP
sql-server
abgad
abgad

Reputation: 1

SQL Server generating script for earlier versions

I had applied for a job vacancy and they asked to make a task in order to be hired, so the task was a website needed a database and I sent the task through email but they replied "Please send me database as backup file or scripted as SQL Server version 2012 or earlier"

I just need a way to make script of version 2012 while I created the database using SQL Server 2014

What to do ?

Upvotes: 0

Views: 692

Answers (1)

Alejandro
Alejandro

Reputation: 7813

As for the backups, I don't think there is a way, the server will create files compatible with its own version. Newer ones can recognize them, but not earlier ones. Neither helps detaching the DB files and sending them, as they have the same limitation.

Generating scripts from SSMS is the best way to go if you have an existing DB. You can set the compatibility level in Tools => Options => SQL Server Object Explorer => Scripting => Script for server versions, which lets you choose which version will the code attempt to be compatible with. Of course you need to make sure that you don't use features introduced in latter versions.

The ideal way is still, if you design and implement the DB yourself, to write the scripts yourself and taking care of compatibility, avoiding the visual designers altogether.

Upvotes: 1

Related Questions