Re: transfer db from home to work.

From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 18:36:28 -0400

====================
I would use detach / attach for this.

At home, open Enterprise Manager, expand databases, right-click the one in
question, highlight all tasks> and choose detach. Now you can freely copy
the files to your flash drive.

Then at work, you can attach in pretty much the same manner. When done,
detach, copy to flash drive, and re-attach back at home.

====================
Or, have the database live in a place accessible from both work and home,
then you don't have to take anything anywhere.

====================
Or, keep alter scripts around for and changes, and merely apply the changes
that you've made to schema (unless data changes are essential for
development, then you'll want to script those as well). 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"DAL" <anonymous@discussions.microsoft.com> wrote in message 
news:73B41FBD-A897-4995-9DC0-EE8264A97597@microsoft.com...
>I am creating and testing an asp application on my home (xp) pc.
> Using MSDE at home for the db.
> All works fine at home.
> Have SQL 7 at work which is on a small business server.(windows 2000 
> server)
> I want to transfer the database from home to work using a flash drive.
> So far ive tried making a backup at home through access project:
> database utils> backup.(creates a .dat file)
> This is then taken to work on the flash stick.
> when i get ot work i get this on to my network client pc which also is 
> used as test platform.
> It is a win 2k pc.
> again thru access i can restore to an msde data base. works fine.
> The trouble starts when i want to transfer the db to the main server.
>
> [microsoft][ODBC SQLServer Driver][SQL Driver]could not find server 
> 'MyPC_Name_which_is_at_home.'
> in sysservers.Execute sp_addlinkedserver to sysservers.
>
> why should i have to.?
> am i going about it all wrong.
>
> REMEMBER ACCESS IS SUPPOSED TO GIVE DUMMIES A PORTAL TO SQL SERVER FOR 
> REAL
> SIMPLE THINGS LIKE HAVING A FEW TABLES AND SPs ON A SQL DB.
> the client pc instance (at work) is recognised by the main server in the 
> import data dialogue.
>

Relevant Pages