Yes, doing a SQL to SQL transfer is the best - you get all extended properties etc...
Jason CFDynamics.com > -----Original Message----- > From: Mitko Gerensky-Greene [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 10, 2002 10:56 AM > To: CF-Talk > Subject: RE: Delivering MSSQL DB to Client > > > SQL Server 7/2000 has a very handy Import/Export facility. > Using it you can specify the source and destination servers > and you can export both the database structure and the data. > > Hope that helps, > > Mitko > ---------- Original Message ---------------------------------- > From: "Ben Johnson" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Tue, 10 Sep 2002 10:44:23 -0600 > > >> What's the usual way to deliver a MSSQL (7) DB to the client? > >> (IOW, How do you get it portable, so they can replicate the > >> DB and data on their server?) > > > >Jamie, > > Do you need to send a database structure & a little bit > of data or a > >database structure and a LOT of data? If you're not sending > a lot of > >data, you can send the SQL scripts. Right click the database in > >Enterprise Manager and choose Generate SQL Scripts. Then if > you don't > >have much data, you can create SQL scripts for the inserts. > > > > > >Ben Johnson > >Information Architect > >www.architekture.com > >[p] 720.934.2179 > > > > > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
