copy a table and all its indexes, constraints, etc

How do I copy a table and all of its indexes, constraints, etc. I need to
do this in a routine where I fear possible errors and would like to restore
these tables and constraints if the process fails.
Tx for any help.
Bernie YaegerYou can script the table out and bcp out all its data. You then on an as
needed basis reapply the script and bcp the data back in.
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Bernie Yaeger" <berniey@.cherwellinc.com> wrote in message
news:POyrb.8933$si2.4437406@.news4.srv.hcvlny.cv.net...
> How do I copy a table and all of its indexes, constraints, etc. I need to
> do this in a routine where I fear possible errors and would like to
restore
> these tables and constraints if the process fails.
> Tx for any help.
> Bernie Yaeger
>|||Hi Allan,
Very good idea! Tx so much.
Bernie
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:OZh4AQxpDHA.964@.TK2MSFTNGP10.phx.gbl...
> You can script the table out and bcp out all its data. You then on an as
> needed basis reapply the script and bcp the data back in.
>
> --
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "Bernie Yaeger" <berniey@.cherwellinc.com> wrote in message
> news:POyrb.8933$si2.4437406@.news4.srv.hcvlny.cv.net...
> > How do I copy a table and all of its indexes, constraints, etc. I need
to
> > do this in a routine where I fear possible errors and would like to
> restore
> > these tables and constraints if the process fails.
> >
> > Tx for any help.
> >
> > Bernie Yaeger
> >
> >
>

Converting mySQL database to SQL Server - Help

I am looking to convert a mySQL database to SQL Server 2000 or 2005. I am
interested in converting the structure, data, constraints, keys, etc. I
have some experience with SQL server but none with mySQL. I am a C#
programmer not a DBA.
I am looking for some guidance on the best way to accomplish as complete a
conversion as possible with the minimal changes. Any advice, guidance,
samples or links would be greatly appreciated. Thank you.
hi:
i am just in the migration process of oracle to ms-sqlserver, not only
the datas(db layer) but also
the client programs(from doa component to ado, delphi).
i have done a lot of work, yes, some programs work fine under sql-server
now(little client codes changed,but
a lot of database procedures need to be translate).
but, for mysql, i am a newbie.
"HumbleCoder" <HumbleCoder@.nospam.com> wrote in message
news:eGijl78PFHA.604@.TK2MSFTNGP10.phx.gbl...
> I am looking to convert a mySQL database to SQL Server 2000 or 2005. I am
> interested in converting the structure, data, constraints, keys, etc. I
> have some experience with SQL server but none with mySQL. I am a C#
> programmer not a DBA.
>
> I am looking for some guidance on the best way to accomplish as complete a
> conversion as possible with the minimal changes. Any advice, guidance,
> samples or links would be greatly appreciated. Thank you.
>
|||Humble
Have a look at this article
http://sql-info.de/mysql/gotchas.html --MySQL examples
"HumbleCoder" <HumbleCoder@.nospam.com> wrote in message
news:eGijl78PFHA.604@.TK2MSFTNGP10.phx.gbl...
> I am looking to convert a mySQL database to SQL Server 2000 or 2005. I am
> interested in converting the structure, data, constraints, keys, etc. I
> have some experience with SQL server but none with mySQL. I am a C#
> programmer not a DBA.
>
> I am looking for some guidance on the best way to accomplish as complete a
> conversion as possible with the minimal changes. Any advice, guidance,
> samples or links would be greatly appreciated. Thank you.
>
|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u6rgAP%23PFHA.1268@.TK2MSFTNGP14.phx.gbl...
> Humble
> Have a look at this article
> http://sql-info.de/mysql/gotchas.html --MySQL examples
Are you unaware of sql server service paks?
|||I'd load the mySQL db into a modeling tool such as ERWIN and the FWD
Engineer the SQL Server Version out of that.
Greg Jackson
PDX, Oregon

Converting mySQL database to SQL Server - Help

