Information Technology for The World

SQL server?

I am working on two SQL servers at work... testing them out. One is SQL 2005 standard and the other being 2005 SQL express. I am trying to use import/export utility on the standard edition to move a database to the express addition. I was getting errors at first but then researched and troubleshooted to find that on the express server tcp/ip and pipe naming was disabled. I stopped and restarted the service. Now when i try the import/export on the standard server it does not list the express server to choose as it did before. It is no longer on the list of servers....any suggestions???

Public Comments

1. Have you tried scripting the database?. Doing so will create a text file with the necessary SQL needed to create the database, tables, keys, etc. Then you can open the text file and run the script. If you need to get the data you could export the tables to a delimmited file and then import that file. You would have to do this for every table though so hopefully there aren't that many.