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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
