Monday, March 19, 2012

Can MSDE work as SQL Server?

I plan on replacing a SQL2000 database with MSDE for lowering budget.
Can we script up the SQL database (with SPs, triggers, and UDFs) and recreate it in MSDE?
Thanks.All SQL Server code will work fine on MSDE. The restriction is that it is restricted to 8 concurrent operations. At that point, there is a governer that kiks in to slow down operations.

http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.asp?frame=true

http://www.microsoft.com/sql/msde/|||How can we create/maintain tables, views, stored procedures, triggers and UDFs in MSDE?
Thanks|||through SQL code. CREATE TABLE, CREATE VIEW, ALTER PRCEDURE etc... see Books Online

(you can also connect with the SQL Server client tools, and other SQL Server management tools can be found on the web)

No comments:

Post a Comment