Migraton from Enterprise to Standard

Hi
I wan to migrate an SQL Enterprise server system to SQL Standard system.
Can somebody guide me throgh the process?
Thanks
KNDHi,
Is it a SQL2000? If so, refer:
'INF: Effects of Moving a Database from SQL 2000 Enterprise Edition to SQL
2000 Standard Edition'
http://support.microsoft.com/default.aspx?id=268361
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"KND" <anonymous@.discussions.microsoft.com> wrote in message
news:52E54DFE-58E4-4D2B-93AB-49A9CA083F03@.microsoft.com...
> Hi
> I wan to migrate an SQL Enterprise server system to SQL Standard system.
> Can somebody guide me throgh the process?
> Thanks
> KND

Migraton from Enterprise to Standard

Hi
I wan to migrate an SQL Enterprise server system to SQL Standard system.
Can somebody guide me throgh the process?
Thanks
KND
Hi,
Is it a SQL2000? If so, refer:
'INF: Effects of Moving a Database from SQL 2000 Enterprise Edition to SQL
2000 Standard Edition'
http://support.microsoft.com/default.aspx?id=268361
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"KND" <anonymous@.discussions.microsoft.com> wrote in message
news:52E54DFE-58E4-4D2B-93AB-49A9CA083F03@.microsoft.com...
> Hi
> I wan to migrate an SQL Enterprise server system to SQL Standard system.
> Can somebody guide me throgh the process?
> Thanks
> KND

Migraton from Enterprise to Standard

H
I wan to migrate an SQL Enterprise server system to SQL Standard system
Can somebody guide me throgh the process
Thank
KNDHi,
Is it a SQL2000? If so, refer:
'INF: Effects of Moving a Database from SQL 2000 Enterprise Edition to SQL
2000 Standard Edition'
http://support.microsoft.com/default.aspx?id=268361
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"KND" <anonymous@.discussions.microsoft.com> wrote in message
news:52E54DFE-58E4-4D2B-93AB-49A9CA083F03@.microsoft.com...
> Hi
> I wan to migrate an SQL Enterprise server system to SQL Standard system.
> Can somebody guide me throgh the process?
> Thanks
> KND

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...
>