Comp.databases , Comp.databases.theory , Comp.databases.ms-sqlserver
Are there any tools to have the primary conversion of ISAM database
structure to SQL
Server [relational]?
Thanks.
- Kedar Agarkar
View Complete Forum Thread with Replies
Related Forum Messages:
2nd CFV: Comp.databases.etl
LAST CALL FOR VOTES (of 2)unmoderated group comp.databases.etlNewsgroups line:comp.databases.etl Extraction, transformation, loading issues.Votes must be received by 23:59:59 UTC, 12 Dec 2003.This vote is being conducted by a neutral third party. Questionsabout the proposed group should be directed to the proponent.Proponent: Cara Altman <caltman12@comcast.net>Votetaker: David E. Smith <dave@technopagan.org>RATIONALE: comp.databases.etlThis newsgroup will be for the discussion of topics relatedto ETL: the extraction, transfer, and loading of data from onedatabase to another database. ETL is a known acronym to people whowork with databases. It is used to represent the acquisition,integration used and mobility of data between systems andorganizations. This newsgroup will be a central source for ETLusenet users to go to when they face a difficult ETL challengeand wish to obtain independent feedback.This newsgroup will be useful to those involved in the complextask of implementing data warehousing, customer relationshipmanagement (CRM), business intelligence (BI) and other data-centric projects. The newsgroup comp.databases touch on ETLissues, but these messages are scattered. When searching forETL messages, postings were discovered in numerous newsgroups:comp.databasescomp.databases.ibm-db2comp.databases.sybasecomp.databases.oracle.toolscomp.databases.oracle.servercomp.databases.oracle.misccomp.databases.oracle.toolscomp.databases.oracle.servercomp.databases.olapcomp.infosystems.www.databasescomp.infosystems.intranetcomp.text.xmlcomp.infosystems.searchcomp.realtimecomp.databases.informixcomp.soft-sys.khoroscomp.sys.hp.mpemicrosoft.public.sqlserver.datawarehousemicrosoft.public.oledb.olapmicrosoft.public.oledb.olapThis is not a complete list. There were so many messages to pourthrough, and the end of the search list seemed very far away. Acommonly repeated question found was "Why use ETL tools?Which ones are good?"There are many complex issues surrounding the purchase ordevelopment of an ETL tool. Cost, schedule, and effectivenessare probably the most common. This forum will aid those who areweighing their options about whether to build or buy. It willgive users a place to express their opinions on what factors toconsider when implementing an ETL solution, and what ETL toolsbest suit specific ETL needs. Additionally, the ETL knowledgebasecan be expanded through the creation of its own forum.CHARTER: comp.databases.etlThis forum provides a place for people to discuss ETL (extraction,transformation, and loading) architectures. Participants cancorrespond regardless of the type of project on which they arefocused. Information can be exchanged on evaluations of COTS(Commercial Off The Shelf Software) ETL tools, as well as thescope of developing custom ETL solutions. The term ETL has anindustry track record of better than five years, and is commonlyknown in the RDBMS (relational database management system) market.This newsgroup provides an easy-to-find source for ETL users to gowhen they face a difficult ETL challenge and wish to obtainindependent feedback.Commercial postings are discouraged. However, ETL tool vendorsand solutions companies are welcome to add their opinions andto post answers or clarifications to discussions.Sample topics for discussion include:Data quality assessment/resolutionComplex transformation templatesLoad balancing/managementData mappingXML supportError managementTool evaluationCustom solutionsTechnology tips & tricksEND CHARTER.IMPORTANT VOTING PROCEDURE NOTES: READ THIS BEFORE VOTINGThe purpose of a Usenet vote is to determine the genuine interest inreading the proposed newsgroup, and soliciting votes from uninterestedparties defeats this purpose. Do *not* distribute this CFV; instead,direct people to the official CFV as posted to news.announce.newgroups.Distributing specific voting instructions or pre-marked copies ofthis CFV is considered vote fraud.This is a public vote: All email addresses, names and votes will belisted in the final RESULT post. The name used may be either a realname or an established Usenet handle.At most one vote is allowed per person or per account. Duplicatevotes will be resolved in favor of the most recent valid vote.Voters must mail their ballots directly to the votetaker. Anonymous,forwarded, or proxy votes are not valid, nor are votes mailed fromWWW/HTML/CGI forms (which should not exist). Votes from nonexistentaccounts or with munged, spam-blocked, or undeliverable addresses areinvalid and will NOT be counted. Votes sent from addresses with achallenge-response system in place will not be counted if the votetakerreceives a "challenge" message.Please direct any questions to the votetaker at <dave@technopagan.org>HOW TO VOTE:Extract the ballot from the CFV by deleting everything before and afterthe "BEGINNING OF BALLOT" and "END OF BALLOT" lines. Don't worry aboutthe spacing of the columns or any quote characters (">") that yourreply inserts. Please, DO NOT send the entire CFV back to me!Fill in the ballot as shown below. Please provide your real name(or established Usenet handle) and indicate your desired vote in theappropriate locations inside the ballot.Examples of how to properly indicate your vote:[ YES ] example.yes.vote[ NO ] example.no.vote[ ABSTAIN ] example.abstention[ CANCEL ] example.cancellationDO NOT modify, alter or delete any information in this ballot!If you do, the voting software will probably reject your ballot.When finished, MAIL the vote to <etlvote@technopagan.org>Just "replying" to this message should work, but check the "To:" line.Votes mailed to any other email address, including that of the votetaker,will NOT be counted.If you do not receive an acknowledgment of your vote within threedays contact the votetaker about the problem. You are responsiblefor reading your ack and making sure your vote is registered correctly.If these instructions are unclear, please consult the Introduction toUsenet Voting or the Usenet Voting FAQ at http://www.stanford.edu/~neilc/uvv.======== BEGINNING OF BALLOT: Delete everything before this line =======..-----------------------------------------------------------------------| 2ND CALL FOR VOTES: comp.databases.etl| Official Usenet Voting Ballot [ETL-42-2] (Do not remove this line!)|-----------------------------------------------------------------------| Please provide your real name, or your vote may be rejected. Established| Usenet handles are also acceptable. Place ONLY your name (ie. do NOT| include your e-mail address or any other information; ONLY your name)| after the colon on the following line:Voter Name:| Insert YES, NO, ABSTAIN, or CANCEL inside the brackets for each| newsgroup listed below (do not delete the newsgroup name):Your Vote Newsgroup--------- -----------------------------------------------------------[ ] comp.databases.etl======== END OF BALLOT: Delete everything after this line ==============DISTRIBUTION:This CFV will be posted to the following newsgroups:news.announce.newgroupsnews.groupscomp.databasescomp.databases.olapcomp.infosystems.www.databasesPointers to the CFV will be posted to the following newsgroups:comp.databases.ibm-db2comp.databases.sybasecomp.databases.oracle.misccomp.databases.oracle.toolscomp.databases.oracle.servercomp.databases.informixcomp.infosystems.intranetcomp.text.xmlcomp.infosystems.searchcomp.realtimecomp.soft-sys.khoroscomp.sys.hp.mpemicrosoft.public.sqlserver.datawarehousemicrosoft.public.oledb.olapmicrosoft.public.data.oledb.olapmicrosoft.public.sqlserver.olapmicrosoft.public.commerceserver.datawarehousing
View Replies !
Converting Comp To ASCII IN SQL
Hi I am importing data from mainframe using DTS the problem is that I am getting some COMP fields from the mainframe these are compressed data fields that are used to reduce storage space on the main frame. Can some one please help me understand how we can use DTS to solve this problem that is decompress it before transferring to table in SQL server. any code in scripting language to help decompress this datatype will be really appreciated. Thanks
View Replies !
HELP! Can Index Server 2.0 Be Used On SQL 7.0 With DB In 6.5 Comp. Mode?
We're developing an app that needs to use index server on a SQL 7.0 server. Unfortunately, we just found out that the dba's haven't completed the migration of the database from 6.5 to 7.0 and are therefore using compatibility mode. Does anyone know if it's possible to use Index Server on such a database? Many thanks in advance. If you're feeling REALLY motivated, I'd love an email response. Thanks. BTW, I've been searching MSDN and the net but haven't yet found an answer. Thanks. Spry
View Replies !
EBCDIC With Packed Decimal (Comp 3) To SQL
Hello, I'm trying to load en EBCDIC file with packed decimal in comp 3 into a SQL table. I have been searching information in this forum in several threads and have downloaded a DLL from http://www.microsoft.com/downloads/details.aspx?familyid=0e4bba52-cc52-4d89-8590-cda297ff7fbd&displaylang=en and so far I've been able to get the "UnpackDecimal Data Flow Transformation" to work ... sort of. The problem is that in the destination table the decimals appear allways as NULL. The destination decimal column type in the table is set as VARCHAR (I've tryed to set Integer with no success). Any help on this will be apreciated. If you need more information please ask. Thanks.
View Replies !
Database Mirroring In Comp. Mode 80
Hi Is it possible to use Database Mirroring when running a SQL Server 2005 database in compatibility mode 80 (SQL Server 2000)? If upgrading to SQL Server 2005 we would have to run Principal, Mirror and Witness in mode 80 to support our Transact-SQL Queries. To upgrade our Queries would be equally (or more) costly then to buy new SAN hardware for a cluster in wich case we might well continue running our 2000 cluster. (Buying hardware is slightly more time efficent then rewriting some 1500 queries) Please advise, thank you
View Replies !
How To Connect To Remote Sql Express From Client Comp/app??
Hi, I think this is a taff problem for me when I connect to remote sql express from .net application I use Connection String: Data Source=MYREMOTESVRSQLEXPRESS;Initial Catalog=microDB;Integrated Security=SSPI;Persist Security Info=True;User ID=micro;Password=micro OR Data Source=MYREMOTESVRSQLEXPRESS;Initial Catalog=microdb;Integrated Security=True;Persist Security Info=True;User ID=micro;Password=micro And found EROR message when running aplication from client comp/application "... Login failed foruser MYCOMPGuest... " How to setup a user in the sql expss server to support Client/Server Application? Anyone can help me? regards. md5
View Replies !
Office 2000 Comp. SQL-server 2005
Hi, Is it possible to make Pivottables in Office 2000(Frontpage or Excel) and get data from cubes in Analyses Services SQL server 2005? If it works, are there any problems or do I have full functionality? BR/Magnus
View Replies !
Sort Order/Char Set Comp. Between SQL7 SQL 2000
Im setting up a SQL 7 and SQL 2000 server on separate machines. The Character set I'm using on SQL 7 is ISO 8859-1(Latin-1) sort order 52 case insensitive, accent insensitive dictionary sort order. This is specified differently in SQL 2000 and I'd like to get the closest match to it. It appears instead of the default I need to choose the Collations options and I'm confused over the options. I see one which is Dictionary order, case insensitice, accent insensitive, 1252 Character set. Is this the best match and does the 1252 Char set match the 52 sort order in SQL7? Thanks for the help, Chris.
View Replies !
Synchronize Two Databases - Looking For Concepts And Theory
I'm struggling to find anywhere some recommended techniques for synchronizing two databases. I am writing a smart-client app that will have its own database, and then connect and synchronize with the server when available. Can somebody send me some links that discusses some of these ideas in detail? Thanks
View Replies !
Service Broker Not Working For Restored Databases (SQL 2000 Databases Restored On 2005)
I just restored my SQL server 2000 database on the SQL server 2005. after this i ran the Service broker sample ("Hello World") on this database by changing the AdventureWorks name to the new database name. The "setup.sql" runs fine. When i run the "SendMessage.sql" i was not getting any rows in the output (The message was not getting inserted into the queue). I checked the Service broker is enabled on this databased using the query "select is_broker_enabled from sys.databases where name = 'newdbname' " It was 1. I even tried the ALTER DATABASE SET ENABLE_BROKER. but it didnt work. When i tried the sample on a newly created database it worked fine. Is there any solution to make the restored database to work for service broker. Thanks Prashanth
View Replies !
Comparing Two SQLServer Databases
Hi, does anybody know a nice tool to automatically compare and showonly the structural differences between two databases, this is, thedifferences in the columns of a table, constrains, data type, etc.ThanksJ.A.
View Replies !
Size Of SQLServer Databases With Indices
Hello,I am starting to examine using SQLServer instead of Oracle. I wentthrough the SQLServer import utility to copy tables from Oracle intoSQLServer. I then checked the size of the database.I then started to specify indices for the tables. I did not see thedatabase file size grow all that much. I kept on using the shrinkcommand to make sure that wasted space was removed. I even made surethat minimal free space was allowed.I was rather expecting (from experience with Oracle) that there wouldbe a large growth in the database when addind indices. So what did Imiss? Are the indices stored elsewhere and I missed them? DoesSQLServer handle indices differently so they dont' bloat the databasesize?The size of our data in SQLServer is a key factor in whether we movefrom Oracle, so I need to under how indices effect storage size.Thanks for any help.Bart TorbertJoin Bytes!
View Replies !
Connection To Oracle / Sqlserver / Db2 Databases
Hi All, Is there a way in SSIS to change the database connection to sqlserver or oracle or db2 without choosing the connection manager in the source. For e.g. I ran a package which is reading data from sqlserver and later i want to connect to oracle to read the data but without changing the connection manager in the source. Basically, i want to find out from you gurus is about a way to switch between databases without changing the connection managers. OR the only way is to make different sets of packages for oracle / db2 and sqlserver sources ? Thanks, Vipul
View Replies !
Copying Databases Between Databases
hi from France !!! i would like how to duplicate a database to another server with all datas, constraints, keys, indexes... should i use sp_attach_db, dts, backup/restore, sql scripts... ??? thanks to all, nico
View Replies !
Two Databases?
Hi, I have my site set up, but have had difficulty using the data gathered by the aspnet.mdf. I wanted to use the email and username columns from the membership table to send newsletters automatically from the database(but that's a whole other post)I also have my own databse, which will be populated by information gathered from the website, so is currently empty. I'd like to take this opportunity to say that i don't think there's enough information given on how to populate a blank database from a website application. Most tuorials etc are concentrated on retrieving and displaying data, which is all well and good, once you actually have data to play with!I don't need two databases, so can I add tables to the aspnet.mdf ? But then what about relationships etc? I won't damage the current relationships by adding new ones? On the other hand can i copy the aspnet.mdf into my own database, and then assign the relevant permissions to that db? Any help would be greatly appreciated-in language for newbies please! I am relatively new to .asp.net/Visual Basic/ and SQL. It's a steep learning curve!Also....I have used create user wizard, login, password recovery etc within my site, the data is inserted into the correct db tables-without using an sql datasource for some reason...? is that right?I have also created a wizard to collect some more data (because i couldn't work out how to insert the data from the extra steps in create user wizard, into my own database) but when i click submit the data is not inserting into the specified table - (yes the connection string is fine, insert and update has been selected from the advance tab in connections wizard). Would this/could this be because i have assigned a 'finishbutton url'? should i use a Response.Redirect("blahblah.aspx") instead?
View Replies !
Two Databases
I have created a site which now has two databases. Firstly is the ASPNETDB.MDF which I beleives get set to manage the security, logon/Roles that I have on my site. The second dataabase "MyDatabase" is one that I have created for all my data withing the site. I would like to combine this to one Database for simplicity and cost. Now I can't see the ASPNETDB.MDF when I use SQL Manager 2005 and I can't see how to change the set up of ASP.Net Configuration if I was to just use mydatabase. Any suggestions
View Replies !
Databases
I am very new to asp.net, but am having trouble trying to link the asp.net page that i have created to an sql database that has been set up on a local system. Am actually trying to use the sql control to extract info from the database. Would appreciate any ideas.
View Replies !
Databases
i really want to know,there are how types of databases?how many types of servers?how many types of inernet based languages?
View Replies !
Looking For SQL Databases For
Hello,I am currently looking for databases that contain available prescriptionmedications and diagnosis codes (i.e. ICD9 medical diagnosis codes) thathave been created using SQL.Anybody know of companies that have these commerically available?Thanks,Eric
View Replies !
2 Databases
How can you make two databases communicate with each other?? they both reside in sql server 2000. How would I go about doing that. Access 2000 is the interface
View Replies !
SQL 2K Ent 32 Bit Databases To 2K5 64 Bit Std
Hey guys. We are going to be upgrading server soon and my doing a little research to find out if their any thing to watch out for or things to know about when upgrading 2000 ent 32 bit "DATA" to 2K5 std 64 bit evironment appart from the OS and Hardware. And also the best method to move the data will restoring from 2000 to 2K5 64 bit cause a issues. thanks in advance.
View Replies !
From 6.5 Databases To 7.0
Hello, Is it possible to restore a 6.5 database to a 7.0? I backup the entire 6.5 database to a BAK file then tried to restore it to SQL 7.0 but it didn't work. SQL 7.0 states that the disk device is not a valid Microsoft Tape Format backup set. We have an application that was developped long long time ago by a old team and I don't want to upgrade the server. I tried to build a second 6.5 server (new hardware) but I couldn't restore the database as SQL 6.5 states that the server is in single user mode. I don't know how to switch to multi users mode. The database I want to restore is not in DBO or single user mode. Any help will be appreciated. Thanks. Toan.
View Replies !
Max. # Of Databases In SQL 7
I am presenting using MS SQL 6.5 and have used up all my (VDEVNO) device numbers (1-255). Will I have this problem when I migrate to SQL 7? I understand SQL 7 does not use a device when creating databases, so what is the maximum number of databases I can create in SQL 7? Thanks in advance.
View Replies !
CD-R Databases
We use CD-Rs to store our archive SQL Server 7 (SP2) data. Archive databases are created using sp_create_removable and sp_certify_removable stored procedures. They are detached from original server with sp_detach_db stored procedure, and then attached to the archive server with sp_attach_db stored procedure. Executing select statements from that kind of databases we noticed that we can select only 5KB of data at once. With next select we can select previous 5KB of data, plus 5KB of new data, and so on. Question would be: where does this selection limit come from (is there some server or database option that we should adjust), how can we owerride it, and be able to select more than 5KB at once? TIA, S & M
View Replies !
Use 1 Or 2 Databases?
Hello, I’m using VB6 as the client and MS SQL Server 7 as the database. The company I’m consulting for has a proven track record for marketing and getting millions of customers. The parent company would like to create two new companies selling the same product; with 1 million customers per company. How many records can MS SQL Server 7 handle? I’ve been told it can handle 4 terabytes. What does 4 terabytes translate into records? I have already set up an application for company #1. Should I put company #2 in the same MS SQL Server database? Or should I put company #2 in a different database? My VB Application and SQL Server database were designed to handle multiple companies selling the same product. For performance sake; would it be better to separate the databases? Any suggestions? Is anyone currently using MS SQL Server with 2 or more million records? Thanks, Denise
View Replies !
Two Databases
Dear friends, I have two databses in one MS SQL SERVER. I have to manipulate data from one database to another. In other words, I have to create the view or store procedure referecce the tables of other database. How ? Thanks best regards manoj
View Replies !
Two Databases
Dear friends, There are two databases in SQL Server and I have to designed the view or store procedure joing tables from two databases. How ? It will be kind, if you give me answer with detail example. Best regards! manoj
View Replies !
Two Sql Databases...
Geography is a problem with our current enterprise application. writes to the central database are causing delays for clients on the coast. we are exploring msdts. comments? I'm investigating MSDTC and how our application will handle writing to two databases simultaneously, one located on the west coast, and another on the east coast. how fesible is this? how does sql 7 handle latency when distribution transaction servers are in the mix. i'd like to have our application write to two separate sql 7 databases simultaneously. replication will work, but there is a delay in data always being written to the second database. thoughts? thanks,
View Replies !
SQL Databases From A CD
Gusy im currently making and app that runs from a cd rom yet it uses databases made in sql and i already made the part for ataching the database from the cd but i haven't been able to do 2 things: 1. Can i actually attach my database from a cd without any need for the computer 2. does anyone has the code for detaching a database in Sql in c# thanks ahead
View Replies !
Use CLR UDT Across Databases
I have assembly with several UDT. Let's call one of them - T. I have loaded assembly to 2 different databases. Let€™s call them €“ d1 and d2. I also have function F(), that returns type T. I want to run such statement: use d2 declare @v t = d1.dbo.F(); If type T in d2 lies in schema dbo, then such statement will work without any problems. But if I want to register T not in dbo, but in some other schema (let€™s call it S), I will have an error: Msg 206, Level 16, State 2, Line 1 Operand type clash: sysdb.ssma_oracle.Record is incompatible with t1.ssma_oracle.Record Only conditions for CLR UDT, that I found, were: When you use user-defined types across databases, you should remember the following: · The types must have the same name, including the same CLR name, and must be implemented through the same assembly in both databases. Assemblies in two databases are identical if they have the same name, strong name, culture, version, code access permission set, and binary contents. · You must have SELECT and EXECUTE permissions on each user-defined type column referenced in the query. These permissions are checked with regard to the database in which each column is defined. · If a type that is implemented in one assembly calls a method in another assembly, the cross-assembly call is checked in the same way as if the user-defined type query were issued without crossing databases. But I still have the same error. Why?
View Replies !
Using Two Databases Vs. One?
I'm writing an app in vs2005 using sql express. This may be the wrong forum for this question, but here it is. I'm going to have several tables: Seven for Customer information, six for Employee information, 15 for Misc Definitions (status types, skill types, discipline types, gender types, etc.) and 10 for Scheduling information. This is a total of 38 tables. Is there any advantage to having four databases, one for each type, or should I put all 38 tables in one database and add relationships to everything?
View Replies !
Example Databases
Hello Everyone: I am testing SQL Sever Express and I would like to know how to load the adventure works databaes into SQL server? I have downloaded the files in accordance to the instructions providered however, when I open SQL Server the Adventure Works database does not appear. How do I add the adventure works database to my instance of SQL Server? It appears that the files downloaded correclty and teh setup executed correclty, and the database files can be found in my control panel. Thanks John
View Replies !
100 Databases
Hello, Can someone show me the TSQL I need to write in order to create 100 SQL databases in one go. I want them to be called DB1, DB2, DB3, DB4...etc etc I know how to create one database; --------------------------------------------------- USE MASTER GO CREATE DATABASE DB1 ON PRIMARY ( NAME = DB1_dat, FILENAME = 'C:Program FilesMicrosoft SQL ServerMSSQLDataDB1.mdf', SIZE=4, MAXSIZE=10, FILEGROWTH=1 ) ------------------------- But I don't want to do this 100 times, Thanks in advance ICW
View Replies !
Relational Databases
I have a membership database and a profile database with a userid column in both. The foreign key is in the profile database where i want a persons profile details to go like location,occupation and what not. How do I make it so when a new user registers a userId is created in the profile database that matched the userid in the membership database so i can query out profile details based on a registered members userid?
View Replies !
Data From Two Databases
Hi All, We currently got two databases in the application(Visual web express with vb script). The one database is a sql 2000 that sits on a server and is fed by people that does E Learning. The app. got its own database(SQL 2005 express) with the record of the people doing the learning and some other attendances from other courses. I would like to determine attendances from both databases etc. How do I link this to table form diffrent databases into one table for me to do training cost etc. Thanks for your help.
View Replies !
Getting Rid Of Sql Express Databases
This issue is just irritating: hope someone can help.... I recently deleted a whole lot of test websites on my laptop by physically deleting the folders. Each had their own SQL Express database. The database instances still show up in SQL Server Management Studio, although the databases have been removed. I can't drop the datababases with the GUI as it says they're not accessible (that would be right), and manually using the DROP DATABASE command tells me that the physical file can't be found (also correct).Is there a "proper" way to get rid of them without directly manipulating the system tables?
View Replies !
How Can I Connect To Two Databases?
hello, i want to make a relation betwen one of my tables and the user tables (to take it's unique ID), if there isn't any methode to do that without using the two databases(ASPNETDB - automaticly created when a user registers, and MyData), how can i connect to both databases? here is my connection string, but what should i do?<connectionStrings> <add name="SiteConnection" connectionString="Server=(local)SqlExpress; Integrated Security = True; Database = MyData" providerName="System.Data.SqlClient" /> <add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|MyData.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings> thank you
View Replies !
Combine 3 Databases
Combine 3 Databases, Not tables. Let me spell this out -- I have 3 databases (they are in isolation when in use, its a field app) that need to be merged into 1 "masterDB" database. I've discovered I can use something like this to get to each DB in a query... 1 USE [database1]2 SELECT table1.Name, table1.Location, table1.Date, table2.Blog3 FROM table2 INNER JOIN4 table1 ON table2.ID = table1.ID5 ORDER BY table1.Date and then just repeat for database2 and database3. Ok, fine, rah rah. My question is how do I "merge" all of these into 1. No data on each db will be identical, at all, ever so that is not a concern. I just need all the data from db1, 2 and 3 into masterDB. Ideas? Direction?
View Replies !
Combining Databases
Dear Developres, Actually I'm on the half way of making a portal and I get some problem I need your kindly helps. at first I use the membership feature of ASP.net 2.0 to have login and all so by default it has generate an ASPNETDB.MDF file which its is (Microsoft SQL Server Database File (SqlClient)) and also I have two more databases one for file managemnet and one for Calander and Contacts but I need all to be one so whenevr one user can login it can show his own file in his page but now everyone can see all,Can anybody guide me should it all be in one database and if yes how can I connect all since one is generated by default by Visual studio2005.Should I use a Microsoft SQL Server (SqlClient)??? Thanks in advance.
View Replies !
Query Around Databases
I need to query tables on different databases, which all reside on the same database server. How to do this?is it db1.tablex inner join db2.tabley ?
View Replies !
Read Only SQL Databases On NAS
I must have poseted this question in the wrong section last time, no one replied. Here's my question: I have novice MS SQL skill and was wondering about SQL and NAS configurations. I've read plently of places that hosting a database on NAS device is not the best thing to do. But, what if the databases were just read only; no data would ever be written to them. They would only server static content. Is that a safe configuration? - Kevin
View Replies !
Read Only Databases
ok when i upload my databases that i created in VS2005, they are read only. so i though something was just funny, so i installed sql managment studio on the server and attached the databases, and when i attached them there grey with (READ-ONLY) displayed... how can i get my DB's out of read only! i tryied going through the properties of the DB through MSSQL managenet studio but that only generates an error... any ideas!
View Replies !
Transferring Databases
Hi I created some databases on my pc at work (using Visual Web Developer 2005 and Microsoft SQL Server Express), I now wish to move them onto my home machine, Can I do this by simply copying the .MDF files and then moving them into the App_Data folder of my new app? Do MDF files contain everything (schema, data, stored procedures etc) or am I missing something? Cheers, Adam
View Replies !
Scheduling With SQL Databases.
I know enough about Databases to get myself in trouple. So maybe someone can point me in the right direction, or help me out. I work for the American Red Cross in Provo UT. We want to be able to put class registration on line so that someone can visit our website chose the class they want to take, register and pay for it all on-line. Our website http://www.redcrossut.org is hosted with godaddy and I am able to post a SQL Database. I know that our website as it stands is very poor. The people who have maintained it in the past have no idea what they were doing, my job is not the website, I am over Health & Safety Training, but have done some work with websites for fun in the past. I know a little about Visual Studio and plan to rebuild the site using C#. I can build a basic Database and interface to it with Visual Studio, Godaddy can help me with the payment part, but I have no idea how to set up SQL to allow scheduling. Any help would be appreciated. Even if it’s just a link to a tutorial. Ed Hall Director Health & Safety Services Mountain Valley Chapter American Red Cross
View Replies !
|
TRACKER
