Migrating database

Can anyone tell me how I can migrate database from one server to another
I need to migrate all the tables, stored procedures, functions and so on

thank youYou can use the Copy Database Wizard to achieve this. See BOL for more info.

As you are moving the database to a new server, you will have to manually delete the data and log files on the old server once the copy process has completed.|||Can anyone tell me how I can migrate database from one server to another
I need to migrate all the tables, stored procedures, functions and so on

thank you

As noted earlier, you can use the Copy Database Objects wizard. Or:

1. You can load a backup of your database onto the new database (you will have to manually add in SQL Logins and resynch those logins with the users in the new database).

2. You can detach the old database, copy over the .mdf and .ldf files and then attach it to a new server (again, you will have to manually handle SQL Logins and synch them to the new db).

Regards,

hmscott|||I dont want to detach the old database. That needs to stay the way it is. Can I just copy over all the tables, sp, views and fns along with the logins. Would it work that way. I know its going to be a lot of work but it seems like the simplest way to go without making changes to the old database

Migrate SQL Server StoredProcedures

Dear Users
Can any body tell me that how can I migrate SQL Server Stored Procedures to Oracle using DTS. I want to do it in VB.Net.
Thanks
OsmanYou can't migrate the actual procedures themselves, but you could migrate the text of the procedure to Oracle. I'm not sure what good that would do you.

What exactly do you want to do once you get the procedures into Oracle?

-PatP

Microsoft SQL Server Management Studio Express Problem

Microsoft SQL Server Management Studio Express

I have restored the database into it with 100tables and stored procedures.

I have also created the new database in it.

But,i don't know how to add the existing database in to Visual Studio.Net 2005 .I m using ASP.Net.

Where are the database stored ??

I don't want to create the new database,.

Can anyone pls tell me ...

Hi,

To add an existing database .mdf file to SQL Server, you can use Attach. Here are the steps.

1. Copy the .mdf file and .ldf(if exists) to another folder.
2. Right click on Databases, and select Attach from the popup menu.
3. In the Attach Databases dialog box, click Add button and select the .mdf file.
4. Click OK to finish, and the database will be attached to your database list in Management Studio.

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!