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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-24 : 10:42:09
|
| John writes "Hello,In about a week or so, I will be migrating a VB application running SQL Server from the single user, desktop version of SQL Server (I've been using for development purposes) to a 5-user, network version of SQL Server. I'm still very new to this. I have an IT professional helping me with network issues, but I'm looking for anyone who may have done something similar and willing go offer any comments, suggestions, recommendations, things to look for, words of encouragement, etc. which might be helpful to make the migration process a smooth one. Thanks much in advance. -John" |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2002-04-24 : 11:05:17
|
| You can use the Import And Export Data wizard to do this. All you do is select the source server (your workstation running desktop edition), the destination server, and then select 'Transfer Objects and data between SQL Server databases'. Providing there's no errors in your development database, it should transfer without a problemTim |
 |
|
|
|
|
|
Migrating from SQL Server Desktop to SQL Server Network