Console? For MSDE? Hmmmm....I think I would go looking for whitepapers on MSDN for that. I've used either the SQL Server management tools or Access 2000 projects (which can do a great job of managing MSDE/SQL Server databases, cheaply).


>Thanks JohnK,
>
>I've looked at DTS and it looks like what I will be needing. I'll consider Bob's other idea too. It depends on what access I can get at the other end, and in any case it doesn't look like there is a way to have something in MSDE/SQL Server generate CREATE DATABASE/TABLE commands to do it.
>
>I'm not at all sure what it is exactly that I have installed - I started with a MSDE CD-ROM that came with a version of VS (someone else's, as mine was too early to have had it). Then I installed Office2000 Developer's SQL Server along withsome required patches *first*. It was the first time I tried to access the 'console' when I got the missing .exe (bad shortcut).
>
>Try as I might I simplycannot find a description of what that "console" function is or what I can use it for. Might you have come across anything that describes it?
>
>Thanks again, John
>
>JimN
>
>
>>Hi Jim,
>>
>>What you need is DTS (Data Transformation Services). This is what boosts databases out of MSDE into SQL Server. I don't think DTS ships with MSDE but it sure does with SQL Server. If you have SQL Server, it should be an option in the SQL Server program group. Once you launch it, it's pretty easy to follow as long as the machine you launch it from has a link to the MSDE database.
>>
>>>Placed here for lack of a better subject area (other than Chatter, where it will no doubt quickly be moved out)...
>>>
>>>Everyone SAYS that MSDE is the same as SQL Server (with some restrictions like database size and max. concurrency).
>>>
>>>Possibly it is, with my non-MS intuition again at play.
>>>I bought/installed Office 2000 Developer 1.5 for the sole purpose of getting MSDE under MS Access for a short contract I had.
>>>
>>>I used Access/MSDE (under it) to create a database with 60+ tables and it all seemed to go reasonably well. Then I decided that I wanted to 'relocate' the tables to another (real) SQL Server. But since it is not connected I thought I'd find some import/export facility to do so.
>>>I can see an "Export" option on the files menu but it remains greyed whether the database is 'active' or none is.
>>>
>>>So, I thought, someone has mentioned the "console" before so I'll go use that. Looking around I found Start-->Microsoft SQL Server 7.0-->MSDTC Administrative Console, clicked on it but got 'shortcut not found' (roughly). It was looking for "dac.exe" in WINNT/System32 but it asn't there nor anywhere else.
>>>
>>>So does this mean that I have an installation problem or does it mean that MSDE ain't as "same" as people say it is?
>>>
>>>I was also expecting to be able to make an input stream to define that database and tables as a more permanent/reuseable thing than the manual entry that I did, but see no way to get such to be used if I make them.
>>>
>>>As I said, *MY* intuition never matches MS'. It's like they expect me to know about things before I go looking for things and it just doesn't work (for me).
>>>
>>>Any opinions/help/whatever to get me on some useful track?
>>>
>>>Thanks
>>>
>>>JimN