sorry about that everyone, I was responding to the wrong email.
At 12:59 AM 3/2/01 -0500, you wrote:
>i've never had the defaults/identity stuff transfer successfully, either.
>even between SQL installs, selecting "Transfer Objects". i've resorted to
>scripting the tables, sticking the defaults in myself (scripting will
>capture the identities) and running the scripts on the target system.
>
>chris olive, cio
>cresco technologies
>[EMAIL PROTECTED]
>http://www.crescotech.com
>
>
>
>-----Original Message-----
>From: Dave Watts [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, March 01, 2001 9:02 PM
>To: CF-Talk
>Subject: RE: SQL Server...
>
>
> > 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.
>
>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.)
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>fax: (202) 797-5444
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
