Mirror Database in SQL 2000

I am using MS SQL 2000 Standard, is it possible to create a mirror database in SQL 2000? If so, would you suggest how to do this. Thanks! I am a newbie about this.

Unfortunately mirroring is a SQL Server 2005 feature.

You could do log shipping in SQL Server 2000 but that is not exactly the same as mirroring.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

However, I am using SQL Server 2000 Std. which doesn't includes log shipping feature! Besides replication, any other features could do the function of mirroring?

|||

I'm afraid only an upgrade to SQL Server 2005 will give you the full power.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

Migration Tools

Can somebody suggest me migration tools for DB2 to SQL Server?
Thanks
Prashanttry this perhaps:

http://www.swissql.com/products/db2-to-sqlserver/db2-to-sql-server.html

Bill

Migration Tool

Can somebody suggest me migration tool for DB2 to SQL Server?
Thanks
Prashant
Prashant,
1. Create a linkedserver for DB2 - small quick migration
or
2. Use DTS (Data Transformation Services) - many tables
or
3. BCP (IN) - larger migration
or
4. Replication - depending on the needs
or
5. Third-party tool i.e.,
http://www.starquest.com/Productfolder/infoSQDR.html or
http://www.google.com/search?hl=en&l...&btnG =Search
HTH
Jerry
"Prashant Bharti" <prashantb@.aditi.com> wrote in message
news:uCaugHV2FHA.2472@.TK2MSFTNGP12.phx.gbl...
> Can somebody suggest me migration tool for DB2 to SQL Server?
> Thanks
> Prashant
>
|||Microsoft has plenty of information for migration from Oracle to MS SQL, but there
is nothing out there for DB2. What is the reason behind this, and will we soon see
a SSAM for DB2, as it already exists for Oracle ?
best regards
andreas
On Tue, 25 Oct 2005 08:26:56 -0700, "Jerry Spivey" <jspivey@.vestas-awt.com> wrote:

>Prashant,
>1. Create a linkedserver for DB2 - small quick migration
>or
>2. Use DTS (Data Transformation Services) - many tables
>or
>3. BCP (IN) - larger migration
>or
>4. Replication - depending on the needs
>or
>5. Third-party tool i.e.,
>http://www.starquest.com/Productfolder/infoSQDR.html or
>http://www.google.com/search?hl=en&l...&btnG =Search
>HTH
>Jerry
>"Prashant Bharti" <prashantb@.aditi.com> wrote in message
>news:uCaugHV2FHA.2472@.TK2MSFTNGP12.phx.gbl...
>

Migration Tool

Can somebody suggest me migration tool for DB2 to SQL Server?
Thanks
PrashantPrashant,
1. Create a linkedserver for DB2 - small quick migration
or
2. Use DTS (Data Transformation Services) - many tables
or
3. BCP (IN) - larger migration
or
4. Replication - depending on the needs
or
5. Third-party tool i.e.,
http://www.starquest.com/Productfolder/infoSQDR.html or
http://www.google.com/search?hl=en&lr=&q=migrate+db2+to+sql+server+&btnG=Search
HTH
Jerry
"Prashant Bharti" <prashantb@.aditi.com> wrote in message
news:uCaugHV2FHA.2472@.TK2MSFTNGP12.phx.gbl...
> Can somebody suggest me migration tool for DB2 to SQL Server?
> Thanks
> Prashant
>|||Microsoft has plenty of information for migration from Oracle to MS SQL, but there
is nothing out there for DB2. What is the reason behind this, and will we soon see
a SSAM for DB2, as it already exists for Oracle ?
best regards
andreas
On Tue, 25 Oct 2005 08:26:56 -0700, "Jerry Spivey" <jspivey@.vestas-awt.com> wrote:
>Prashant,
>1. Create a linkedserver for DB2 - small quick migration
>or
>2. Use DTS (Data Transformation Services) - many tables
>or
>3. BCP (IN) - larger migration
>or
>4. Replication - depending on the needs
>or
>5. Third-party tool i.e.,
>http://www.starquest.com/Productfolder/infoSQDR.html or
>http://www.google.com/search?hl=en&lr=&q=migrate+db2+to+sql+server+&btnG=Search
>HTH
>Jerry
>"Prashant Bharti" <prashantb@.aditi.com> wrote in message
>news:uCaugHV2FHA.2472@.TK2MSFTNGP12.phx.gbl...
>> Can somebody suggest me migration tool for DB2 to SQL Server?
>> Thanks
>> Prashant
>

Migration Tool

Can somebody suggest me migration tool for DB2 to SQL Server?
Thanks
PrashantPrashant,
1. Create a linkedserver for DB2 - small quick migration
or
2. Use DTS (Data Transformation Services) - many tables
or
3. BCP (IN) - larger migration
or
4. Replication - depending on the needs
or
5. Third-party tool i.e.,
http://www.starquest.com/Productfolder/infoSQDR.html or
[url]http://www.google.com/search?hl=en&lr=&q=migrate+db2+to+sql+server+&btnG=Search[/u
rl]
HTH
Jerry
"Prashant Bharti" <prashantb@.aditi.com> wrote in message
news:uCaugHV2FHA.2472@.TK2MSFTNGP12.phx.gbl...
> Can somebody suggest me migration tool for DB2 to SQL Server?
> Thanks
> Prashant
>|||Microsoft has plenty of information for migration from Oracle to MS SQL, but
there
is nothing out there for DB2. What is the reason behind this, and will we so
on see
a SSAM for DB2, as it already exists for Oracle ?
best regards
andreas
On Tue, 25 Oct 2005 08:26:56 -0700, "Jerry Spivey" <jspivey@.vestas-awt.com>
wrote:

>Prashant,
>1. Create a linkedserver for DB2 - small quick migration
>or
>2. Use DTS (Data Transformation Services) - many tables
>or
>3. BCP (IN) - larger migration
>or
>4. Replication - depending on the needs
>or
>5. Third-party tool i.e.,
>http://www.starquest.com/Productfolder/infoSQDR.html or
>[url]http://www.google.com/search?hl=en&lr=&q=migrate+db2+to+sql+server+&btnG=Search[/
url]
>HTH
>Jerry
>"Prashant Bharti" <prashantb@.aditi.com> wrote in message
>news:uCaugHV2FHA.2472@.TK2MSFTNGP12.phx.gbl...
>