Running ACT! 2008 Database on two Laptops

Hi guys,
Hope some of you SQL database experts out there can help me, 'cos at the
moment I'm going mad!
I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
my own (Vista) and the other is a company laptop. I can't synchronse using a
network connection between the two machines because the work laptop has all
manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
off that ACT! 2008 can only synchronise using a network connection. When I
bought ACT! 2008 I was told synchronisation is really simple. Can't use the
Internet sync as this is only available with ACT! for Workgroups.
I suddenly thought of the ideal solution; as I am the only user and I only
want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
and use that on either Laptop - very simple, convenient and actually even
easier than having to connect the two laptops to synchronise.
You guessed it - bloody problems, I can copy the Database onto the memory
stick and access it from the comuter that saved it.
If I try to open it from the OTHER Laptop I get an error message that I am
unable to open the database and to check my network connections, SQL Server
etc!!
Help, I'm going mad, there must surely be a simple solution to allow me to
transfer the Database backwards and forwards quickly between the two
machines using the memory stick?
Thanks in advance,
Best Regards,
Charles
Hi Charles
You don't say how you have restored the database on the second machine? My
guess is that the login you have created on the restoring machine is either
not present has been orphaned, and that is why you can not connect. You could
use SQL Profiler on the machine that works to see how it connects.
John
"Charles Turner" wrote:

> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
> my own (Vista) and the other is a company laptop. I can't synchronse using a
> network connection between the two machines because the work laptop has all
> manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use the
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Server
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>
|||Merge repl will give you grief and may cause app to fail. Merge adds a
rowguid column to each replicated table. Bi-directional trans repl will work
for you - but the admin overhead may cause headaches.
I've worked w/ act before - they finally have the db in sql which is a huge
improvement, but there is still some growing pains.
You really need to contact act support - or find an act consultant and have
heshe develop a customized solution for you.
Good Luck.
ChrisB MCDBA
MSSQLConsulting.com
"Charles Turner" wrote:

> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
> my own (Vista) and the other is a company laptop. I can't synchronse using a
> network connection between the two machines because the work laptop has all
> manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use the
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Server
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>

Running ACT! 2008 Database on two Laptops

Hi guys,
Hope some of you SQL database experts out there can help me, 'cos at the
moment I'm going mad!
I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
my own (Vista) and the other is a company laptop. I can't synchronse using a
network connection between the two machines because the work laptop has all
manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
off that ACT! 2008 can only synchronise using a network connection. When I
bought ACT! 2008 I was told synchronisation is really simple. Can't use the
Internet sync as this is only available with ACT! for Workgroups.
I suddenly thought of the ideal solution; as I am the only user and I only
want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
and use that on either Laptop - very simple, convenient and actually even
easier than having to connect the two laptops to synchronise.
You guessed it - bloody problems, I can copy the Database onto the memory
stick and access it from the comuter that saved it.
If I try to open it from the OTHER Laptop I get an error message that I am
unable to open the database and to check my network connections, SQL Server
etc!!
Help, I'm going mad, there must surely be a simple solution to allow me to
transfer the Database backwards and forwards quickly between the two
machines using the memory stick?
Thanks in advance,
Best Regards,
Charles
Hi Charles
You don't say how you have restored the database on the second machine? My
guess is that the login you have created on the restoring machine is either
not present has been orphaned, and that is why you can not connect. You could
use SQL Profiler on the machine that works to see how it connects.
John
"Charles Turner" wrote:

> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
> my own (Vista) and the other is a company laptop. I can't synchronse using a
> network connection between the two machines because the work laptop has all
> manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use the
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Server
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>
|||Merge repl will give you grief and may cause app to fail. Merge adds a
rowguid column to each replicated table. Bi-directional trans repl will work
for you - but the admin overhead may cause headaches.
I've worked w/ act before - they finally have the db in sql which is a huge
improvement, but there is still some growing pains.
You really need to contact act support - or find an act consultant and have
heshe develop a customized solution for you.
Good Luck.
ChrisB MCDBA
MSSQLConsulting.com
"Charles Turner" wrote:

> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
> my own (Vista) and the other is a company laptop. I can't synchronse using a
> network connection between the two machines because the work laptop has all
> manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use the
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Server
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>