I am looking to convert a mySQL database to SQL Server 2000 or 2005. I am
interested in converting the structure, data, constraints, keys, etc. I
have some experience with SQL server but none with mySQL. I am a C#
programmer not a DBA.
I am looking for some guidance on the best way to accomplish as complete a
conversion as possible with the minimal changes. Any advice, guidance,
samples or links would be greatly appreciated. Thank you.hi:
i am just in the migration process of oracle to ms-sqlserver, not only
the datas(db layer) but also
the client programs(from doa component to ado, delphi).
i have done a lot of work, yes, some programs work fine under sql-server
now(little client codes changed,but
a lot of database procedures need to be translate).
but, for mysql, i am a newbie.
"HumbleCoder" <HumbleCoder@.nospam.com> wrote in message
news:eGijl78PFHA.604@.TK2MSFTNGP10.phx.gbl...
> I am looking to convert a mySQL database to SQL Server 2000 or 2005. I am
> interested in converting the structure, data, constraints, keys, etc. I
> have some experience with SQL server but none with mySQL. I am a C#
> programmer not a DBA.
>
> I am looking for some guidance on the best way to accomplish as complete a
> conversion as possible with the minimal changes. Any advice, guidance,
> samples or links would be greatly appreciated. Thank you.
>|||Humble
Have a look at this article
http://sql-info.de/mysql/gotchas.html --MySQL examples
"HumbleCoder" <HumbleCoder@.nospam.com> wrote in message
news:eGijl78PFHA.604@.TK2MSFTNGP10.phx.gbl...
> I am looking to convert a mySQL database to SQL Server 2000 or 2005. I am
> interested in converting the structure, data, constraints, keys, etc. I
> have some experience with SQL server but none with mySQL. I am a C#
> programmer not a DBA.
>
> I am looking for some guidance on the best way to accomplish as complete a
> conversion as possible with the minimal changes. Any advice, guidance,
> samples or links would be greatly appreciated. Thank you.
>|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u6rgAP%23PFHA.1268@.TK2MSFTNGP14.phx.gbl...
> Humble
> Have a look at this article
> http://sql-info.de/mysql/gotchas.html --MySQL examples
Are you unaware of sql server service paks? :)|||I'd load the mySQL db into a modeling tool such as ERWIN and the FWD
Engineer the SQL Server Version out of that.
Greg Jackson
PDX, Oregon

Converting mySQL database to SQL Server - Help

I am looking to convert a mySQL database to SQL Server 2000 or 2005. I am
interested in converting the structure, data, constraints, keys, etc. I
have some experience with SQL server but none with mySQL. I am a C#
programmer not a DBA.
I am looking for some guidance on the best way to accomplish as complete a
conversion as possible with the minimal changes. Any advice, guidance,
samples or links would be greatly appreciated. Thank you.
hi:
i am just in the migration process of oracle to ms-sqlserver, not only
the datas(db layer) but also
the client programs(from doa component to ado, delphi).
i have done a lot of work, yes, some programs work fine under sql-server
now(little client codes changed,but
a lot of database procedures need to be translate).
but, for mysql, i am a newbie.
"HumbleCoder" <HumbleCoder@.nospam.com> wrote in message
news:eGijl78PFHA.604@.TK2MSFTNGP10.phx.gbl...
> I am looking to convert a mySQL database to SQL Server 2000 or 2005. I am
> interested in converting the structure, data, constraints, keys, etc. I
> have some experience with SQL server but none with mySQL. I am a C#
> programmer not a DBA.
>
> I am looking for some guidance on the best way to accomplish as complete a
> conversion as possible with the minimal changes. Any advice, guidance,
> samples or links would be greatly appreciated. Thank you.
>
|||Humble
Have a look at this article
http://sql-info.de/mysql/gotchas.html --MySQL examples
"HumbleCoder" <HumbleCoder@.nospam.com> wrote in message
news:eGijl78PFHA.604@.TK2MSFTNGP10.phx.gbl...
> I am looking to convert a mySQL database to SQL Server 2000 or 2005. I am
> interested in converting the structure, data, constraints, keys, etc. I
> have some experience with SQL server but none with mySQL. I am a C#
> programmer not a DBA.
>
> I am looking for some guidance on the best way to accomplish as complete a
> conversion as possible with the minimal changes. Any advice, guidance,
> samples or links would be greatly appreciated. Thank you.
>
|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u6rgAP%23PFHA.1268@.TK2MSFTNGP14.phx.gbl...
> Humble
> Have a look at this article
> http://sql-info.de/mysql/gotchas.html --MySQL examples
Are you unaware of sql server service paks?
|||I'd load the mySQL db into a modeling tool such as ERWIN and the FWD
Engineer the SQL Server Version out of that.
Greg Jackson
PDX, Oregon

Converting mySQL database to SQL Server - Help

