Sunday, February 26, 2012

Databases in SQL Server 2000

I would like to know what is the design of database stored
in the Microsoft SQL Server 2000, Microsoft FoxPro or
Microsoft Access or totally new database?
Can database other than by Microsoft, such as Oracle,
reside in Microsoft SQL Server 2000?You can use DTS in SQL Server to get data from Oracle or FoxPro or Access
into SQL Server. But if you're asking if you can just take an Oracle
database and run it natively in SQL Server, no.
"Max Takaki" <mtakaki@.sjc.org> wrote in message
news:0e7b01c35137$e00cc410$a601280a@.phx.gbl...
> I would like to know what is the design of database stored
> in the Microsoft SQL Server 2000, Microsoft FoxPro or
> Microsoft Access or totally new database?
> Can database other than by Microsoft, such as Oracle,
> reside in Microsoft SQL Server 2000?|||Max,
Reside in SQL Server in their native format itself? No.But you can use
conversion tools like the built-in DTS to convert non-MS databases,FP,
Access etc to SQL Server ones.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Max Takaki" <mtakaki@.sjc.org> wrote in message
news:0e7b01c35137$e00cc410$a601280a@.phx.gbl...
> I would like to know what is the design of database stored
> in the Microsoft SQL Server 2000, Microsoft FoxPro or
> Microsoft Access or totally new database?
> Can database other than by Microsoft, such as Oracle,
> reside in Microsoft SQL Server 2000?