Oracle to SQLCe

Hi,

Could some one in copying data from Oracle to MS SQLCe, I have the entire table structure on SQLCe.

I want to do it progamatically, if there is tool which will do this activity I am also fine with that.

Hi,

Could you please guide me how to copy data from Oracle to MS SQLCe, I have the entire table structure on SQLCe.

I want to do it progamatically, if there is tool which will do this activity I am also fine with that.

|||

There is no "bulk copy" import facility for SQLCe or class in the namespace that can automate this, but there are a few approaches you might try.

1) Create a Subscription to the Oracle table(s) this would require you to setup a merge replication Publisher on SQL Server Workgroup and import the data there (I expect) before starting. This approach builds the schema on the SqlCe database and imports the data via a merge snapshot.

2) Execute a query against the Oracle database using the OracleClient namespace. This returns one or more DataTable objects. Walk walk through these table(s) and roll your own DDL and INSERT statements and execute them against the SQLCe engine database. This will be expensive code-wise and time-wise but should work reliably.

Other suggestions are encouraged.

Oracle to SQL Server Migration

Hi,
We have an Oracle database with 3200 tables. We want to migrate this
database tables (both structure and data) to SQL Server 2005.
What would be the best way to do that? Is there any automated migration tool
for doing that?
Is there any white paper that explains Oracle to SQL Server migration paths?
Thank you,
MaxWhy don't you post this to Oracle ng's.Imo users of db's other than
MS have more experience with other dbs than do MS users.
"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:ev2rw$LZGHA.1180@.TK2MSFTNGP03.phx.gbl...
> Hi,
>
> We have an Oracle database with 3200 tables. We want to migrate this
> database tables (both structure and data) to SQL Server 2005.
>
> What would be the best way to do that? Is there any automated migration
> tool for doing that?
>
> Is there any white paper that explains Oracle to SQL Server migration
> paths?
>
> Thank you,
> Max
>
>|||You can review several migration solutions.
SSMA is a free tool.
You can access blow url.
http://www.microsoft.com/sql/solutions/ssm/ssmav2.mspx
Also, you can search microsoft.com using keword "SwisSQL".
"Maxwell2006"?? ??? ??:

> Hi,
>
> We have an Oracle database with 3200 tables. We want to migrate this
> database tables (both structure and data) to SQL Server 2005.
>
> What would be the best way to do that? Is there any automated migration to
ol
> for doing that?
>
> Is there any white paper that explains Oracle to SQL Server migration path
s?
>
> Thank you,
> Max
>
>|||> Why don't you post this to Oracle ng's.Imo users of db's other than
> MS have more experience with other dbs than do MS users.
IMHO, Max is more likely to get more/better help here with the migration
task. It won't hurt to ping Oracle forums too but I believe there is more
experience here migrating from Oracle to SQL Server than you'll find in
Oracle forums.
Hope this helps.
Dan Guzman
SQL Server MVP
"Steve Dassin" <steve@.nospamrac4sql.net> wrote in message
news:%23HU9PHNZGHA.3752@.TK2MSFTNGP03.phx.gbl...
> Why don't you post this to Oracle ng's.Imo users of db's other than
> MS have more experience with other dbs than do MS users.
> "Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
> news:ev2rw$LZGHA.1180@.TK2MSFTNGP03.phx.gbl...
>|||In addition to hongju's response, check out
http://www.microsoft.com/technet/in...t.msp
x.
Hope this helps.
Dan Guzman
SQL Server MVP
"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:ev2rw$LZGHA.1180@.TK2MSFTNGP03.phx.gbl...
> Hi,
>
> We have an Oracle database with 3200 tables. We want to migrate this
> database tables (both structure and data) to SQL Server 2005.
>
> What would be the best way to do that? Is there any automated migration
> tool for doing that?
>
> Is there any white paper that explains Oracle to SQL Server migration
> paths?
>
> Thank you,
> Max
>
>|||Ok where to find the devil as regards to 'the devil is in the details'.:)
www.rac4sql.net
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:uk2FVrNZGHA.1580@.TK2MSFTNGP02.phx.gbl...
> IMHO, Max is more likely to get more/better help here with the migration
> task. It won't hurt to ping Oracle forums too but I believe there is more
> experience here migrating from Oracle to SQL Server than you'll find in
> Oracle forums.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Steve Dassin" <steve@.nospamrac4sql.net> wrote in message
> news:%23HU9PHNZGHA.3752@.TK2MSFTNGP03.phx.gbl...
>|||Having done that several times, I' d like to warn you: that's a very
serious undertaking. IMHO existing tools will only get you that far.
Blocking/concurrency implemetation is enirely different, and there are
lots of other differences. I can give you dozens of scenarios when a
"ported" application raises no syntax errors but gives different
results and/or performs very poorly.
To make long story short, be ready to rewrite at least some of your
code.|||As far as blocking/concurrency is concerned, SQL Server 2005 supports
versioning based concurrency now. So migration should be a bit smoother than
in previous SQL Server versions.
Bob Beauchemin
http://www.SQLskills.com
"Alexander Kuznetsov" <AK_TIREDOFSPAM@.hotmail.COM> wrote in message
news:1145590726.530114.67950@.e56g2000cwe.googlegroups.com...
> Having done that several times, I' d like to warn you: that's a very
> serious undertaking. IMHO existing tools will only get you that far.
> Blocking/concurrency implemetation is enirely different, and there are
> lots of other differences. I can give you dozens of scenarios when a
> "ported" application raises no syntax errors but gives different
> results and/or performs very poorly.
> To make long story short, be ready to rewrite at least some of your
> code.
>|||I agree, whilst on the Ascend course last year, which was run by, errrrm,
BOB! (Hi Bob) my face lit up when he told, and demonstrated the Row
versioning functionality.
Some code changes may be unavoidable, but SQL2005 can work almost exactly
like Oracle, although this does cost a little in overall performance
(currently, it seems to be about .5%) If a program is developed on SQL
only, I'd not suggest using it, but in an oracle simulation mode, it will
save alot of hassle.
Back to the original question. There are tools around which will port schema
and datastructures. I've not had too much experience with these, but it
seems that these will need checking, not only that the structure of the new
tables are the equivilant, but that all the constraints have also been
copied. In short the tools will get you started, but I doubt that they can
be trusted to complete the job.
Regards
Colin Dawson
www.cjdawson.com
"Bob Beauchemin" <bobb_no_spam@.SQLskills.com> wrote in message
news:%23aCJOYQZGHA.4612@.TK2MSFTNGP03.phx.gbl...
> As far as blocking/concurrency is concerned, SQL Server 2005 supports
> versioning based concurrency now. So migration should be a bit smoother
> than in previous SQL Server versions.
> Bob Beauchemin
> http://www.SQLskills.com
> "Alexander Kuznetsov" <AK_TIREDOFSPAM@.hotmail.COM> wrote in message
> news:1145590726.530114.67950@.e56g2000cwe.googlegroups.com...
>|||Also refer http://www.akadia.com/services/sqlsrv2ora.html
Madhivanan