The simplest way would be to use the import or export features of SQL server
to connect the two servers together and transfer the database. Although, if
that's not an option, you could also try backing up the SQL database and
restoring it on the other server or you can export the SQL database to
Access, import it to the other SQL server, and reset all the constraints
manually.
There's many other ways to do it as well.
Perhaps if you could explain the situation more clearly, we could provide
you with a solution that best fits your needs.
---mark
------------------------------------
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
====================================
> -----Original Message-----
> From: Mike [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 25, 2001 10:34 AM
> To: CF-Talk
> Subject: SQL2000 Move data
>
>
> I need to move an entire data base from one SQL Server to
> anouther with ftp
> or zipdisk/cdrom.
> How is this done
> Thanks Mike
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
