|
Hi,
We are migrating from MS Access to SqlServer 2005. Could anyone please let me know how to copy tables and other objects (Stored procedures, triggers) from our current Access Database to SqlServer 2005.
Thanks & Regards
Puneet
|
|
|
|
|
This is how it is being done in sql server 2000.first from enterprise manager right click on the database.
2)choose new database and create a new database with the name of your sql server database.
3)Right click on the new database created and from tasks choose import data.
4)A dialog box will appear.you have to specify the datasource there,which is microsoft access in your case.Then just follow the instructions and you will get your database migrated.
|
|
|
|
|
hi
i want 2 update this record
EMP_ID SHIFT DEPT OVERTIME TIME_DATE
1 General IT 6 19-AUG-09
when i update this record then overtime add in 6 means i add 2 so overtime is 8.
how can i do this???
thanks in advance.
|
|
|
|
|
General form: update TABLENAME set FIELDNAME = VALUE where WHERECLAUSE
eg:
update tblEmployeeOvertime set Overtime = Overtime + 2 where Emp_ID = 1
|
|
|
|
|
how to send captured WireShark packets to sql database
|
|
|
|
|
Like this:
1. Parse the information.
2. Split the information into bite-sized pieces that match your table structure.
3. Use SQL (or a Stored Procedure) to insert the information.
4. Repeat until you have no packets left to process.
|
|
|
|
|
so i saved the packets to a excel file. from here i want to write a code that would let me read from that file and send that data to the database but am having problems writing that code to do this .., do you have any reading material on how this can be done
|
|
|
|
|
Last night I wanted to copy an Access 2007 .mdb file and the thing was 618 MB !  I know that there is no way there could be that much data, so I did a compact & repair and the size went down to 6 MB.
The other interesting thing about this .mdb is that there is actually no user data stored in it. It contains just the forms, queries, reports, modules. It references the data tables stored in a separate .mdb via linked tables.
What could have caused this to grow to such a large size ? I never had this problem with Access 2003.
I really can't stand any of the Office 2007 products. 
|
|
|
|
|
Why is it so? Because Access doesn't do garbage collection or cleanup particularly well.
Usually, your file will swell rapidly if you are creating temp tables through code or make-table queries.
Since you say it's your front end, one way to combat this issue is to have it compact and repair on exit.
|
|
|
|
|
This problem has been around for ages - I remember having a compact method in access 97, the user could check the size via a form and would decide when to compact the database.
This is one of the (minor) reasons to move to a decant database platform.
|
|
|
|
|
Mycroft Holmes wrote: decant database platform
Is that one that you pour from a bottle? rofl...
|
|
|
|
|
I build application in vb.net 2005. Now i want to deploy it through setup (build through setup and deployment project in vb.net),
I want to install sql server2005 express with my setup but this installation must be unattended (silent)
if anyone know, please help me and tell me the complete steps.
thanks
|
|
|
|
|
I just took an online evaluation of my SQL skills (SQL-FU?).
How would you answer this question:
"
Given the following SQL statement:
SELECT customers.customerid, currentbalance
FROM customers
LEFT OUTER JOIN customer_balance ON customers.customerid =
customer_balance.currentbalance
Which of the following statements correctly describe the result set?
A. Only customerid values with a matching value in the customer_balance table will be displayed in the result set.
B. All currentbalance columns from the customer_balance table will be displayed in the result set. Customerid values will be displayed for each customerid with a matching value in the customers table. Null will be displayed as the value for currentbalance for all customerids with no match in the customer_balance table.
C. All currentbalance columns from the customer_balance table will be displayed in the result set. Customerid values will be displayed for each customerid with a matching value in the customers table. A customerid value of null will be displayed for each customerid without a matching value in the customers table.
D. All customerid columns from the customer_balance table will be displayed in the result set. Current balance values will be displayed for each customerid with a matching customerid value in the customer_balance table. Zero will be displayed as the value for current balance for all customerids with no match in the customer_balance table.
E. All customerid columns from the customers table will be displayed in the result set. Current balance values will be displayed for each customerid with a matching customerid value in the customer_balance table. Null will be displayed as the value for current balance for all customerids with no match in the customer_balance table.
"
I decided that customers.customerid = customer_balance.currentbalance was a typo and chose E.
Ah, well, at least I got 83rd percentile. 
|
|
|
|
|
Assuming that it was a typo (which it must be since there was no option for "this is crap and if I can't pick this error up I shouldn't be using SQL"), then answer E is correct.
|
|
|
|
|
hi
read my this query
insert into attandance values('18-AUG-2009','General','1','IT',(to_date('10:32:00 AM',hh:mi:ss
tt'),(to_date('10:32:00 AM','hh:mi:ss tt)),'jawad kahtri');
when i use this show error
error is
Bind variable "32" not declared.
thanks in advance.
jawad khatri
|
|
|
|
|
If nothing else you are missing some single quotes, one between AM', and hh:mi:ss
the other between ss tt and ))
This fixes those two errors for you:
insert into attandance values('18-AUG-2009','General','1','IT',(to_date('10:32:00 AM','hh:mi:ss tt'),(to_date('10:32:00 AM','hh:mi:ss tt')),'jawad kahtri');
Whether there is anything else wrong time will tell, but it had no chance of working without those quotes!
|
|
|
|
|
thanks sir
but when i insert this show error
ERROR at line 1:
ORA-00907: missing right parenthesis
Name Null? Type
------------------------------- -------- ----
ATT_DATE NOT NULL DATE
SHIFT NOT NULL VARCHAR2(8)
EMP_ID NOT NULL NUMBER
DEP_ID VARCHAR2(20)
TIMEIN DATE
TIMEOUT DATE
EMP_NAME VARCHAR2(20)
this is my table iwant to insert time in time in or time out.
please help me.
thanks
|
|
|
|
|
Well, it's missing a right parenthesis - ie: )
insert into attandance values('18-AUG-2009','General','1','IT',
(to_date('10:32:00 AM','hh:mi:ss tt'), <----------- MISSING FROM HERE
(to_date('10:32:00 AM','hh:mi:ss tt')),
'jawad kahtri');
If you break it down like this, you can clearly see that the missing parenthesis is on the first to_date - compare it to the one below it!
|
|
|
|
|
sir now i write this query
insert into attandance values
(to_date('18-AUG-2009','DD-MON-YYYY')),
'General',
'1',
'IT',
(to_date('10:32:00 AM','hh:mi:ss AM')),
(to_date('10:32:00 AM','hh:mi:ss AM')),
'jawad kahtri');
show error in line 2
ERROR at line 2:
ORA-00933: SQL command not properly ended
what is means ???
|
|
|
|
|
The general form of this type of insert is this:
insert into TABLE (field list) values (value list)
You are now missing an opening parenthesis for the value list. Since you aren't specifying a field list, your list of values must have one for every field in the table, in the correct order.
insert into attandance values ( <----------------- ADDED PARENTHESIS HERE
(to_date('18-AUG-2009','DD-MON-YYYY')),
'General',
'1',
'IT',
(to_date('10:32:00 AM','hh:mi:ss AM')),
(to_date('10:32:00 AM','hh:mi:ss AM')),
'jawad kahtri'
);
|
|
|
|
|
|
I do suggest you get a book on PLSQL if you are going to continue to use Oracle (or any sql database). The problems you faced are straight observational details, you missed single quotes and brackets, this is probably from lack of practice so working through a bunch of examples will give you both practice and knowledge in SQL syntax.
|
|
|
|
|
_Damian S_ wrote: Whether there is anything else wrong time will tell
"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering
|
|
|
|
|
Dear All,
Could you please tell me about the Database backup in Sql Server 2005 that was selected "Append to the Existing backup set" in the "Backup to Existing Media set".Please tell me if i restore the Backup file database would have duplicates datas or it will remove the duplicates automatically?
hope your help as earlier.
|
|
|
|
|
Create a simple database, add a few rows, then test each variation to see what happens. Then you can write an article explaining it to us.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