Running ACT! 2008 Database on two Laptops

Hi guys,

Hope some of you SQL database experts out there can help me, 'cos at the
moment I'm going mad!

I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
my own (Vista) and the other is a company laptop. I can't synchronse using a
network connection between the two machines because the work laptop has all
manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
off that ACT! 2008 can only synchronise using a network connection. When I
bought ACT! 2008 I was told synchronisation is really simple. Can't use the
Internet sync as this is only available with ACT! for Workgroups.

I suddenly thought of the ideal solution; as I am the only user and I only
want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
and use that on either Laptop - very simple, convenient and actually even
easier than having to connect the two laptops to synchronise.

You guessed it - bloody problems, I can copy the Database onto the memory
stick and access it from the comuter that saved it.

If I try to open it from the OTHER Laptop I get an error message that I am
unable to open the database and to check my network connections, SQL Server
etc!!

Help, I'm going mad, there must surely be a simple solution to allow me to
transfer the Database backwards and forwards quickly between the two
machines using the memory stick?

Thanks in advance,

Best Regards,

CharlesCharles Turner wrote:

Quote:

Originally Posted by

Hi guys,
>
Hope some of you SQL database experts out there can help me, 'cos at the
moment I'm going mad!
>
I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one

Did you cross-post to enough groups? What do Postgres and MySQL have to do
with your question?

(followup set)

--
Lew|||I hate people like that -.-
Troll-by-ignorance...

Lew wrote:

Quote:

Originally Posted by

Charles Turner wrote:

Quote:

Originally Posted by

>Hi guys,
>>
>Hope some of you SQL database experts out there can help me, 'cos at
>the moment I'm going mad!
>>
>I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one

>
Did you cross-post to enough groups? What do Postgres and MySQL have to
do with your question?
>
(followup set)
>

sql

Running ACT! 2008 Database on two Laptops

Hi guys,
Hope some of you SQL database experts out there can help me, 'cos at the
moment I'm going mad!
I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
my own (Vista) and the other is a company laptop. I can't synchronse using a
network connection between the two machines because the work laptop has all
manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
off that ACT! 2008 can only synchronise using a network connection. When I
bought ACT! 2008 I was told synchronisation is really simple. Can't use the
Internet sync as this is only available with ACT! for Workgroups.
I suddenly thought of the ideal solution; as I am the only user and I only
want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
and use that on either Laptop - very simple, convenient and actually even
easier than having to connect the two laptops to synchronise.
You guessed it - bloody problems, I can copy the Database onto the memory
stick and access it from the comuter that saved it.
If I try to open it from the OTHER Laptop I get an error message that I am
unable to open the database and to check my network connections, SQL Server
etc!!
Help, I'm going mad, there must surely be a simple solution to allow me to
transfer the Database backwards and forwards quickly between the two
machines using the memory stick?
Thanks in advance,
Best Regards,
Charles
Hi Charles
You don't say how you have restored the database on the second machine? My
guess is that the login you have created on the restoring machine is either
not present has been orphaned, and that is why you can not connect. You could
use SQL Profiler on the machine that works to see how it connects.
John
"Charles Turner" wrote:

> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
> my own (Vista) and the other is a company laptop. I can't synchronse using a
> network connection between the two machines because the work laptop has all
> manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use the
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Server
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>
|||Merge repl will give you grief and may cause app to fail. Merge adds a
rowguid column to each replicated table. Bi-directional trans repl will work
for you - but the admin overhead may cause headaches.
I've worked w/ act before - they finally have the db in sql which is a huge
improvement, but there is still some growing pains.
You really need to contact act support - or find an act consultant and have
heshe develop a customized solution for you.
Good Luck.
ChrisB MCDBA
MSSQLConsulting.com
"Charles Turner" wrote:

