Can i host a SQL2005 EE DB on SQL2000 engine ?

Hi,
I'd like to host a small website created using VS2005 EE with a company that offers just SQL2000 DB support.
My question, can i use the DB created by VS site manager as a DB to the site, if not, is there any alternatives.
Thanks.

hi,

SQL Server 2005 databases can not be attached/managed/used by SQL Server 2000 edtions.. the internal structures and metadata are different.. you can obvioulsy upgrade a SQL Server 2000 database to SQL Server 2005, but not the contrary..

you can "handle" that scripting out the database objects (obviously only the SQL Server 2000 supported ones) cleaning out eventual 2005 features and recreate the database on the SQL Server 2000 instance running those scripts... you can then BCP out (and "in", in the destination instance) eventual pre-loaded required data..

or, you can use the wizards provided by SSIS (not available with SQL Server Express and SQL Server Management Studio Express, but with full SQL Server 2005 edition only) to to "copy" the required database(s) to the 2000 edition instance..

regards

|||

The SQL team just released a Database Publishing Wizard that might meet your needs. The wizard makes it easy to script out your development database, even directly from VS. You can then run the script on your hosted site to recreate the database and the data. You should be able to run the script on both 2005 and 2000 systems.

You can find a tutorial on using the wizard in this blog post along with a link to where you can download the wizard.

Mike

|||

Hi all,

There's an easier way. What you can do it run the sp_dbcmptlevel stored procedure and set the version of your database to 80 (i.e. SQL Server 2000) You can then use this db (obviously without any SQL Server 2005 features) on a SQL Server 2000 engine. Here's more about the sp_dbcmptlevel stored procedure :

http://msdn2.microsoft.com/en-us/library/ms178653.aspx

Regards,

Amol A. Vaidya.

|||

hi Amol,

nope, this is not an option... you can not move a SQL Server 2005 database to a SQL Server 2000 instance even if modifying the compatibility level...

regards

|||

Hi Andrea,

Yeah you are right on that. The formats for SQL Server 2005 Database are different from that of SQL Server 2000 database and sp_dbcmptlevel does not downgrade to that format. I mixed this up with the other-way-round scenario that you can use a SQL Server 2000 database as-is (i.e. locked up with formats and features restricted to SQL Server 2000) by setting the sp_dbcmptlevel to 80 on a SQL Server 2005 Engine but not the other way round.

Thanks for pointing that out,

Amol.

|||

Hi Amol,

I think you still might be confused about the dbcmptlevel. Setting it to 80 has nothing to do with file format ever. When you attach a SQL 2000 database to SQL 2005 it is always converted to the 2005 file format. The dbcmptlevel will cause SQL 2005 to run commands as if it were SQL 2000, but the file format is always upgraded.

Mike

sql

can data analysis done using SQL Server 2005 be used in a consumer website?

I just have a simple question that can hopefully answer whether I should dive too deeply into Reporting/Analysis Services. I'm looking to run some clustering algorithms on user-inputted keywords on objects within my database (please see http://flickr.com/photos/tags/friends/clusters/ for an example of what I'm talking about). It seems to me that the various reporting methods that SQL Server provides would be an ideal, quick and easy way of providing this for my SQL Server 2005 database.

Can the reporting services provide this type of functionality? And if so, would this be scalable? I would want to be able to access this clustered data in much the same way I do queries across my database and would want them to be done quickly and efficiently.

Thank you for your help.

We hacve done tests executing up to 36 million data mining singleton queries/day on desktop hardware. Up to 240M/day on really nice hardware. This was issuing queried through ASP.NET (I believe, I know it was IIS).

Regarding the scalability of RS, you need to ask on the RS forum

can a SQL2005 DB be hosted on a SQL2000 server ?

Hi,
I'd like to host a small website created using VS2005 EE with a company that offers just SQL2000 DB support.
My question, can i use the DB created by VS site manager as a DB to the site, if not, is there any alternatives.
Thanks.in general, this won't work. what you are asking for is forward compatibility, which is impossible to deliver in practice. it's like expecting apps written for Vista to work on windows 95. If you are developing for 2000, you should use the 2000 tools.

on the other hand, as long as your db doesn't use any 2005 features not present in 2000 (such as CLR procs, xml columns, etc) then your DDL scripts should execute ok.

Can a SQL Server database be access without having to log onto the server?

One of my client website got hack into and the web application that I created for them is disabled/block externally. Only internally within their business, they will be able to access it. The person that is maintaining the server say, a hacker went straight to the database without having to log onto the server. The person that is maintaining the server is blaming on my web application, which no one has access to view the page except internally within the client work location.

Is this is posibble if the server is secure?

Both scenarios are possible. Hacker might have gotten access to your database or got in through your app via SQL Injection attack. Do you use parameterized queries in your application?

|||

The queries is within the code-behind page, I didn't use stored procedured. But yes, it is paramaterize queries. How can a hacker be able to access a database without logging onto the database? Also, how a hacker be able to do an SQL Injection when all administrative webpage(within "admin" folder) is disable/block to all external users. Only the website is shown to external users and internal users is allow to view the administrative webpage. Sorry, if I didn't explain everything. For example, when accessing this: www.mywebsite.com/admin , it would show...

You are not authorized to view this page

The Web server you are attempting to reach has a list of IP addresses that are not allowed to access the Web site, and the IP address of your browsing computer is on this list.

---

Please try the following:

Contact the Web site administrator if you believe you should be able to view this directory or page.|||

Its very well possible. Do a google search for "SQL Injection attack".