|
Home > Archive > SQL Anywhere ultralite > February 2006 > ultralite schema from SQL Server consolidated
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
ultralite schema from SQL Server consolidated
|
|
| Spencer Wasden 2006-02-09, 1:23 pm |
| SQLAnywhere Studio 9.0.2.3131
How can a generate an Ultralite schema from a SQL Server (or Oracle, DB2,
etc) consolidated database without using schema painter (I need to automate
this). The ulinit documentation says "The utility connects to an Adaptive
Server Anywhere database."
| |
| Greg Fenton 2006-02-10, 3:23 am |
| Spencer Wasden wrote:
> SQLAnywhere Studio 9.0.2.3131
>
> How can a generate an Ultralite schema from a SQL Server (or Oracle, DB2,
> etc) consolidated database without using schema painter (I need to automate
> this). The ulinit documentation says "The utility connects to an Adaptive
> Server Anywhere database."
Use the Migrate Database utility (or the sa_migrate stored procedure) to
migrate the schema from your target consolidated to a new ASA database.
Then you can use ulinit against that (temporary) ASA db.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| Shuchit 2006-02-11, 9:23 am |
| "Spencer Wasden" <spencer. wasden@mobiledatafor
ce_xspm.com> wrote in
news:43eb8b78$1@foru
ms-1-dub:
> SQLAnywhere Studio 9.0.2.3131
>
> How can a generate an Ultralite schema from a SQL Server (or Oracle,
> DB2, etc) consolidated database without using schema painter (I need to
> automate this). The ulinit documentation says "The utility connects to
> an Adaptive Server Anywhere database."
>
If you can export the schema in the xml format that ulxml wants, you can use
ulxml to generate the ultralite schema file.
Lookup ulxml in the documentation. It will point you to samples and the xsd
for the format.
Shuchit
|
|
|
|
|