We are on SQL Server 2000 Enterprise and are planning to upgrade to '08 Enterprise later this month. One of our issues is that we send an .mdf each night to a university that is using SQL server 2005. They are currently able to attach our 2000 version .mdf to their 2005 instance so this hasn't been an issue. The university will not be upgrading until later this year so I would like to know if there is a way that I can get the database to them without requiring them to change anything on their end.
The file we send is about 1Gb (1054Mb). The process needs to be automated on our end. The only possibility I have seen is to export the database and data as a script and specify explicitly that it should be compatible with the earlier versions. Is this the only way? If so should I just write a DTS that exports the script with the parameter and then have my 2000 box look for that script file?
The key is that I don't have to involve the university in any changes on their end. I want to be able to send them the same .mdf and .ldf they have been getting for the last year.