Clone a SQL Server

We are in the process of upgrading from SQL Server 7 to SQL Server 2000.

Before we do that we want to run our system on our new server in a test environment to iron out any issues which may arrive from the upgrade, and to use for future testing. Is there a way to 'clone' a SQL 7 server onto a 2nd physical machine.

ThanksYou could restore sql7 database on sql2k box and do whatever tests needed.|||Originally posted by oj_n
You could restore sql7 database on sql2k box and do whatever tests needed.

I need to make sure all of the DTS pacjkages go as well.|||Here is a good kb that should help you...

http://support.microsoft.com/?id=314546|||There is a utility called DTSBackup2000 that's available free from SQLDTS.com. It works quite well, though I don't know what impact migrating from 7.0 to 2000 might have.

Regards,

Hugh Scott

Originally posted by GregCrossan
I need to make sure all of the DTS pacjkages go as well.

Client components

I have an application that connects to a SQL 2000 database on another
machine.
We are upgrading this to work with SQL 2005 or SQL 2000.
The application uses SQLDMO objects and ADO objects (written in C++)
At the moment we include sqlredist.exe in the install package for the
client.
We have found that we also need to install the Backwards Compatability
components to let us use SQLDMO with SQL 2005.
What is the smallest (and what are they) set of components we need to
install on the client to have our application work with either SQL 2000 or
SQL 2005.
Michael Tissington
http://www.oaklodge.com
http://www.sqlview.netYou should be able to use just the installer for the
Backwards Compatibility Components - SQLServer2005_BC.msi
You can download it from:
http://www.microsoft.com/downloads/...&displaylang=en
-Sue
On Thu, 1 Jun 2006 21:04:58 -0700, "Michael Tissington"
<mtissington@.newsgroups.nospam> wrote:

>I have an application that connects to a SQL 2000 database on another
>machine.
>We are upgrading this to work with SQL 2005 or SQL 2000.
>The application uses SQLDMO objects and ADO objects (written in C++)
>At the moment we include sqlredist.exe in the install package for the
>client.
>We have found that we also need to install the Backwards Compatability
>components to let us use SQLDMO with SQL 2005.
>What is the smallest (and what are they) set of components we need to
>install on the client to have our application work with either SQL 2000 or
>SQL 2005.

ClickOnce for SQL Express Database?

I'm working on an app in Visual Studio 2005 that needs to have installed locally SQL Express to handle its own data.

This app is in a strong upgrading process. I've been using clickonce to publish the app and let my users upgrade automatically (by the way this works amazing ...).

Yet many times changes to the DB are made. Is there a simple way to upgrade their local SQL Express DB like click once does with the app?

Thanks.

hi,

I'm not sure about click once capability to perform the requested task, but even if possible, are you sure you like to do it? that means you would upgrade users database loosing their data modifications... I do think you've better just "upgrade" the database schema and not replace their database...

if this is the case, you can perhaps have a look at syncornization tools like http://www.red-gate.com/products/SQL_Compare/index.htm..

regards

|||

Thanks, the products looks like a very good solution. I've already downloaded it and I'm testing.

Have you used it yourself? Do you know other products that do the same?

|||

hi,

yes, I do use it myself since versions 2...

I know other similar tools are available out there, like http://www.innovartis.co.uk/database_dbghost_home.aspx, but I've always been satisfied by red-gate tools.. they even provides http://www.red-gate.com/products/SQL_Packager/index.htm, base on SQL Compare tool, to just distribute an exe packaged file that, at run time, will perform the metadata updates for you..

but here we are in advertising mode

BTW, I'm not involved in any way with the reported products/company, I'm just a user as you could be..

for further info, a free comparison tool is available at http://www.absistemi.it/sqlCompare.aspx by another italian SQL Server MVP fellow, but I'm not sure it has been updated for SQL Server 2005...

regards

|||Grazie tante ...|||

prego...

(you're welcome)