|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Tools with/for Expressintroduced, and 7.0 before that. I have a specific requirement that will be served by Express 2005. Initially I only need to be able to create a table using a script, copy data into it with an append query from other sources, manage indexes for it, and run performance tests. Would my existing Query Analyzer for 2000 do this? Is there a new Developer Edition that would be better, and would it be absolutely required? I'm researching this through the MS web site, but the need is sudden and I'm very pressed for time. You never learn about a client's needs till the last second, and they never view the problem in terms of the resources I'll need to do it. Thanks very much for your kind responses, helping get me on track quickly to a solution. I really need to be working later today if possible, and don't have time to wait even for overnight shipment on this. I know I can download Express very quickly. I'm mad at myself that I don't now have MSDN Universal. I promise I will have it again soon. That's what I get for trying to be responsive to my client's needs. So, a thousand thanks and more! Tom Ellison > I've been using SQL Server 2000 and MSDE intensively ever since it was Well, I don't know if the new tools work with the old servers, I think> introduced, and 7.0 before that. I have a specific requirement that will be > served by Express 2005. > > Initially I only need to be able to create a table using a script, copy data > into it with an append query from other sources, manage indexes for it, and > run performance tests. Would my existing Query Analyzer for 2000 do this? > Is there a new Developer Edition that would be better, and would it be > absolutely required? they do. But there are also third party products that have support for all of these versions. For example, Database Workbench ( www.upscene.com ), our tool, supports SQL Server 6.5 through 2005, including MSDE1&2 and SQL Express. -- Show quoteMartijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com > I'm researching this through the MS web site, but the need is sudden and I'm > very pressed for time. You never learn about a client's needs till the last > second, and they never view the problem in terms of the resources I'll need > to do it. > > Thanks very much for your kind responses, helping get me on track quickly to > a solution. I really need to be working later today if possible, and don't > have time to wait even for overnight shipment on this. I know I can > download Express very quickly. I'm mad at myself that I don't now have MSDN > Universal. I promise I will have it again soon. > > That's what I get for trying to be responsive to my client's needs. > > So, a thousand thanks and more! > > Tom Ellison > > QA can still access 2005 and should be fine for running scripts. There will
be a management tool for express released shortly that will allow you to manage things with the gui. There is a beta now available on the web site. -- Show quoteAndrew J. Kelly SQL MVP "Tom Ellison" <telli***@jcdoyle.com> wrote in message news:OL5OGR%23MGHA.720@TK2MSFTNGP14.phx.gbl... > I've been using SQL Server 2000 and MSDE intensively ever since it was > introduced, and 7.0 before that. I have a specific requirement that will > be served by Express 2005. > > Initially I only need to be able to create a table using a script, copy > data into it with an append query from other sources, manage indexes for > it, and run performance tests. Would my existing Query Analyzer for 2000 > do this? Is there a new Developer Edition that would be better, and would > it be absolutely required? > > I'm researching this through the MS web site, but the need is sudden and > I'm very pressed for time. You never learn about a client's needs till > the last second, and they never view the problem in terms of the resources > I'll need to do it. > > Thanks very much for your kind responses, helping get me on track quickly > to a solution. I really need to be working later today if possible, and > don't have time to wait even for overnight shipment on this. I know I can > download Express very quickly. I'm mad at myself that I don't now have > MSDN Universal. I promise I will have it again soon. > > That's what I get for trying to be responsive to my client's needs. > > So, a thousand thanks and more! > > Tom Ellison > > Dear Andrew:
That's great news. Thanks for your reply. I'm ready to get to work right away! Tom Ellison Show quote "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:u7nfyG$MGHA.3100@tk2msftngp13.phx.gbl... > QA can still access 2005 and should be fine for running scripts. There > will be a management tool for express released shortly that will allow you > to manage things with the gui. There is a beta now available on the web > site. > > -- > Andrew J. Kelly SQL MVP > > > "Tom Ellison" <telli***@jcdoyle.com> wrote in message > news:OL5OGR%23MGHA.720@TK2MSFTNGP14.phx.gbl... >> I've been using SQL Server 2000 and MSDE intensively ever since it was >> introduced, and 7.0 before that. I have a specific requirement that will >> be served by Express 2005. >> >> Initially I only need to be able to create a table using a script, copy >> data into it with an append query from other sources, manage indexes for >> it, and run performance tests. Would my existing Query Analyzer for 2000 >> do this? Is there a new Developer Edition that would be better, and would >> it be absolutely required? >> >> I'm researching this through the MS web site, but the need is sudden and >> I'm very pressed for time. You never learn about a client's needs till >> the last second, and they never view the problem in terms of the >> resources I'll need to do it. >> >> Thanks very much for your kind responses, helping get me on track quickly >> to a solution. I really need to be working later today if possible, and >> don't have time to wait even for overnight shipment on this. I know I >> can download Express very quickly. I'm mad at myself that I don't now >> have MSDN Universal. I promise I will have it again soon. >> >> That's what I get for trying to be responsive to my client's needs. >> >> So, a thousand thanks and more! >> >> Tom Ellison >> >> > > Dear Andrew:
I'm off to a pretty good start with this. I had to start with SQL Server Service Manager. This showed me the new instance, which had been named SQLEXPRESS. I then attempted to use Query Analyzer. It didn't find the new instance, but when I manually chose the named instance above, and put in the user and password, it did open. I can see the appropriate databases inside. No such luck with Enterprise Manager. Again, I had to manually give it the name, as it didn't detect the new instance. But this time, it doesn't find the instance. Now, due to your help, I'm off and running. I usually use EM a bit to do my work, but there's nothing here I don't know how to do just using QA. If you have any suggestions what may be up with EM, it would be helpful. But your eariler response has been most helpful in getting me started, and I'm very grateful. I tried harder to get it started because your response told me I was on the right track, and you were absolutely correct. So, it nose to the grindwheel now, but I'll be back to see if you have any additional helpful suggestion. After all, QA has been where I have "lived" the past 5 years. Assuming there's no limits to what it can do with SQL Express, there should be no problems. Thanks, very much! Tom Ellison Show quote "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:u7nfyG$MGHA.3100@tk2msftngp13.phx.gbl... > QA can still access 2005 and should be fine for running scripts. There > will be a management tool for express released shortly that will allow you > to manage things with the gui. There is a beta now available on the web > site. > > -- > Andrew J. Kelly SQL MVP > > > "Tom Ellison" <telli***@jcdoyle.com> wrote in message > news:OL5OGR%23MGHA.720@TK2MSFTNGP14.phx.gbl... >> I've been using SQL Server 2000 and MSDE intensively ever since it was >> introduced, and 7.0 before that. I have a specific requirement that will >> be served by Express 2005. >> >> Initially I only need to be able to create a table using a script, copy >> data into it with an append query from other sources, manage indexes for >> it, and run performance tests. Would my existing Query Analyzer for 2000 >> do this? Is there a new Developer Edition that would be better, and would >> it be absolutely required? >> >> I'm researching this through the MS web site, but the need is sudden and >> I'm very pressed for time. You never learn about a client's needs till >> the last second, and they never view the problem in terms of the >> resources I'll need to do it. >> >> Thanks very much for your kind responses, helping get me on track quickly >> to a solution. I really need to be working later today if possible, and >> don't have time to wait even for overnight shipment on this. I know I >> can download Express very quickly. I'm mad at myself that I don't now >> have MSDN Universal. I promise I will have it again soon. >> >> That's what I get for trying to be responsive to my client's needs. >> >> So, a thousand thanks and more! >> >> Tom Ellison >> >> > > Tom Ellison (telli***@jcdoyle.com) writes:
> No such luck with Enterprise Manager. Again, I had to manually give it That's correct. EM cannot connect to SQL 2005. EM relies heavily on DMO,> the name, as it didn't detect the new instance. But this time, it > doesn't find the instance. and DMO has been replaced by SMO in SQL 2005. The same goes for Profiler. There are a few corners where you will run into to roadblocks with Query Analyzer as well, but as long as you are only running queries, it works great. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx Enterprise Manager does not work with SQL Server 2005. Basically, Query
Analyzer is pretty dumb and just passes on what you type, so it still works. But Enterprise Manager tries to write it's own code and it doesn't use SQL Server 2005 syntax when it's different or know how to display the new data types, so it is blocked. If you want features similar to Enterprise Manager, use Management Studio such as http://www.microsoft.com/downloads/details.aspx?familyid=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en -- Show quoteRick Byham MCDBA, MCSE, MCSA Documentation Manager, Microsoft, SQL Server Books Online This posting is provided "as is" with no warranties, and confers no rights. "Tom Ellison" <telli***@jcdoyle.com> wrote in message news:u1Iz5$$MGHA.3832@tk2msftngp13.phx.gbl... > Dear Andrew: > > I'm off to a pretty good start with this. I had to start with SQL Server > Service Manager. This showed me the new instance, which had been named > SQLEXPRESS. > > I then attempted to use Query Analyzer. It didn't find the new instance, > but when I manually chose the named instance above, and put in the user > and password, it did open. I can see the appropriate databases inside. > > No such luck with Enterprise Manager. Again, I had to manually give it > the name, as it didn't detect the new instance. But this time, it doesn't > find the instance. > > Now, due to your help, I'm off and running. I usually use EM a bit to do > my work, but there's nothing here I don't know how to do just using QA. > If you have any suggestions what may be up with EM, it would be helpful. > But your eariler response has been most helpful in getting me started, and > I'm very grateful. I tried harder to get it started because your response > told me I was on the right track, and you were absolutely correct. So, it > nose to the grindwheel now, but I'll be back to see if you have any > additional helpful suggestion. > > After all, QA has been where I have "lived" the past 5 years. Assuming > there's no limits to what it can do with SQL Express, there should be no > problems. > > Thanks, very much! > > Tom Ellison > > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:u7nfyG$MGHA.3100@tk2msftngp13.phx.gbl... >> QA can still access 2005 and should be fine for running scripts. There >> will be a management tool for express released shortly that will allow >> you to manage things with the gui. There is a beta now available on the >> web site. >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> "Tom Ellison" <telli***@jcdoyle.com> wrote in message >> news:OL5OGR%23MGHA.720@TK2MSFTNGP14.phx.gbl... >>> I've been using SQL Server 2000 and MSDE intensively ever since it was >>> introduced, and 7.0 before that. I have a specific requirement that >>> will be served by Express 2005. >>> >>> Initially I only need to be able to create a table using a script, copy >>> data into it with an append query from other sources, manage indexes for >>> it, and run performance tests. Would my existing Query Analyzer for >>> 2000 do this? Is there a new Developer Edition that would be better, and >>> would it be absolutely required? >>> >>> I'm researching this through the MS web site, but the need is sudden and >>> I'm very pressed for time. You never learn about a client's needs till >>> the last second, and they never view the problem in terms of the >>> resources I'll need to do it. >>> >>> Thanks very much for your kind responses, helping get me on track >>> quickly to a solution. I really need to be working later today if >>> possible, and don't have time to wait even for overnight shipment on >>> this. I know I can download Express very quickly. I'm mad at myself >>> that I don't now have MSDN Universal. I promise I will have it again >>> soon. >>> >>> That's what I get for trying to be responsive to my client's needs. >>> >>> So, a thousand thanks and more! >>> >>> Tom Ellison >>> >>> >> >> > >  |
|||||||||||||||||||||||
Other interesting topics