How to Transfer Database

I am trying to transfer my database from my computer where built it to another computer. I have microsoft SQL server 2005 CTP on my computer and the other computer has Microsoft SQL server.

Does anyone have any suggestions on how to do this? I cannot find much info on SQL server 2005 CTP. I have found some info about the copy database wizzard, but I cannot find that in CTP.

Please any ideas or info would be wonderful

Thanks

Sarah

Are the PCs networked ?

Use Data Transformation Services DTS - its wizard based and is simple if both servers can be seen from the target PC

|||

Yes they are networked.

What is the Data Transformation Services, and where can I find it?

Thanks

Sarah

|||There was a CTP compatibility wizard but it was removed now that SQL Server 2005 is live so the easy way to copy the CTP database to the SQL Server is to register the CTP with the SQL Server and use the backup and restore wizard and use the restore from device option. When you register the CTP with the SQL Server the CTP becomes local to the other SQL Server. The above is assuming both are SQL Server 2005. Hope this helps.|||

okay I will try this and get back with you.

Thanks for the help

|||

Well the other sql server seems to be 2000. I am really in the dark on how to use CTP. I cannot even find my database in it. When I tried to register the CTP it tells me the connection does not exist or access is denied? I also tried the Data transformation services and it tells me the same thing.

I really have no idea how this CTP works. I can't see my database in the sql server configuration manager. I know that I can go into visual web developer and use the database, but I don't know much else about it.

Any other ideas, or maybe I am choosing the wrong options when I use these wizards. How do I know what options to choose? Any help is much appreciated!!!

|||It depeneds on where you got the CTP, if you downloaded it from your employer's MSDN open the folder and go to setup rerun it and choose repair option and select management tools to install the Management Studio which is the new Enterprise Manager, if you installed it from CD then copy the content of the CD to you harddrive and rerun setup and follow the same steps. To move a CTP based database to SQL Server 2000 is create blank database in SQL Server 2000 and run INSERT INTO statements per table. The reason is you are going back not forward. If you run into problems change the INSERT INTO statement to INSERT INTO with Column list that gives you control of the INSERT order. Run a search for INSERT INTO statement in SQL Server BOL (books online). Hope this helps.sql