|
one option is use DTS, get db to local instance. which would be faster.
(if is a offline transaction)
for accessing a different instance need to link using sp_addserver / sp_addlinkedserver
Regards
KP
|
|
|
|
|
I want to use Data Access Application Block for accessing my MS Access database.
Is it possible with out making changes in Enterprise Library 2.0?
M.Sendilkumar
|
|
|
|
|
Yes that is what it is designed for.
Use the configurator to attach to the backend Access db then try and run some code againist it.
You might be better of with SQL express 2005 if your target server can handle it.
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)
http:\\www.frankkerrigan.com
|
|
|
|
|
Can you tell me what exactly I need to do?
M.Sendilkumar
|
|
|
|
|
Does exist a command (like insert) to copy all records from a table to other with a condition? Let's assume than both have axactly record configuration... thanks
|
|
|
|
|
INSERT INTO DestinationTable<br />
SELECT Columns<br />
FROM SourceTable<br />
WHERE condition = whatever
|
|
|
|
|
select * from tableA
insert tableB
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)
http:\\www.frankkerrigan.com
|
|
|
|
|
Hey guys.
I was wondering if it is possible to join two tables from different databases together.
Here is what I want to do:
TableAdapter1 would get data from file AccessDB1, from Table1.
TableAdapter2 would get data from file AccessDB2, from Table2.
Once this is done, I want to join/merge/connect the two tables together in a new DataTable in memory and be able to query this new table.
An example of what I want to do is this:
I have two Access files. The first contains Table1 that has a date column and a value column. The second Access file contains Table2 that has a date column and an exchange rate column.
What I want to do is to produce a new table in memory (i.e. Datatable) that will contain a date column, a value column, and exchange rate column, AND a new column ExchangedValue that will contain the results of value column * exchange rate column.
Can this be done? The concern here is the fact that the two tables where taken from different database files.
Thanks and regards..
The perfect code is always in your head...it just a matter of how hard you bang your head against the wall to get it out!
|
|
|
|
|
you can do this in SQL Server, even on differet db servers if you setup a linked server.
select * from
salesdb.dbo.customers inner join customer.dbo.customer
on salesdb.dbo.customers.id inner join customer.dbo.customers.id
Hope this helps
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)
http:\\www.frankkerrigan.com
|
|
|
|
|
how to create sql database wit userdefined name at run time.
please help
thanx
taher
|
|
|
|
|
taherjaorawala wrote: how to create sql database wit userdefined name at run time
Like anything else - you issue a SQL command, in this case to CREATE DATABASE.
|
|
|
|
|
I am using vb.net as front end I want to make database at runtime and name the database whatever user wants
plase help
|
|
|
|
|
create connection object
create command object
execute sql statement "CREATE DATABASE ...."
Regards
KP
|
|
|
|
|
taherjaorawala wrote: I am using vb.net as front end I want to make database at runtime and name the database whatever user wants
I explained this to you in your cross posted message in the VB.NET forum here[^]
|
|
|
|
|
I have database present in one m/c sql server and i have taken backup of the database.
I want to restore the backup file into another m/c which has sql server
how to go about
Pls help me..
regards
chandru
|
|
|
|
|
i forgot to say i am using sql server 2000
|
|
|
|
|
take database offline from the frist machine. copy MDF & LDF files to other machine and attach them (right click on database node select AllTasks->Attach from SQL enterprise manager)
OR
create a new database with same name in another m/c and restore the backup taken from the first m/c
Regards
KP
|
|
|
|
|
thank you
i will try the same
chandru
|
|
|
|
|
hi
i have taken backup from orginal pc, and created new database in another m/c
but if i try to take backup from the backup file it will not shown in that form. How to go about
please guide me about this.
regards
chandru
|
|
|
|
|
your query is not clear. can pls explain
Regards
KP
|
|
|
|
|
hi kirsh
thank you for your reply
my problem is in the second m/c when i try to restore the database, it lists only backups that are taken on that second m/c.
i was unable to get backuped file which is copied from the first m/c for restore command
hope you under stood
sorry for inconvenience
regards
chandru
|
|
|
|
|
from SQL Enterprise Manager select the database right click
1. select "All tasks"
2. select "restore database"
3. From the "General" tab ...
4. select "FromDevice" option
5. click on "SelectDevices..." to borwse and select the backup
6. go to "Options tab"
7. if the path under "Moive to Physical file name" is pointing to another folder than the actual folder change the same (other wise thros err stating "Move ... Physical file ...." some thing like this"
8. also you can select "Force restore over existing database"
Regards
KP
|
|
|
|
|
hi KP
thank you very much
it works
regads
chandru
|
|
|
|
|
Hi KP
Thank you very much
it worked
regards
chandru
|
|
|
|
|
From Enterprise Manager
do backUp Database
and restore but with another name and in option tab do the right location.
Take ofline and Bring on line is not such great idea.
backup and restore is option for such task
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
