Re: transfer db from home to work.
From: DAL (anonymous_at_discussions.microsoft.com)
Date: 04/28/04
- Next message: Laumon: "Store procedure: connect to another server/database"
- Previous message: Narayana Vyas Kondreddi: "Re: Reverse engineering tables"
- In reply to: Aaron Bertrand [MVP]: "Re: transfer db from home to work."
- Next in thread: Aaron Bertrand [MVP]: "Re: transfer db from home to work."
- Reply: Aaron Bertrand [MVP]: "Re: transfer db from home to work."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Apr 2004 04:31:03 -0700
But i dont have an enterprise manager at home if ive just got MSDE. - do I ?
----- Aaron Bertrand [MVP] wrote: -----
====================
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.
>
- Next message: Laumon: "Store procedure: connect to another server/database"
- Previous message: Narayana Vyas Kondreddi: "Re: Reverse engineering tables"
- In reply to: Aaron Bertrand [MVP]: "Re: transfer db from home to work."
- Next in thread: Aaron Bertrand [MVP]: "Re: transfer db from home to work."
- Reply: Aaron Bertrand [MVP]: "Re: transfer db from home to work."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