I am looking to convert a mySQL database to SQL Server 2000 or 2005. I am
interested in converting the structure, data, constraints, keys, etc. I
have some experience with SQL server but none with mySQL. I am a C#
programmer not a DBA.
I am looking for some guidance on the best way to accomplish as complete a
conversion as possible with the minimal changes. Any advice, guidance,
samples or links would be greatly appreciated. Thank you.hi:
i am just in the migration process of oracle to ms-sqlserver, not only
the datas(db layer) but also
the client programs(from doa component to ado, delphi).
i have done a lot of work, yes, some programs work fine under sql-server
now(little client codes changed,but
a lot of database procedures need to be translate).
but, for mysql, i am a newbie.
"HumbleCoder" <HumbleCoder@.nospam.com> wrote in message
news:eGijl78PFHA.604@.TK2MSFTNGP10.phx.gbl...
> I am looking to convert a mySQL database to SQL Server 2000 or 2005. I am
> interested in converting the structure, data, constraints, keys, etc. I
> have some experience with SQL server but none with mySQL. I am a C#
> programmer not a DBA.
>
> I am looking for some guidance on the best way to accomplish as complete a
> conversion as possible with the minimal changes. Any advice, guidance,
> samples or links would be greatly appreciated. Thank you.
>|||Humble
Have a look at this article
http://sql-info.de/mysql/gotchas.html --MySQL examples
"HumbleCoder" <HumbleCoder@.nospam.com> wrote in message
news:eGijl78PFHA.604@.TK2MSFTNGP10.phx.gbl...
> I am looking to convert a mySQL database to SQL Server 2000 or 2005. I am
> interested in converting the structure, data, constraints, keys, etc. I
> have some experience with SQL server but none with mySQL. I am a C#
> programmer not a DBA.
>
> I am looking for some guidance on the best way to accomplish as complete a
> conversion as possible with the minimal changes. Any advice, guidance,
> samples or links would be greatly appreciated. Thank you.
>|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u6rgAP%23PFHA.1268@.TK2MSFTNGP14.phx.gbl...
> Humble
> Have a look at this article
> http://sql-info.de/mysql/gotchas.html --MySQL examples
Are you unaware of sql server service paks? :)|||I'd load the mySQL db into a modeling tool such as ERWIN and the FWD
Engineer the SQL Server Version out of that.
Greg Jackson
PDX, Oregon

Converting mySQL database to SQL Server - Help

I am looking to convert a mysql database to SQL Server 2000 or 2005. I am
interested in converting the structure, data, constraints, keys, etc. I
have some experience with SQL server but none with mySQL. I am a C#
programmer not a DBA.
I am looking for some guidance on the best way to accomplish as complete a
conversion as possible with the minimal changes. Any advice, guidance,
samples or links would be greatly appreciated. Thank you.hi:
i am just in the migration process of oracle to ms-sqlserver, not only
the datas(db layer) but also
the client programs(from doa component to ado, delphi).
i have done a lot of work, yes, some programs work fine under sql-server
now(little client codes changed,but
a lot of database procedures need to be translate).
but, for mysql, i am a newbie.
"HumbleCoder" <HumbleCoder@.nospam.com> wrote in message
news:eGijl78PFHA.604@.TK2MSFTNGP10.phx.gbl...
> I am looking to convert a mysql database to SQL Server 2000 or 2005. I am
> interested in converting the structure, data, constraints, keys, etc. I
> have some experience with SQL server but none with mySQL. I am a C#
> programmer not a DBA.
>
> I am looking for some guidance on the best way to accomplish as complete a
> conversion as possible with the minimal changes. Any advice, guidance,
> samples or links would be greatly appreciated. Thank you.
>|||Humble
Have a look at this article
http://sql-info.de/mysql/gotchas.html --MySQL examples
"HumbleCoder" <HumbleCoder@.nospam.com> wrote in message
news:eGijl78PFHA.604@.TK2MSFTNGP10.phx.gbl...
> I am looking to convert a mysql database to SQL Server 2000 or 2005. I am
> interested in converting the structure, data, constraints, keys, etc. I
> have some experience with SQL server but none with mySQL. I am a C#
> programmer not a DBA.
>
> I am looking for some guidance on the best way to accomplish as complete a
> conversion as possible with the minimal changes. Any advice, guidance,
> samples or links would be greatly appreciated. Thank you.
>|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u6rgAP%23PFHA.1268@.TK2MSFTNGP14.phx.gbl...
> Humble
> Have a look at this article
> http://sql-info.de/mysql/gotchas.html --MySQL examples
Are you unaware of sql server service paks? |||I'd load the mysql db into a modeling tool such as ERWIN and the FWD
Engineer the SQL Server Version out of that.
Greg Jackson
PDX, Oregon