Trying to transfer databases from MSDE to SQL. When I use SQL
Enterprise Manager - DTS - import or export, it works for the first
database, but then fails for the others. I select the to and from
databases using DTS - Import - 'MS OLE DB Provider for SQL Server',
then select 'Copy objects and data between SQL Servers'. It fails
with the generic error message: 'Copy objects failed', nothing
further. I tried to just copy data, and it doesn't work totally. On
two databases, it said that it copied everything, but when I go in
under Enterprise manager, some of the tables are incomplete, i.e. no
data, table shows up in the list, but if you try to look at it, it
says that it is missing or empty. Also, one table was not even
copied. In the other two cases, I get errors, does not copy all
tables. I get errors, like insert fails, but the column it references
for the table does not even exist in that table. Any suggestions
would be appreciated.
Hi all,Here is my situation.I have an application that uses SQL 2000. The client has a programthat uses MSDE. The client MUST have the MSDE version of the Database.What I have done is to create a SQL 2000 Database that is exactly likethe MSDE version. What I wish to do, is at regularly scheduledintervals, update the SQL 2000 Data with the newest MSDE Data.On my clients server, they have both MSDE and SQL 2000 installedthe msde has a user name and password to access it, whereas the SQL2000 uses authenticated mode to access it.What I'm trying to do is to write a bunch of SQL Queries, that I canrun that will copy over the new Data, but I'm having problems accessingthe msde database in query analyzer from the SQL DatabaseCan anyone give me hints on the best way to try thisThanksScott
Am very new to MS SQL adminstration Can anybody help me out how to work on Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A just for the practice.
The activity which am going to workout on MSDE is below.
How to install SQL(on XP) How the layout will be(like if i insall MSDE what are all Application will be and how they depends on each other) How to create/delete tables if so, how can we do it either by GUI or CUI
Will any application developed against SQL Server 2000 Developer Edition work on an identical platform with only MSDE 2000 installed? I understand there's a concurrency limit with MSDE 2000 of around 25 (and there's no GUI) but apart from that, are there any aspects of SQL Server 2000 functionality (from the .NET applicaiton code's point of view) that are "disabled" in MSDE 2000?
I am creating an install program and I'm wondering if there is a difference between SQL Server 2000 and MSDE 2000? Do they have different entries in the Registry?
From the documentation that I've read it seems as if they are one and the same.
However, if someone knows how to differentiate between them in the Registry it would be greatly appreciated.
HiI am a novice with SQL server as i have experience with access. I needto do some front end development in access for a client who runs SQL6.5 or so he tells me... (i have been told that data files under 6.5are .dat and under 7.0 they are .mdf? is this correct?)I have taken a copy of the data file which is an mdf file with theintention of running it on my machine which has SQL 2000 Developer Edinstalled on windows XP pro.I cannot attach the database as i do not have the log files, i cannotuse DTS as the database is not registered with sql server.do i need to get a copy of the log .ldf files before i can progress?Is there any other files i need?
I have to merge the data from two databases, one is in SQL Server 2005 format, one is in 2000. The merged data will then reside on a SQL Server 2000 platform. Is there an easy way to do this through Management Studio or Enterprise Manager? Or will we have to export the data from the 2005 database to a flat file and import it into a new 2000 database. And then do the merge?
I am having immense difficulties trying to transfer tables, sprocs, udfs, etc, from a production SqlServer2000 server to a testing SqlServer2005 server.
Under SS2000 this was easy, using the DTS wizard. Apparently that's no longer an option.
I've tried the Transfer Database, Transfer Sql Server Objects tasks and the wizard in BIDS, and they all fail (for different reasons).
Help!!!!
- Mark
p.s. -- As a side question, why in the world did you guys get rid of the one workhorse tool in Enterprise Manager that made synchronizing databases easy?
I am about to setup an application server. This app will generate reports and instead of just having a HTML page up, I am considering running dotnetnuke type portal to offer the userbase a better interface for the reports, info, announcement, etc.
Server isn't too bad (2x1.7Ghz Xeon I think, 2GIG RAM) type of setup (may be little more or less). App doesn't require as much resources, but we are planning for the future )
While I have some resource to play with, I also need to make sure I don't load much that may impact the application performance. In my experience, SQL Server 2000 will take a lot of resources even when not used as much. So I am considering MSDE.
I am curious however, WHAT ARE THE MAIN DIFFERENCES BETWEEN SQL 2000 Server Vs MSDE 2000 ?
Beside no Client tool and mostly command line specific command, what else there to convince that I should go for server vs desktop engine?
Now our company has Enterprise license for SQL, so I am not worried about the cost (well a little maybe), but mostly wondering about performance.
If you think of any reason why I go to SQL Server 2000 over MSDE, please let me. Otherwise, I think MSDE in this case is the appropriate RDBMS to go for.
Hi All, I've got a problem transferring objects between SQL Databases. The source database is an SQL 2000 dbase, and the destination is a local SQL2005 instance. When trying to transfer I get the error: 0x80040E37 (table) does not exist at the source - but it does.
I am guessing its a schema related issue, I've tried setting the copyschema setting to true, but no joy. The copyallschemas function doesn't work with an SQL 2000 box so its set to false.
I just used the SSIS Import and Export Wizard to copy 50+ tables from SS05 to SS2K.
I found that the wizard created a package that I could not figure out how to edit, e.g., to change whether or not it had to CREATE a table, or just use an existing one. (I created some problems by manually editing the receiving table names to be ones that already existed -- but the original names it had did not exist, so it knew it had to create them. What I should have done, and eventually ended up doing, was scroll through my list of tables in the "receiving" box; I just figured editing the name would be faster, not realizing what problems I would create for myself.)
Anyhow, now that I see the complex package that the wizard creates, with a LOOP over the 50+ tables, I would like to know how/where in the package it is storing the information about the tables to copy.
Basically the wizard creates the following Control Flow tab entries (in processing sequence order):
an Execute SQL Task: NonTransactableSql an Execute SQL Task: START TRANSACTION a Sequence Container: Transaction Scoping Sequence, which contains an Execute SQL Task: AllowedToFailPrologueSql an Execute SQL Task: PrologueSql a Foreach Loop Container, which contains a Transfer Task with an icon I did not notice in the Toolbox an Execute Package Task: Execute Inner Package an Execute SQL Task: EpilogueSql an "on success" arrow to an Execute SQL Task: COMMIT TRANSACTION an Execute SQL Task: PostTransaction Sql an "on failure" arrow to an Execute SQL Task: ROLLBACK TRANSACTION an Execute SQL Task: CompensatingSql
Where, and how, can I look within this package to see the details about the tables I am transferring? I see that one of the Connection Managers is "TableSchema.XML" -- but it points to a temporary file on my hard drive, that I presume is populated by the package. Where does it get its information?
This is certainly much more complex than the package I would have written, based on my limited knowledge of SSIS. I would have been inclined to create 50+ Data Flow tasks, one for each table.
So now I'm trying to understand why the Wizard created this more-complex package.
Any help will be appreciated, including references to non-Microsoft books/websites/etc.
Hello all, im new here and do not have no experience with sql. I am trying to install a tax software that I need to run my little business. When I install it gets to a popint that it asks me for my SQL server usernme and password. I remember doing this last year and I reinstalled MSDE and set up a username and password. I seem to not remember what I used, i tried all that I would have but can not get past that step. I remember adding some lines in the setup,ini file when I installed it last year. Now I can go ahead and reinstall it again and set up a new one, but will the uninstalling and reinstalling of MSDE affect my previous software from last year? Its the same software but I need this years installed. I have tried using sa as the username and a blank password, with a password and others that I have read up on, still cant log on. Keep getting worng credential screen. Is there a way to get that info, i doubt it or else it would not be secure, or can I just simply reinstall MSDE?
I'm trying to install this application but i get an errorSetup failed to configure the server. Refer to the server error logs and setup error logs for more information.I'm running Windows XP SP2.Could my SP2 be causing me problems considering I successfully installed it previously.Many thanks
I am not sure if this is the right forum, I already had some one freakout on me in another forum about posting in the wrong place.
Anyway: I would like to upgrade a machine from SQL 7 to MSDE 2000. I would like to keep the existing database from Altiris Deployment solutions intact. Is this upgrade possible?
This is my first time using SQL. I installed MSDE 2000 on my desktop and after restarting my PC I see an icon in the startup area MSSQLServer with the server being my T-Tag #.
I am trying to upsize my Access DB to Sqlserver. I am still confused as to where does this server reside? How does this whole thing work?
Also, when I tried to upsize my db I got an overflow error.
I have a client that has a server running Windows 2000 Server. anothercompany has installed MSDE (version unknown) on this server. I need toinstall SQL 2000 on the same server. Will the two coexist peacefully?TiaCruznOz*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
I only have Framework installed on my machine, and I also installed MSDE 2000 Rel. A, using the following command: C:MSDERelAsetup.exe SAPWD="myPass" INSTANCENAME="myXP"
I can see that the service for this app is running. Though, I could not connect to it using oSql command like the following: osql -S(local)myXP -E or osql -S(local)myXP -Usa, and supply the password "myPass".
The message was: [DBMSLPCN]SQL Server does not exist or access denied. [DBMSLPCN]ConnectionOpen (Connect()).
I installed MSDE2000 and i have problem: In SQL Server Service manager i do not see connection but in MS Visual Studio .NET i see the connection and i can make tables my setup string was: C:MSDERelAsetup SAPWD="Vedran" instancename="VT"
I have a customer with Office 2000 and uses Access 2000. I normally use SQL/7, but for this job would it be save to use MSDE on the web site so the customer can upload and download the MSDE file for product information? I use SQL/7 for the backend. Please advise.
Hi all,I just got SQL Server 2000, but I already have MSDE installed. Is there anyreason I would want to keep MSDE around on my computer if I install SQLServer 2000? I use MS Visual Studio 2002 on Windows XP SP2, in case itmakes any difference. I intend to deinstall MSDE before installing SQLServer 2000, but I get the impression from a few posts that some people haveboth installed and I'm not sure why that would be done. What functionalityis in MSDE that is not in SQL Server 2000?Thanks for answering.--Diana
HiWe have just migrated to SQL 2005 database.We backup up our SQL database to disk, then backup files to tape usingBckupExec 10.1.The only snag is that BackupExec uses MSDE2000 to manage jobs etc soit will want to install a MSDE2000 on the server that has SQL 2005 onit !!Backupexec Support tell me that it will be fine to have two version ofSQL install on the server, is that the case?Naturally, I am concerned about DLL conflicts and breaking my SQL 2005serverCan any one shed any light on this?ThanksRC
I was wondering if any of you guys can kindly help me in finding allthe different versions of MSDE 2000 that came out since it's firstrelease. I expected to find something similar like Sun's archive(http://java.sun.com/products/archive/index.html) for MSDE 2000 toobut failed to find after a few hours of browsing at the MicrosoftDownload Center (http://www.microsoft.com/downloads/...displaylang=en).They seem more into promoting their new MSDE 2000 Release A for thetime being but nothing much about the previous versions of MSDE toserve my product testing purposes.All I need is a complete list of different versions of MSDE 2000 withdownloadable links.Thanks in advance.IzzY
Hi everyone,In using the SQL Server Database Wizard in Access 2000 to create a newaccess project, I get two consecutive error messages and then the wizardshuts down. The first, which apprears immediately after starting the wizardis a message box stating something like "the property value is too large".After clicking through and filling out the values in the connection anddatabase dialog, I get a second dialog box with the message "Overflow" andthe wizard terminates.My operating system is Windows 2000 Professional with Access 2000 and MSDE2000.Does anyone have any thoughts about what might be causing these errors?Thanks in advance.
