Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
computguy25
Starting Member
2 Posts |
 Posted - 2008-05-12 : 15:50:26
|
| How do you export data from one SQL server and import it to another? I know this is a noob question but I have been stumpped on this for a few days now. If anyone has a link or a name of a book to read anything would be a big help. The old sever is running V.8 of the SQL server and its running on a 2003 server box. I have to move the data from the old box to a new server 2003 box. I have had a bit of a hard time installing SQL 2000 on the new box but that I should have worked out by end of day. Again any info would be a big help. Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-12 : 15:52:32
|
| Can't you use BACKUP/RESTORE? If not, have you looked at the copy database wizard or the Import/Export wizard?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
computguy25
Starting Member
2 Posts |
Posted - 2008-05-12 : 16:01:23
|
| Is it as simple as exporting and then importing and then everything works the same? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-12 : 16:08:08
|
| It depends on what you want. If you want the entire database, then BACKUP/RESTORE will be the easiest.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
kick7502001
Starting Member
3 Posts |
Posted - 2008-06-05 : 15:57:43
|
| Detach and Attach work really well too |
|
|
|
|
|
|
Few Questions