Showing posts with label includes. Show all posts
Showing posts with label includes. Show all posts

Friday, March 30, 2012

Migrating form Oracle 8 to SQL2000

Has there anyone heard these two 3rd-party tool "SwisSQL" and "DbBest",
which say can full converting Oracle to SQL Server, includes Triggers and
Views?
I got this on KB already
http://www.microsoft.com/resources/...r />
0761.mspx
but I still hope if there're some other choice and much more convenient...I heard of both the products, but I have seen DBBest in action at PASS 2003,
in Seattle, WA. Though I haven't tried it myself, it seems like a very good
product.
This might help:
http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"unwar" <anonymous@.discussions.microsoft.com> wrote in message
news:uclsp0xCEHA.1600@.tk2msftngp13.phx.gbl...
Has there anyone heard these two 3rd-party tool "SwisSQL" and "DbBest",
which say can full converting Oracle to SQL Server, includes Triggers and
Views?
I got this on KB already
http://www.microsoft.com/resources/...r />
0761.mspx
but I still hope if there're some other choice and much more convenient...

Friday, March 23, 2012

Migrate to Compact Edition

What is the fastest way to migrate a database from SQL server express to sql compact edition. My database includes one stored procedure. Do I have to rewrite it into the code of my application?You can use some of the tools from www.primeworks-mobile.com (Data Port Wizard, for example) and yes, stored procedures does not exist in SQL Compact, so you will have to rewrite it as procedural code.|||

It looks fantastic, but it fails when I try to connect it to a SQL compact database even it does not have a password

Migrate to Compact Edition

What is the fastest way to migrate a database from SQL server express to sql compact edition. My database includes one stored procedure. Do I have to rewrite it into the code of my application?You can use some of the tools from www.primeworks-mobile.com (Data Port Wizard, for example) and yes, stored procedures does not exist in SQL Compact, so you will have to rewrite it as procedural code.|||

It looks fantastic, but it fails when I try to connect it to a SQL compact database even it does not have a password