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 |
|
legacyvbc
Starting Member
37 Posts |
 Posted - 2007-09-17 : 12:53:24
|
| I have a db that I created on my local machine and need to move it to our server. The problem is that I created it with sql server 2005 express and our server is a sql server 2000 so restore and attach don't work. I don't have management studio (just express) so I don't know what I need to do to move it. Any help is appreciated.Thanks |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-09-17 : 13:30:49
|
| Do you need just the schema or you need the data too? If you just need schema, you can script yout all your objects and compile them on the 2000 server.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
legacyvbc
Starting Member
37 Posts |
Posted - 2007-09-17 : 14:37:52
|
| I need both the schema and the data. |
|
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Move db to new server