How can I migrate Sql Server 2000 to Sql Server 2005 ?

Dear everyone,

My company is currently using MS Sql Server 2000 for applications, and in Windows Server 2000. The database holds great amount of information.
Recently, my company needs to migrate database from Sql Server 2000 to 2005. How could I safely migrate the database from sql server 2000 to 2005? Could you all give me the guides?

Also, in what aspect I should pay attention on the performance of sql server 2005?

Thank you for your kind attention.

Best Regards,
David

Hi,

You can find lot of information about the upgrade at here: http://www.microsoft.com/sql/solutions/upgrade/default.mspx

I highly recommend to use the upgrade advisor, it helped me a lot.

Regards,

Janos

|||

you have the following options to migrate to sql 2005,

1.Inplace upgrade > it will overwrite the current sql 2000 instance and a new sql 2005 instance will be created, but as replied by previous member you need to run the upgrade advisor to ensure that everything is fine with your db b4 upgrading

2.Side by Side upgrade > it is the most conventional method, you can use any of these below methods ......i prefer backup and restore

backup your SQL 2000 db and restore it in sql 2005 detach your sql 2000 db and attach it in sql 2005 use copy database wizard to move your sql 2k dbs to sql 2k5

How can I grant create permission for stored procedures?

My company has an SQL server hosted at a server farm. An outside
consultant is developing some stored procedures to generate some
reports using the data in the SQL Server database that our application
uses.
The developer will have access to the SQL server via Enterprise
Manager using his own login. I need to give him the right to create
stored procedures in a sandbox database while limiting his other
abilities to select only. When I look at the permissions on stored
procedures I see that I can allow or deny the ability to execute them
but I am not sure how to allow stored procedure creation priviledges.
Can this be done?
TIAGrant the user the statement permission, for example:
GRANT CREATE PROCEDURE to SomeUser
-Sue
On Thu, 07 Jul 2005 18:42:17 -0400, Matthew Speed
<mspeed@.mspeed.net> wrote:

>My company has an SQL server hosted at a server farm. An outside
>consultant is developing some stored procedures to generate some
>reports using the data in the SQL Server database that our application
>uses.
>The developer will have access to the SQL server via Enterprise
>Manager using his own login. I need to give him the right to create
>stored procedures in a sandbox database while limiting his other
>abilities to select only. When I look at the permissions on stored
>procedures I see that I can allow or deny the ability to execute them
>but I am not sure how to allow stored procedure creation priviledges.
>Can this be done?
>TIA

How can I get rid of the comma in a company name by using sql command?

For example: company_name: ABC company, inc.

I want to get rid of the comma, replace by a space. How the query should be write?

Thanks

replace(ColumnName,',',' ')

example

select replace('ABC,ZXX',',',' ')

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||Thank You!!!