Developer forum

Forum » Development » MS SQL server versions?

MS SQL server versions?

E-mail notifications

Reply
Posted on 26/04/2007 10:27:40

Hi.


I recently (yesterday) tried to set up a test environment with the DefaultEmptyData.bak file from the eCommerce Thread. I got on-disk structure 611 and mine was 539.


I have tried porting the Access files to to sql server and gets the same error.


Then I went looking for some documentation on which version of ms sql server is required. I found none.. Even your extarnal hosting document mentions a sql server, not minimum required version.


Your 8015_ tecnical releasen notes doesn't mention a sql sever version.


I even found a document called "


DYNAMICWEB SDK – DATABASE USE AND


DESCRIPTION."


I does mention the two 2 types ms access and ms sql, but again no version number.


 


What do I do to get an SQL up and running ?


 


/Regards


Hauke


 


Replies

 
Posted on 27/04/2007 14:39:36
Reply

The bak file was generated from a 2005 version of SQL server (compatibility level 9). It will not install on MS SQL Server 2000. If you need an SQL server database for 2000, please Appendix E in this document that describes how to upsize from your MS Access databases:




http://developer.dynamicweb.dk/Admin/Public/Download.aspx?File=Files%2fFiler%2fDeveloper%2fDownloadfiles%2fSystem%2f8111_(en-US)_Installation_Guide.pdf


 


Please note that Ecom runs 2005 alone.

 
Posted on 01/05/2007 11:52:57
Reply

The error you're describing leeds med to beleive that you're attempting to restore a 2005 backup file on a 2000 SQL server. Is this the case?

 
Posted on 01/05/2007 13:12:16
Reply
Sorensen wrote:





The error you're describing leeds med to beleive that you're attempting to restore a 2005 backup file on a 2000 SQL server. Is this the case?










Sort of. I tried to get a 2000 sql up and running, but it seems that all your files are for the newer 2005  version. As I mentioned earlier, I tried to upsize ms-access files also, but no luck there either. 




A suggestion for future DB versions.. instead of actual DB files, why not sql script files with create scripts for the db  ?




 




Regards Hauke

 

You must be logged in to post in the forum