Tuesday, February 14, 2012

Differences between SQL 2005 thats comes with vs2005 and SQL 2005 standalone ?

I just want to run a webiste off my home computer with a dynamic address.
It seems I can do all I want with the SQL that comes with vs2005 except being able to backup the DB
Is the SQL 2005 that comes with vs2005 good enoh for everything I should want to do??
Is there some chart somewhere that explains the differences ?
You can find a list of differences here:http://msdn2.microsoft.com/en-us/library/ms143761.aspx
Here is how to back up the database in SQL Server 2005 using T-SQL:http://msdn2.microsoft.com/en-us/library/ms186865.aspx
I couldn't see anything that said SQL Server 2005 could NOT backup the database. You don't get a fancy tool to help so you have to work with SQL Script to do that.|||

Colin Angus Mackay wrote:

You can find a list of differences here:http://msdn2.microsoft.com/en-us/library/ms143761.aspx
Here is how to back up the database in SQL Server 2005 using T-SQL:http://msdn2.microsoft.com/en-us/library/ms186865.aspx
I couldn't see anything that said SQL Server 2005 could NOT backup the database. You don't get a fancy tool to help so you have to work with SQL Script to do that.


Microsoft realized from out of the box users that the backup and restore is one of the best things in the product so SQL Server 2005 comes with a much improved backup and restore wizard but the Mirroring feature was delayed. Hope this helps.|||

you are talking about the non free version??

I guess the only thing that really concerns me is the backup and restore... for now I was trying to copy the mdf file and cut and paste it from my home and work machine... but now I have problems with it saying READ ONLY or something

So you all are saying using the free version.. if I want to move a db from one comptuer to anothiner I need to genereate a sql script and then run goto the other computer delete the DB.. and run that script

right ?

|||

The product is still in beta so you can download the full developer edition from the link below it is good for one year. Try the link below to download the beta and attend the launch event in DC and you will get both products free. Hope this helps.
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx

http://msevents.microsoft.com/cui/EventDetail.aspx?culture=en-US&EventID=1032281417&EventCategory=1

No comments:

Post a Comment