> Hi guys,
> Hope some of you SQL database experts out there can help me, 'cos at the
> moment I'm going mad!
> I want to use ACT! 2008 which uses MSSQL on 2 Laptops, (Vista & XP) one is
> my own (Vista) and the other is a company laptop. I can't synchronse using a
> network connection between the two machines because the work laptop has all
> manner of hidden firewalls etc. so this is not an option. I'm really pi**ed
> off that ACT! 2008 can only synchronise using a network connection. When I
> bought ACT! 2008 I was told synchronisation is really simple. Can't use the
> Internet sync as this is only available with ACT! for Workgroups.
> I suddenly thought of the ideal solution; as I am the only user and I only
> want to use ACT! on 2 Laptops I simply save the Database onto a Memory Stick
> and use that on either Laptop - very simple, convenient and actually even
> easier than having to connect the two laptops to synchronise.
> You guessed it - bloody problems, I can copy the Database onto the memory
> stick and access it from the comuter that saved it.
> If I try to open it from the OTHER Laptop I get an error message that I am
> unable to open the database and to check my network connections, SQL Server
> etc!!
> Help, I'm going mad, there must surely be a simple solution to allow me to
> transfer the Database backwards and forwards quickly between the two
> machines using the memory stick?
> Thanks in advance,
>
> Best Regards,
>
> Charles
>

Running a SQL file from OSQL command line utility

