SQL question

[Richard]

Hi forum,

I have a table structure on a SQL server, its basically empty except for
some test data. My real data is on a shared computer in our warehouse. My
question is can I move my data from the shared tables to the tables on the
SQL? I was thinking of using a append query to do this. Or would it be better
just to drop a new BE on the SQL.

Thanks
Richard

 

[Albert D. Kallal]

Hi forum,

I have a table structure on a SQL server, its basically empty except for
some test data. My real data is on a shared computer in our warehouse. My
question is can I move my data from the shared tables to the tables on the
SQL? I was thinking of using a append query to do this. Or would it be
better
just to drop a new BE on the SQL.

Thanks
Richard

It not clear what you mean by drop a new BE on the SQL? (you can't really
do that).

If you are trying to move data between two different instances of sql
server,
then use the sql server backup option. You can't really just "copy" files
between instances of sql server as those files have all kinds of log files,
and even perhaps records might be waiting to be committed to the actual
files
that reside on the disk drive. (so, best use the tools in sql server to
create a backup).

If it just a table of data, then sure, you could pull the
data down into ms-access by using file->get external data and import from
sql server at one location. You then take that mdb (access) file with you
and then simply import this table to that running instance of sql server
(you don't really have to use ms-access as the go-between here).

if you do use a mdb file, then you can ether upsize that table on the other
machine, or use the sql import option.

It usually best to use a backup created by sql server or even the bulk copy
options.