in sql 2005 -- what's the best way for me to make a complete copy of my database - including indexes and keys and everything??
i tried backup but when restoring to the second i get an error with multiple media sets.What error are you getting on the restore?|||If you are restoring to the same server, then you need to rename all of the physical files.|||Msg 3132, Level 16, State 1, Line 1
The media set has 2 media families but only 1 are provided. All members must be provided.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I am doing
RESTORE DATABASE trafficr
FROM DISK = 'c:\backups\traffic.bak'
WITH MOVE 'traffic' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\trafficr.mdf',
MOVE 'traffic_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\trafficr_log.ldf',
REPLACE|||What's with the commas at the end of each line?|||this is the syntax i'm using for sql server - -is it wrong?
i think it once worked but not working now - maybe with the way i did the backup? how should i do the backup so one media|||post the output of this:
RESTORE headeronly FROM DISK = 'c:\backups\traffic.bak'
you may have more than one backup in the file.sqlsql
Showing posts with label keys. Show all posts
Showing posts with label keys. Show all posts
Sunday, March 25, 2012
Copy Date Dimension
Hello Guys and Galls,
I have a fact table with two different keys referring to the same date dimension table. In a query you would use table aliassing to join the date dimension twice.
In AS I created a DSV with two aliasses of the date dimension table. Lets give um names:
- dim_ActivityDate
- dim_OrderDate
Now, I have created a dimension "Activity Date", based on the dim_ActivityDate dimension. I want to create a second dimension, "Order Date", which is a copy of the "Activity Date" dimension, but based on the dim_OrderDate alias from the DSV.
Is there an easy way to do this, or do I have to create the whole dimension using the wizard again?
Regards, Jeroen
Hi Jeroen,
No, you don't need to create two separate physical dimensions. You just need to create one dimension and add it to the cube more than once - a 'role playing dimension'. In Visual Studio just double click on your cube to edit it and assuming you have the dimension already added to the cube once, you just need to right-click on Dimensions box in the bottom-right-hand corner of the 'Cube Structure' tab and select 'Add Cube Dimension'. Add the date dimension again and you'll find that it gets added with a new name, which you can change to Order Date, and then if you go to the Dimension Usage tab you'll find you can join it to your measure group on the dim_OrderDate key column.
HTH,
Chris
|||Splendid! Thnx Chris.Friday, February 10, 2012
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
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
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
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
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
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 FWDEngineer the SQL Server Version out of that.
Greg Jackson
PDX, Oregon
Subscribe to:
Posts (Atom)