RE: Delivering MSSQL DB to Client

2002-09-10 Thread Ben Johnson
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

RE: Delivering MSSQL DB to Client

2002-09-10 Thread Mitko Gerensky-Greene
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

RE: Delivering MSSQL DB to Client

2002-09-10 Thread Jason Egan
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