Move a database to another computer
Move a database to another computer
Move a database to another computer
Move a database to another computer
Move a database to another computer
Move a database to another computer Move a database to another computer Move a database to another computer Move a database to another computer Move a database to another computer Move a database to another computer Move a database to another computer Move a database to another computer
Move a database to another computer Move a database to another computer
Move a database to another computer
Go Back  Xtreme Visual Basic Talk > > > Move a database to another computer


Reply
 
Thread Tools Display Modes
  #1  
Old 11-04-2004, 07:22 AM
mvieke mvieke is offline
Newcomer
 
Join Date: Aug 2004
Posts: 12
Default Move a database to another computer


I am using MSDE. I made a database, and I copied all the files to another computer running MSDE.

How do I add those files to the database on the other computer?

Also, Can anyone recommend a nice free database manager?
Reply With Quote
  #2  
Old 11-04-2004, 11:39 AM
HardCode's Avatar
HardCodeMove a database to another computer HardCode is offline
Ultimate Contributor

Forum Leader
* Expert *
 
Join Date: Feb 2004
Location: New Jersey
Posts: 3,339
Default

In order to easily "copy" an MSDE database from one machine to another, just run a complete. Backup of the source DB and copy it to the destination DB's PC. Then on the destination DB, create a new DB and restore the file you copied.

Microsoft's MSDE website lists some free DB managers, but the two I tried do not compare to Enterprise Manager.
__________________
DON'T CLICK HERE

Useful forum tags: [VB][/VB], [CODE][/CODE], [HTML][/HTML]
Reply With Quote
  #3  
Old 11-04-2004, 10:40 PM
loquin's Avatar
loquinMove a database to another computer loquin is offline
Google Hound

Retired Moderator
* Guru *
 
Join Date: Nov 2001
Location: Arizona, USA
Posts: 12,400
Default

MSDE Admin is not bad, and it's low cost. (on the order of $20 US)
__________________
Lou
"I have my standards. They may be low, but I have them!" ~ Bette Middler
"It's a book about a Spanish guy called Manual. You should read it." ~ Dilbert
"To understand recursion, you must first understand recursion." ~ unknown
Reply With Quote
  #4  
Old 11-05-2004, 09:25 AM
HardCode's Avatar
HardCodeMove a database to another computer HardCode is offline
Ultimate Contributor

Forum Leader
* Expert *
 
Join Date: Feb 2004
Location: New Jersey
Posts: 3,339
Default

Additionally, if there are only certain things you want to do, or, if the free managers don't do what you need, you can always write the functionality yourself in VB using the SQL-DMO COM object library that comes with MSDE and SQL Server. It is pretty easy to use, and you can replicate anything in Enterprise Manger with it. Of course, you need the time to do this, as anything more than a few functions is no small project
__________________
DON'T CLICK HERE

Useful forum tags: [VB][/VB], [CODE][/CODE], [HTML][/HTML]
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Move a database to another computer
Move a database to another computer
Move a database to another computer Move a database to another computer
Move a database to another computer
Move a database to another computer
Move a database to another computer Move a database to another computer Move a database to another computer Move a database to another computer Move a database to another computer Move a database to another computer Move a database to another computer
Move a database to another computer
Move a database to another computer
 
Move a database to another computer
Move a database to another computer
 
-->