At 09:02 PM 03/01/2001 -0500, you wrote:
> > I used the SQL Server export function (Data Transformation
> > Service) to move data (and table structure) from one SQL Server
> > database to a blank SQL Server database. Everything looked fine
> > initially, however I have realized that it did not copy over
> > default value. Nor did it copy over seed information.
> >
> > Is this common? Is there a better way to do this (Other than
> > detaching / attaching the database)? Although I haven't verified
> > it yet, I do suspect that I exported the data from a SQL Server
> > 2000 DB into a SQL Server 7 DB. Would I experience the same
> > results if this occurred between to SQL Server 2000 DBs?
>
>Typically, when transferring between two SQL 7 servers, you have an option
>to transfer "objects and data". This gets not only the tables and their
>data, but everything else as well.
That's why I did... (I swear it) It just didn't seem to copy over
every bit of the object.
>In addition, you can do a backup to file from one, then restore from file on
>the other. I've had better luck with that, with pre-SP versions of SQL 7.
>This is better than detaching and attaching, since you don't have to stop
>operation of the database on the source server, and you don't have problems
>with "phantom logins" that might exist in one server but not the other.
>(Although there is a way to address that, if necessary.)
I'll have to look at the backup and restore options. I've never been
happy with Attach and Detach before.
Jeff Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 5.0 | ISBN: 0-07-213238-8
Due out 3rd Quarter 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
I've got the brains, you've got the looks, let's make lots of money
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