Hi,
I have dumped a very large database from mysql (using mysqldump program)
as a raw sql file. The reason was, convert this database to a MSSQL
database. Since mysqldump creates the file as raw sql file with the
database-table structures and the data in it, I thought using OSQL command
line utilities should work to out this whole database in MSSQL server.
I have run this command from command line:
osql -u sa -i mysqldump.sql
It is going since yesterday. It has been almost 36 hours that it's
started. And in the mssql server, I see no database created yet. On the
screen of the command line, I see bunch of numbers are going in order. I
assume they are row numbers of the tables processed. But, if it is doing it,
then where is it saving all this data ? I have checked the tempdb, pub db,
other dbs, and I see no tables related to the database I am inserting. Will
it populate it at the and of the job ? Or, am I doing something wrong here
?
Regards.
Murtix.Hi Murtix
You cannot load into SQL Server anything other than a SQL Server backup.
Is mysqldump the actual backup file? If so, then what you are seeing in the
line number is osql thinking it is receiving a command, and it keep
receiving them, waiting to receive a 'go' to tell it to execute what it has
received. It will not even try to process whatever bits are in the mysqldump
file until it finally encounters a 'go'.
The contents of an input file passed to osql (with -i) needs to be a SQL
script, containing valid Transact-SQL statements. Even if you had a valid
SQL Server backup file, the input file to osql would have to be script in
the TSQL language telling SQL Server to restore a specified backup file, you
could not just pass in the backup file itself.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Murtix Van Basten" <nospam@.nospam.org> wrote in message
news:3fee42a7$1_3@.athenanews.com...
> Hi,
> I have dumped a very large database from mysql (using mysqldump
program)
> as a raw sql file. The reason was, convert this database to a MSSQL
> database. Since mysqldump creates the file as raw sql file with the
> database-table structures and the data in it, I thought using OSQL command
> line utilities should work to out this whole database in MSSQL server.
> I have run this command from command line:
> osql -u sa -i mysqldump.sql
> It is going since yesterday. It has been almost 36 hours that it's
> started. And in the mssql server, I see no database created yet. On the
> screen of the command line, I see bunch of numbers are going in order. I
> assume they are row numbers of the tables processed. But, if it is doing
it,
> then where is it saving all this data ? I have checked the tempdb, pub db,
> other dbs, and I see no tables related to the database I am inserting.
Will
> it populate it at the and of the job ? Or, am I doing something wrong
here
> ?
> Regards.
> Murtix.
>|||Hi ,
You cant use that file (generated using MYSQLDUMP) directly in MSSQL using
OSQL. This raw file can be used only in MYSQL incase you need a recovary.
OSQL program can take only TSQL commands.
The solution for you is:
1. Create a database in MSSQL server Manually
2. Use DTS to transfer Tables to MSSQL Server
If your table size is very huge , generate a text file in MYSQL for each
tables and use BCP IN to load inside MSSQL.
Thanks
Hari
MCDBA
"Murtix Van Basten" <nospam@.nospam.org> wrote in message
news:3fee42a7$1_3@.athenanews.com...
> Hi,
> I have dumped a very large database from mysql (using mysqldump
program)
> as a raw sql file. The reason was, convert this database to a MSSQL
> database. Since mysqldump creates the file as raw sql file with the
> database-table structures and the data in it, I thought using OSQL command
> line utilities should work to out this whole database in MSSQL server.
> I have run this command from command line:
> osql -u sa -i mysqldump.sql
> It is going since yesterday. It has been almost 36 hours that it's
> started. And in the mssql server, I see no database created yet. On the
> screen of the command line, I see bunch of numbers are going in order. I
> assume they are row numbers of the tables processed. But, if it is doing
it,
> then where is it saving all this data ? I have checked the tempdb, pub db,
> other dbs, and I see no tables related to the database I am inserting.
Will
> it populate it at the and of the job ? Or, am I doing something wrong
here
> ?
> Regards.
> Murtix.
>|||I see.
Thanks.
It is a mysqldump file so, there is not any t-sql scripts in it. (AFAIK
T-SQL is only being used by MSSQL, and I dont think mysql could create a
raw-sql file in that format) That means I have been doing nothing :-(.
But just of a curiosity. what is the numbers I am seeing on the screen
though ? I mean, could you tell me what is the computer processing now ?
Murtix.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eqe$00OzDHA.1676@.TK2MSFTNGP12.phx.gbl...
> Hi Murtix
> You cannot load into SQL Server anything other than a SQL Server backup.
> Is mysqldump the actual backup file? If so, then what you are seeing in
the
> line number is osql thinking it is receiving a command, and it keep
> receiving them, waiting to receive a 'go' to tell it to execute what it
has
> received. It will not even try to process whatever bits are in the
mysqldump
> file until it finally encounters a 'go'.
> The contents of an input file passed to osql (with -i) needs to be a SQL
> script, containing valid Transact-SQL statements. Even if you had a valid
> SQL Server backup file, the input file to osql would have to be script in
> the TSQL language telling SQL Server to restore a specified backup file,
you
> could not just pass in the backup file itself.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Murtix Van Basten" <nospam@.nospam.org> wrote in message
> news:3fee42a7$1_3@.athenanews.com...
> > Hi,
> >
> > I have dumped a very large database from mysql (using mysqldump
> program)
> > as a raw sql file. The reason was, convert this database to a MSSQL
> > database. Since mysqldump creates the file as raw sql file with the
> > database-table structures and the data in it, I thought using OSQL
command
> > line utilities should work to out this whole database in MSSQL server.
> >
> > I have run this command from command line:
> >
> > osql -u sa -i mysqldump.sql
> >
> > It is going since yesterday. It has been almost 36 hours that it's
> > started. And in the mssql server, I see no database created yet. On the
> > screen of the command line, I see bunch of numbers are going in order. I
> > assume they are row numbers of the tables processed. But, if it is doing
> it,
> > then where is it saving all this data ? I have checked the tempdb, pub
db,
> > other dbs, and I see no tables related to the database I am inserting.
> Will
> > it populate it at the and of the job ? Or, am I doing something wrong
> here
> > ?
> >
> > Regards.
> >
> > Murtix.
> >
> >
>|||Hi Hari,
all the pain I suffered to do this, was because of not to use BCP method.
I guess I will have to use it after finding out osql methid would not work.
Thank you clearifying this issue for me.
Best Regards.
Murtix.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:Oaj1x2OzDHA.1412@.TK2MSFTNGP11.phx.gbl...
> Hi ,
> You cant use that file (generated using MYSQLDUMP) directly in MSSQL using
> OSQL. This raw file can be used only in MYSQL incase you need a recovary.
> OSQL program can take only TSQL commands.
> The solution for you is:
> 1. Create a database in MSSQL server Manually
> 2. Use DTS to transfer Tables to MSSQL Server
> If your table size is very huge , generate a text file in MYSQL for each
> tables and use BCP IN to load inside MSSQL.
> Thanks
> Hari
> MCDBA
>
>
>
> "Murtix Van Basten" <nospam@.nospam.org> wrote in message
> news:3fee42a7$1_3@.athenanews.com...
> > Hi,
> >
> > I have dumped a very large database from mysql (using mysqldump
> program)
> > as a raw sql file. The reason was, convert this database to a MSSQL
> > database. Since mysqldump creates the file as raw sql file with the
> > database-table structures and the data in it, I thought using OSQL
command
> > line utilities should work to out this whole database in MSSQL server.
> >
> > I have run this command from command line:
> >
> > osql -u sa -i mysqldump.sql
> >
> > It is going since yesterday. It has been almost 36 hours that it's
> > started. And in the mssql server, I see no database created yet. On the
> > screen of the command line, I see bunch of numbers are going in order. I
> > assume they are row numbers of the tables processed. But, if it is doing
> it,
> > then where is it saving all this data ? I have checked the tempdb, pub
db,
> > other dbs, and I see no tables related to the database I am inserting.
> Will
> > it populate it at the and of the job ? Or, am I doing something wrong
> here
> > ?
> >
> > Regards.
> >
> > Murtix.
> >
> >
>|||Murtix,
> It is a mysqldump file so, there is not any t-sql scripts in it.
> (AFAIK T-SQL is only being used by MSSQL, and I dont think mysql
> could create a raw-sql file in that format) That means I have
> been doing nothing :-(.
Please take a look at this product. It is probably the best solution
for your problem. You can download the evaluation version.
http://www.ispirer.com/products/
> But just of a curiosity. what is the numbers I am seeing on the
> screen though ? I mean, could you tell me what is the computer
> processing now ?
As Kalen said, osql is trying to interpret the file as a series of
T-SQL statements. The numbers you see are line numbers of "lines"
that osql has parsed. They can be suppressed wih the -n command line
switch.
Linda|||Hi Murtix
What exactly do you mean by 'raw' sql file? SQL is a language, so the only
thing I can think of 'raw' SQL meaning is a file of ANSI standard SQL
commands.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Murtix Van Basten" <nospam@.nospam.org> wrote in message
news:3fee4677$1_1@.athenanews.com...
> I see.
> Thanks.
> It is a mysqldump file so, there is not any t-sql scripts in it. (AFAIK
> T-SQL is only being used by MSSQL, and I dont think mysql could create a
> raw-sql file in that format) That means I have been doing nothing :-(.
> But just of a curiosity. what is the numbers I am seeing on the screen
> though ? I mean, could you tell me what is the computer processing now ?
> Murtix.
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:eqe$00OzDHA.1676@.TK2MSFTNGP12.phx.gbl...
> > Hi Murtix
> >
> > You cannot load into SQL Server anything other than a SQL Server backup.
> >
> > Is mysqldump the actual backup file? If so, then what you are seeing in
> the
> > line number is osql thinking it is receiving a command, and it keep
> > receiving them, waiting to receive a 'go' to tell it to execute what it
> has
> > received. It will not even try to process whatever bits are in the
> mysqldump
> > file until it finally encounters a 'go'.
> >
> > The contents of an input file passed to osql (with -i) needs to be a SQL
> > script, containing valid Transact-SQL statements. Even if you had a
valid
> > SQL Server backup file, the input file to osql would have to be script
in
> > the TSQL language telling SQL Server to restore a specified backup file,
> you
> > could not just pass in the backup file itself.
> >
> > --
> > HTH
> > --
> > Kalen Delaney
> > SQL Server MVP
> > www.SolidQualityLearning.com
> >
> >
> > "Murtix Van Basten" <nospam@.nospam.org> wrote in message
> > news:3fee42a7$1_3@.athenanews.com...
> > > Hi,
> > >
> > > I have dumped a very large database from mysql (using mysqldump
> > program)
> > > as a raw sql file. The reason was, convert this database to a MSSQL
> > > database. Since mysqldump creates the file as raw sql file with the
> > > database-table structures and the data in it, I thought using OSQL
> command
> > > line utilities should work to out this whole database in MSSQL server.
> > >
> > > I have run this command from command line:
> > >
> > > osql -u sa -i mysqldump.sql
> > >
> > > It is going since yesterday. It has been almost 36 hours that it's
> > > started. And in the mssql server, I see no database created yet. On
the
> > > screen of the command line, I see bunch of numbers are going in order.
I
> > > assume they are row numbers of the tables processed. But, if it is
doing
> > it,
> > > then where is it saving all this data ? I have checked the tempdb, pub
> db,
> > > other dbs, and I see no tables related to the database I am inserting.
> > Will
> > > it populate it at the and of the job ? Or, am I doing something wrong
> > here
> > > ?
> > >
> > > Regards.
> > >
> > > Murtix.
> > >
> > >
> >
> >
>|||Murtix Van Basten (nospam@.nospam.org) writes:
> It is a mysqldump file so, there is not any t-sql scripts in it. (AFAIK
> T-SQL is only being used by MSSQL, and I dont think mysql could create a
> raw-sql file in that format) That means I have been doing nothing :-(.
> But just of a curiosity. what is the numbers I am seeing on the screen
> though ? I mean, could you tell me what is the computer processing now ?
OSQL is also intended to be a interactive utility, so when you start
OSQL without the -i switch, you can enter commands. The 1>, 2> etc are
the command prompts, one per line. As Linda said, you can use -n to
suppress these. You can also use -o to redirect output to a file, so
you can look at the error messages.
However, since MySQL is not like to generate SQL suitable for MS SQL Server,
the whole operation appears to be a fruitless one. You could possibly use
the file, but you would have to edit it manually to address changes
between the SQL dialects and to insert GO statements to separate
batches.
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Run DTS in safe way.

I have two servers: progress as transational server and mssql as warehouse
server.

I did DTS that "pumps" data from progress to mssql (via ODBC). Copying the
data has to be done once a day, but sometimes there is a need to do it on
user's demand.

I'd like to ensure that I properly understood the method of running DTS I've
just found using Google.

As I can see, there are at least two methods (except of scheduling):

- using dtsrun - which requires user running the DTS to have admin
privileges to use xp_smdshell

- using sp_start_job - which requires creating a job prior to running the
DTS.

I think of using the second one as it seems to be more secure - am I right?
Are there any hidden traps? What else should I do?

--
PL
(remove "nie.spamuj.bo.w.ryj" from my email address)"Piotr Lipski" <piotr.lipski@.nie.poczta.spamuj.onet.bo.pl.w.ryj> wrote in
message news:d42s9j$f6n$1@.news.onet.pl...
>I have two servers: progress as transational server and mssql as warehouse
> server.
> I did DTS that "pumps" data from progress to mssql (via ODBC). Copying the
> data has to be done once a day, but sometimes there is a need to do it on
> user's demand.
> I'd like to ensure that I properly understood the method of running DTS
> I've
> just found using Google.
> As I can see, there are at least two methods (except of scheduling):
> - using dtsrun - which requires user running the DTS to have admin
> privileges to use xp_smdshell
> - using sp_start_job - which requires creating a job prior to running the
> DTS.
> I think of using the second one as it seems to be more secure - am I
> right?
> Are there any hidden traps? What else should I do?
> --
> PL
> (remove "nie.spamuj.bo.w.ryj" from my email address)

There are a number of ways to run a package:

http://www.sqldts.com/default.aspx?104

To run xp_cmdshell, you don't need sysadmin privileges if you configure a
proxy account - see xp_sqlagent_proxy_account in Books Online - although
even using a proxy, it may still be too risky in some environments.
sp_start_job is also a problem, because you can only start a job that you
own yourself (unless you're a sysadmin, of course).

One solution is that a user INSERTs into a queue/request table to indicate
that they want to run the package. A scheduled job can then run every few
seconds/minutes/hours, and if the row is in the table (or the flag column is
set etc), then it runs the package. This avoids giving any special
permissions to users.

Simon|||I would definatly reccomend using the SQL server agent and SP_Start_Job
as you get all the logging features for the agent - you get protection
against running the same DTS package 2 times at once. You can get
e-mail notification when the job has finished or failed or whatever.

I also like the idea of having a requests table - i may consider
however create a trigger on the table that executes the sp_start_job
stored procedure instead of creating a polling process. It all depends
on how much complexity you can afford and how much tracking / logging
you require.

One of my customers has many DTS packages used for loading data in to a
data warehouse. When a busniess manager receives some new data from a
data provider they simply place the data on a shared drive and run the
DTS package. I created a simple ASP.NET web application that lists the
DTS packages available and shows the status of each as in the
enterprise manager..

in 2 days i had a fully functional system with simple access
permissions and admin screens. If you want to a similar thing look for
these stored procedures.

msdb.dbo.sp_help_job
msdb.dbo.sp_start_job
msdb.dbo.sp_stop_job